Setting the schema and selecting an address provider - 7.1

Address standardization

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tBatchAddressRowCloud to display the Basic settings view and define the component properties.
  2. If required, click Sync columns to retrieve the schema defined in the input component.
  3. Click the Edit schema button to open the schema dialog box.
    tBatchAddressRowCloud proposes several predefined read-only address columns as shown in the below capture.
    The STATUS column returns the status of processing input addresses. For further information about process status, see Process status in tLoqateAddressRow.
    The AddressVerificationCode column returns the verification code for the processed address. For further information about what values this code is made up of and the implications of each segment, see Address verification codes in tLoqateAddressRow.
    The VerificationLevel output column provides you with a verification status of the processed addresses. For further information, see Address verification levels in tAddressRowCloud.
  4. Move any of the input columns to the output schema if you want to show them in the verification results, click OK and accept to propagate the changes.
    You can also add columns directly in the output schema to retrieve additional address information from the provider repository.
  5. Select from the Address Provider list the provider of the reference data against which you want to validate and format input addresses, Loqate in this example.
    You can also validate addresses against MelissaData online service.
  6. In the License/API key field, enter the license key provided by Loqate.
  7. In the Batch job name field, enter between quotation marks a name of your choice to give to the batch files that will be generated and saved on the Loqate server.
    Set the number of address records you want to group in each batch file in the Number of rows in each batch file field.
  8. Enter the login and password provided by Loqate in the Loqate website login and Loqate website password respectively.
  9. From the Processing Mode list, select:

    Option

    To...

    Verify and Geocode (selected by default)

    standardize and correct addresses and enrich them with latitude and longitude.

    Combining address verification and geocoding will cost extra credits. For further information, see Cloud Price Card.

    Verify only

    standardize and correct addresses without enriching them with latitude and longitude.