What is NCOALink in SAP EIM-DS - Data Services?

SAP Term: NCOALink

• Component: EIM-DS

• Component Name: Data Services

• Description: A USPS product consisting of a secured database of approximately 160 million change of address COA records consisting of the names and addresses of individuals, families, and businesses who have filed a change of address with the USPS.

Smart SAP Assistant

• Key Concepts: 
  NCOALink is a component of SAP Data Services that helps organizations keep their customer data up-to-date. It uses the National Change of Address (NCOA) database to identify and update customer addresses that have changed since the last time they were updated. This helps organizations maintain accurate customer data and reduce the amount of returned mail due to incorrect addresses. 
  
  How to Use It: 
  NCOALink can be used to update customer addresses in SAP Data Services. To do this, the user must first create a job in Data Services Designer. The job should include an input table containing the customer data, an output table for the updated data, and a NCOALink transformation. The transformation will use the NCOA database to identify and update any addresses that have changed since the last time they were updated. 
  
  Tips & Tricks: 
  When using NCOALink, it is important to ensure that the input table contains all of the necessary information for the transformation to work correctly. This includes the customer’s name, address, city, state, and zip code. Additionally, it is important to check the output table after running the job to make sure that all of the addresses have been updated correctly. 
  
  Related Information: 
  For more information on NCOALink and how to use it in SAP Data Services, please refer to the official SAP documentation here: https://help.sap.com/viewer/product/SAP_DATA_SERVICES/4.2/en-US/f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9f3d7f9a8b6c14e8a9