Explore LABS


A4.1 - US NCOA processing in matchIT SQL

Previous Article Addresing section Next Article 


GenerateNCOAAddresses can be used to keep your database up-to-date as your customers move or their addresses are corrected.  Note that this is available to licensed users only, and can only process US data. This is licensed as an additional module to matchIT SQL and requires you have matchIT SQL and the addressing module first in order to access this module.


GenerateNCOAAddresses is available as both a stored procedure and an SSIS task.  The process involves sending data from the input table to an online service, and writing the received processed data into an output table for subsequent processing and use.  (Please see the Security Protocol for further information.)


Input Parameters:

  • Configuration file – the file path of the configuration file to be used when this procedure is run.
  • Datasource ID – specifies the data source to be used within the configuration file, which contains the table and column mapping specifications.


Stored Procedure

When running as a stored procedure, the data source is used to configure the input table and field mappings that are passed to the NCOA service.  If this will follow GenerateCorrectedAddresses, be sure to use the corrected addresses table and its columns as inputs to the NCOA service.

To use the output NCOA tables and columns in following stored procedures (i.e. GenerateKeys), no further configuration is necessary because the stored procedure will be able to determine existence of the NCOA table and automatically make use of it.



When running as an SSIS task, the user has a choice of how the input table and mappings are obtained: from a preceding GenerateKeys task (in which case no extra configuration is necessary), from a preceding GenerateCorrectedAddresses task (in which case only the required name fields need mapping, while the corrected addresses are automatically used), or via manual configuration of the connection string, tables, and columns.

To use the output NCOA tables and columns in following tasks (i.e. GenerateKeys), it is necessary to map the table and its columns in the task.






Specifies the database connection, table and column mappings used to define the dataset being processed.


List processor full name.


List processor street address.


List processor city, state, ZIP.


List processor telephone number.


Mailer full name.


Mailer street address.


Mailer city, state, ZIP.


Mailer telephone number.


Can be used to specify the name of the table that will be created.  If this is left blank, then the table’s name will be automatically generated.


Any of these fields can be written to the output table. (See Optional Output Fields below.)


If this is set to "true", data is returned in mixed-case format. If this is set to "false", result data is returned in all upper case characters.


If this is set to "true", alias street names are returned when they are used in the input. If this is set to "false", 'official' street names are returned even when alias street names are used in the input.

(An alias street name is an alternative name for a street that is acceptable to the USPS. It may be a name by which a street was formerly known, a commonly-used nickname for the street, or one the community prefers to use.)


If this is set to “true”, and GenerateCorrectedAddresses has been run beforehand, then only valid addresses (with a score of 0) are processed by the NCOA service.


Data is uploaded to the NCOA service in ‘blocks’.  This setting specifies the maximum number of records per block.


The maximum time to allow for every 100,000 records processed, in minutes (the default is 15).

This should be increased if you have a slow internet connection or are experiencing timeouts.

Timeouts can be disabled by specifying 0.


The maximum number of retry attempts when processing has failed (the default is 1).  Specify 0 to disable retry attempts.

Previous Article Addresing section Next Article


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.