Migrating an ODBC connection (DataStage)

Use the use the --use-dsn-name parameter to update the odbc.ini file to migrate ODBC connections from traditional DataStage® to modern DataStage.

Each ODBC connection’s properties are configured in the odbc.ini file. In traditional DataStage, you specify the data source type as an entry name in the odbc.ini file with an optional username and password.

The odbc.ini file is not provided to the migration service. By default, the migration parses the data source type for the closest compatible data source in modern DataStage. Missing properties are handled by generating a parameter reference. If no clear data source is found or if the data source name is parameterized, then the default data source will be Db2®. You must then update the data source as needed and define the parameter reference values.

To streamline the migration, you can use the --use-dsn-name parameter. All the project information for the ODBC connection from traditional DataStage will remain intact without the need for generated parameters.

To use the --use-dsn-name parameter:
  1. Append the entries from the odbc.ini file in traditional DataStage into the odbc.ini file in the pxruntime cluster in Cloud Pak for Data. Use this path:

    /ds-storage/connectors/odbc/config/odbc.ini

    Important: Do not modify the existing templates in the odbc.ini file.
  2. Run the cpdctl dsjob migrate command with this parameter: --use-dsn-name.

Users can create a new ODBC connection by selecting Use DSN from ODBC configuration and entering credentials.