Installation and Getting Started Guide (On-Premises)

5.16.4
- 5.9.0
- 5.8.1
- 5.8.0
- 5.16.3
- 5.16.2
- 5.16.1
- 5.16.0
- 5.15.0
- 5.14.0
- 5.13.0
- 5.12.0
- 5.11.0
- 5.10.0

Back Next

Reference Databases and Packages

Informatica reference databases are proprietary-format database files that contain reference addresses from countries and territories that Informatica supports for address verification. The reference databases are read-only and platform-independent.

The database file names have the following format:

DB5_XXXYZZZZ_NN_YYMMDD.zip

You can interpret the file names in the following way:

XXX

denotes the ISO 3166-1 alpha 3 code for the country or territory to which the reference data applies. For example,

USA

for the United States.

denotes the primary product version. For example,

ZZZZ

denotes the reference database type. For example,

for Batch and Interactive and

GCAP

for arrival point geocoding.

denotes the iteration of the file. Most files have the iteration number 01. Some countries use iteration numbers to identify files with additional data.

You download the files in compressed (zip) format. The zip file names follow a similar naming convention to the database file names. The zip file names also include the day, month, and year on which Informatica created the file.

Address Verification provides the following types of reference database:

BI: Batch and interactive data.

FC: Fast completion data.

Cx: Certified data. The x character represents a number. For example,
DB5_CAN5C1_01_150201.zip
contains a SERP-certified reference address database for Canada.

AC: Address code lookup data.

GC: Standard geocoding data.

GCAP: Arrival point geocoding data.

CA: CAMEO data.

Ex: Supplementary data. The x character represents a number. For example,
DB5_FRA5E1_01_181101.zip
contains the supplementary reference address database for France address enrichments.

You might download multiple reference address databases for a country.

Most countries use a single version of each database file. However, a country might have multiple version of a file. An ID number such as

, or

, in the zip package name identifies the version of the database file.

For example, the reference data zip files that you can download for Australia can include the two-digit codes _01 and _02 in the file names. Select the _02 version of the file to download reference data that includes sub-building data. Select the _01 version of the file to download reference data without sub-building data.

Unlock Codes

You need valid unlock codes for the database that you download.

The following table describes the unlock code types that the databases require:

Unlock Code Type	Description
VALIDATION	Unlock code for batch and interactive and fast completion databases.
GEO_STANDARD	Unlock code for standard geocoding databases.
GEO_ARRIVAL_POINT	Unlock code for arrival point geocoding databases.
CAMEO	Unlock code for CAMEO databases.
ADDRESS_CODE_LOOKUP	Unlock code for address code lookup databases.
SINGLE_LINE_VALIDATION	Unlock code for single line address validation feature.
SUPPLEMENTARY	Unlock code for supplementary databases that contain information about country-specific enrichments.

Rename Saved Search

Table of Contents

Installation and Getting Started Guide (On-Premises)

Installation and Getting Started Guide (On-Premises)

Reference Databases and Packages

Reference Databases and Packages

Unlock Codes