Problem Note 69827: Datapack Migration to Loqate for US/Canada reference data used with DataFlux® Data Management Studio and DataFlux® Data Management Server
 |  |  |  |  |
This SAS Note contains information about the datapack migration to Loqate for US/Canada reference data. It contains the following sections:
- Updates That Are No Longer Available
- Loqate Datapacks
- PhonePlus Datapack
- Affected DataFlux Nodes
- Migration Instructions
- Required Patches
Updates That Are No Longer Available
As of July 31st, 2023 SAS no longer provides updates for the following US/Canada address and geocode datapacks:
- US Address Verification (USPS)
- SAS Data Management Datapack US Address
- Canada Address Verifcation (Canada Post SERP)
- SAS Data Management Datapack Canada Address
- North America Postal Level Geocode (includes PhonePlus)
- SAS Data Management Datapack US Postal Level Geocode
- SAS Data Management Datapack Canada Geocode
- SAS Data Management Datapack North American Postal Level Geocode
- SAS Data Management Datapack North American PhonePlus
- US Street Level Geocode
- SAS Data Management Datapack US Street Level Geocode
Loqate Datapacks
Users who wish to perform tasks in DataFlux that rely on US/Canada address and geocode reference data must migrate to the following Loqate datapacks that are used with the Loqate node before July 31st, 2023:
- Loqate Data (includes Canada)
- SAS DataPack Canada Address Verification
- SAS DataPack Canada Geocode
- Loqate US Data
- SAS Data Management Datapack United States Address Verification
- SAS DataPack US Geocode
PhonePlus Datapack
Users who wish to perform tasks in DataFlux that rely on the PhonePlus reference data, must use the following new PhonePlus datapack:
- North America PhonePlus
- SAS Data Management Datapack North American PhonePlus
Affected DataFlux Nodes
The following DataFlux nodes are affected by this change:
Data Job Nodes
- Address Update Lookup
- Address Verification (US/Canada)
- Geocoding
- Street-level Geocoding
- US City / State/ ZIP Validation
- County
- US City / State/ ZIP Lookup
- Phone
- Area Code
- Canadian Postal Lookup
- Distributed Geocoding
- Distributed Address Verification
- Distributed Phone
- Distributed Area Code
- Distributed County
Process Job Nodes
- Address Update Audit Report
- Address Update Monthly Reports
- Address Update Process Summary Report
The functionality exposed by the Tools ► Verify Individual US Canadian Address and Address Update: NCOALink PAF Administration menu options are also affected.
Migration Instructions
For detailed migration instructions, see the DataFlux® Data Management Studio and Server 2.9: Migration Guide for Data Packs.
Required Patches
Note: The migration patches are available only for DataFlux Data Management Studio and DataFlux Data Management Server 2.7 and later.
As part of the migration process, you must apply patches to DataFlux Data Management Studio and DataFlux Data Management Server to enable the Loqate node and Loqate reference data for US and Canada to be used in DataFlux.
Click the Hot Fix tab in this note to access the hot fix for this issue.
If you have any questions related to the DataFlux Datapack migration to Loqate, contact your account manager.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| Dataflux | N/A | N/A | ||