Once the integration has been enabled, data can be sent and received via the EDQ Validation database
// Load data
insert into edq_validation.address_validation.<unique_customer_name>_input(ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3, CITY, STATE, POSTAL, COUNTRY)
values
('1600 Pennsylvania Avenue NW,'','','Washington','DC','20500','USA');
// Wait a few minutes (time dependent on volume), and see validation results
select * from edq_result.address_validation.<unique_customer_name>_output; //results share from Experian
select * from edq_validation.address_validation.<unique_customer_name>_input;
//Results in edq_validation database
| Field | Description |
|---|---|
| ID ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 CITY STATE POSTAL COUNTRY |
Original input. |
| VALIDATED_ADDRESS_LINE_1 VALIDATED_ADDRESS_LINE_2 VALIDATED_ADDRESS_LINE_3 VALIDATED_ADDRESS_CITY VALIDATED_ADDRESS_STATE VALIDATED_ADDRESS_POSTAL |
Validated and standardized output. |
| VALIDATED_ADDRESS_MATCH_RESULT | Validation result code indicating the level of data quality. |
| RESULT_TS | Time stamp of the returned results. |
// Load data
insert into edq_validation.email_validation.<unique_customer_name>_input(email)
values
('comments@whitehouse.gov')
// Wait a few minutes (time dependent on volume), and see validation results
select * from edq_result.email_validation.<unique_customer_name>_output; //results share from Experian
select * from edq_validation.email_validation.<unique_customer_name>_input;
//Results in edq_validation database
| Field | Description |
|---|---|
| ID |
Original input. |
| EDQ_CONFIDENCE EDQ_VERBOSE_CONFIDENCE EDQ_DOMAIN_TYPE |
Experian provided confidence of the deliverability of the email address. |
| EDQ_DOMAIN_TYPE | Identifies if an email address is associated with a consumer or business domain. |
| RESULT_TS | Time stamp of the returned results. |