Scribd
Upload
93 views3 pages

Address Verification in Informatica Cloud

This guide explains how to perform address verification in Informatica Cloud using external APIs, detailing two methods: real-time validation through Informatica Cloud Application Integration (CAI) and batch processing with Informatica Cloud Data Integration (CDI). It outlines steps for integrating various address verification APIs, including creating service connectors, defining request/response parameters, and handling validation results. The document emphasizes the flexibility of Informatica Cloud in ensuring valid and standardized addresses for data processing needs.

Uploaded by

Aravind reddy Kn
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
93 views3 pages

Address Verification in Informatica Cloud

This guide explains how to perform address verification in Informatica Cloud using external APIs, detailing two methods: real-time validation through Informatica Cloud Application Integration (CAI) and batch processing with Informatica Cloud Data Integration (CDI). It outlines steps for integrating various address verification APIs, including creating service connectors, defining request/response parameters, and handling validation results. The document emphasizes the flexibility of Informatica Cloud in ensuring valid and standardized addresses for data processing needs.

Uploaded by

Aravind reddy Kn
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Detailed Guide: Address Verification in Informatica Cloud

Introduction
Informatica Cloud Data Quality (CDQ) does not have a direct built-in Address Validation
transformation, so integrating an external address verification service is a viable solution. This guide
walks through two methods: using external address APIs in Informatica Cloud Application
Integration (CAI) and batch address validation with Informatica Cloud Data Integration (CDI).

Method 1: Using Address Verification APIs in CAI


To validate addresses in real-time, we can integrate external Address Verification APIs like:
- Loqate (GBG) Address Verification
- Melissa Data API
- Google Maps API
- SmartyStreets API
- AddressDoctor API (if enabled)

### Steps to Integrate Address Verification API into CAI:


1. **Create a Service Connector** in Informatica Cloud (CAI):
- Go to Application Integration > Service Connectors.
- Click 'Create New Service Connector' and choose 'REST API'.
- Enter the API Base URL of the Address Verification service.

2. **Define Request and Response Parameters**:


- Request: StreetAddress, City, State, PostalCode, Country.
- Response: ValidatedAddress, ValidationStatus (Valid/Invalid), ErrorMessage.

3. **Test the Connection** to verify API access and ensure parameters are correct.

4. **Create a Process** in CAI to check address validity:


- Go to Processes > Create New Process.
- Add input fields for address parameters.
- Add a Service Call Step and map fields to request parameters.
- Add a Decision Step to check ValidationStatus and handle success or failure.
5. **Expose the Process as a REST API** to allow other applications to use it for validation.

Method 2: Batch Address Verification Using CDI


For batch processing of address data, you can use Informatica Cloud Data Integration (CDI) along
with an external API for validation.

### Steps for Batch Address Verification using CDI:


1. **Create a Mapping** in CDI to read address data from a flat file or database.
2. **Add a REST Web Service Connector** to call the external Address Verification API.
- Use a REST Connector to call the Address Verification API for each address in the dataset.
- Map fields like StreetAddress, City, State, PostalCode, and Country.

3. **Process API Response** to handle the returned data such as validation status, corrected
address, and error messages.
4. **Store Validated Addresses**: Write back the corrected addresses or validation results into the
target database or file.

5. **Error Handling**: For invalid addresses, you can route them to an error file or process them for
manual review.

Example API Input & Response


Input (API Request):
{
"StreetAddress": "1600 Amphitheatre Parkway",
"City": "Mountain View",
"State": "CA",
"PostalCode": "94043",
"Country": "USA"
}

Response (API Output):


{
"ValidatedAddress": "1600 Amphitheatre Pkwy, Mountain View, CA 94043, USA",
"ValidationStatus": "Valid",
"ErrorMessage": ""
}

Conclusion
Informatica Cloud provides a flexible way to validate addresses, either in real-time through CAI with
external address verification APIs, or in batch processing through CDI. By integrating APIs from
external providers like Loqate, Melissa, Google, or others, you can ensure that addresses are valid
and standardized for your application or data processing needs.

You might also like