Connecting to data sources for DataStage

To connect to data sources that are not already supported by default, you must install the drivers for the data sources and then update the dsenv file to point to the location where the drivers are installed.

Procedure

To install drivers for unsupported data sources:

  1. Log in to your Red Hat® OpenShift® cluster as a project administrator:
    oc login OpenShift_URL:port
  2. Change to the project where the IBM® Cloud Pak for Data control plane is deployed:
    oc project Control_Plane_Project
  3. Download the driver for your data sources from your software vendor and copy the files into a mounted directory in the pod by issuing the following command:
    oc cp /home/drvfolder zen/is-en-conductor-0:/mnt/dedicated_vol/Engine/is-en-conductor-0/directory_name

    The command copies all the contents of the folder drvfolder (the driver folder) to the mnt/***/directory_name folder. For example, the directory_name might be DSEngine.

  4. Install the drivers that you copied into the mounted directory by running the executable files provided by the software vendor. To find the mounted directories, you can issue the findmnt command.
    Only drivers that can be installed in a mounted directory are supported.
  5. Update the dsenv file.
    This file is used to determine the location of the installed drivers. By default, this file is in a mounted folder and must stay in a mounted folder.
    1. Connect to engine pod by issuing the following command:
      oc exec -it is-en-conductor-0 bash
    2. Navigate to the /mnt/dedicated_vol/Engine/is-en-conductor-0/DSEngine/folder directory.

      The dsenv file is available in this location as a mounted file.

    3. Specify the following information in the dsenv file:
      • Environment variables for the data source client software
      • Data source home location
      • Data source library directory