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
2025
First publish date
2025
ft:lastEdition
2025-12-23
ft:lastPublication
2025-12-23T14:29:47.977000
  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. Be sure to change the table name in the template to data_link_geox.
  4. Once the table structure has been created, copy the Oracle CTL template to the directory in which the product delivery file is located.
  5. Open the CTL file in a text editor. Add the path to the extracted data text file to the infile statement and replace Oracle destination table name with the name of the table created in Step 3.
    Note: The TRAILING NULLCOLS clause used in the CTL file instructs SQL Loader to treat any relatively positioned columns that are not present in the record as null columns.
  6. Open a Windows command prompt and enter the following: 
    sqlldr userid=<username>/<password>@<database_connection>
control=<path>/<ctl_file_name> skip=1 log=<path>/<log_file_name>

    Example 

    sqlldr userid=username/password@hostname/service control = 'D:\data_link\geox_precisely_data\DATA_LINK_GEOX_ORACLE_CTL_TEMPLATE.CTL'
 skip=1 log= 'D:\data_link\geox_precisely_data\datalink_geox.log'
  7. Data will begin loading into the database.