A data store connector is the underlying connector Hybrid Data Pipeline uses to connect to a data store. The Hybrid Data Pipeline product package uses DataDirect JDBC drivers as the underlying connectors that make connectivity to data stores possible. Note that these connectors are also used for making ODBC and OData connections.

In some circumstances, you may want to replace a driver jar file in the Hybrid Data Pipeline environment to receive an enhancement or fix that was only required for the driver. Replacing the driver jar file allows you to obtain the enhancement or fix without having to incur the overhead associated with performing an upgrade or redeploying the service. If you are connecting to on-premises data, the On-Premises Connector must be updated as well.

Important: After you update a connector, best practices recommend reviewing settings for the existing data sources associated with the connector. First, you should confirm default settings in the event the connector has different default settings. Second, review the data store connector tabs for new parameters. New parameters may help enhance or refine data store connectivity.

Obtain the driver information for a data store connector

Before replacing a data store connector, retrieving the driver information for the connector is recommended. You can use the following request to retrieve this information.

GET https://<myserver>:<port>/api/mgmt/datastores

The payload provides details on all supported data stores, including driver details. For example:

...
{
    "id": 1,
    "name": "Salesforce",
    "isBeta": false,
    "isGroup": false,
    "driver": {
        "name": "ddsforce.jar",
        "version": "6.0.0.2603",
        "helpURL": "https://docs.progress.com/bundle/datadirect-hybrid-data-
                    pipeline-46/page/Salesforce-parameters.html"
        },
    "authorized": true,
    ...

See Data Sources API for more information.

Replace a connector used by the Hybrid Data Pipeline service

Take the following steps to update the DataDirect driver used by the connectivity service.

  1. Contact your Progress Software representative to obtain the JDBC driver jar file for the data store connector you are updating.
  2. Run the stop service script for each node running the service. The location of the stop script is hdp_install_dir/ddcloud/stop.sh where hdp_install_dir is the installation directory of the Hybrid Data Pipeline server.
  3. Replace the jar file in the dddrivers directory. The dddrivers directory may be in either of the following locations.
    • Default key location

      hdp_install_dir/ddcloud/keystore/dddrivers where hdp_install_dir is the installation directory of the Hybrid Data Pipeline server.

    • User-specified key location

      user_specified_location/shared/dddrivers where user_specified_location is the key location specified during deployment of the Hybrid Data Pipeline server.

  4. Run the start service script for each node running the service. The location of the start script is hdp_install_dir/ddcloud/start.sh.

Result

The underlying DataDirect connector has been updated for the Hybrid Data Pipeline service.

Replace a connector used by the On-Premises Connector service

Take the following steps to update the DataDirect driver used by the On-Premises Connector service.

  1. Contact your Progress Software representative to obtain the JDBC driver jar file for the data store connector you are updating.
  2. Stop On-Premises Connector services by selecting Progress DataDirect Hybrid Data Pipeline On-Premises Connector > Stop Services from the Windows Start Menu.
  3. Replace the jar file in the opc_install_dir\OPDAS\server\dddrivers directory where opc_install_dir is the installation directory of the On-Premises Connector.
  4. Start On-Premises Connector services by selecting Progress DataDirect Hybrid Data Pipeline On-Premises Connector > Start Services from the Windows Start Menu.

Result

The underlying DataDirect connector has been updated for the On-Premises Connector service.