Procedure - data_link_for_geox - Latest

Data Link for GeoX Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Data Link
Product
Data Link for GeoX
Version
Latest
ft:locale
en-US
Product name
Data Link for GeoX
ft:title
Data Link for GeoX Getting Started Guide
Copyright
2026
First publish date
2025
ft:lastEdition
2026-01-30
ft:lastPublication
2026-01-30T14:01:21.293000
L1_Product_Gateway
Enrich
L2_Product_Segment
Data
L3_Product_Brand
Precisely Properties
L4_Investment_Segment
Precisely Addresses
L5_Product_Group
Property Features
L6_Product_Name
Data Link Addresses

  1. Download the product delivery file.
  2. Extract the delivery file to find the text data file.
  3. Create the table structure in the database using the Create Table script found here. Be sure to change the table name in the template to data_link_geox.
  4. If a new format (FMT) file needs to be created, please follow the steps found in https://msdn.microsoft.com/en-us/library/ms191516.aspx.
  5. Issue the following command: 
bcp <database_name>.dbo.<table_name> format nul -c -f
 <path>\format_file_name.fmt -t "|" -S -T

Syntax:

-T: Specifies that the bcp utility connects to SQL Server with a trusted connection using integrated security. If -T is not specified, the -U and -P parameters for username and password must be passed in order to log in.

-t "|": Specifies that the format file will be generated using the pipe character as a delimiter.

Example:

bcp datalink.dbo.data_link_geox
format nul -c -f C:\nationwide\geox_precisely_data\data_link_for_geox_usa.fmt 
 -t "|" –S –T
Note: Once the format file has been generated, \r needs to be removed from the file in order to load data successfully.