ODBC support for the remote engine

Follow this instruction to use the ODBC connection for a remote engine.

1. Download the docker image.
2. Create the directories ds-storage and px-storage to mount to the remote engine.
3. Download the rpm file to install cdata ODBC driver for the data source.
4. Run the docker container as the root user with the following command:

   docker run -d --user root --name <container_name> -p 9443:9443 -p 10003:10003 -p 10002:10002 -p 7777:7777 --hostname=hostname --env-file <env file path> -v <local path to px-storage>:/px-storage -v <local path to ds-storage>:/ds-storage <docker image name>

5. Instal unixODBC with the following command:

   microdnf -y install unixODBC

6. Copy the cdata ODBC driver rpm file into the docker container and install the driver with the following command:

   rpm –install <path to rpm file>

   The driver is installed in /opt/cdata/<driver name>.

7. Use the following command to see the files created during installation:

   rpm -qlp IBMDB2ODBCDriverforUnix.rpm

8. Move the driver to px-storage by copying the directory /opt/cdata/<driver name> .
9. Stop and restart the docker, but not as a root user. Confirm that the data driver is in the PX-storage location and not in the /opt/data.
10. Follow the instruction provided by cdata to activate the ODBC license.
11. To check the current ODBC configuration, use the following command:

    odbcinst -j

12. To confirm if a template for the DSN entry is appended to the file, check the odbc.ini file.
13. Update the DSN entry for the new datasource and save the odbc.ini file.
14. To use this DSN in the DataStage® flow, create a new ODBC connection with the following setup.
    1. For Data source type choose Use DSN from ODBC configuration.
    2. In the Data source name, provide the DSN name.
    For more information about creating connections, see Connecting to a data source in DataStage.