Hybrid Data Pipeline requires the integration of the MySQL Connector/J driver to connect to MySQL Community Edition data stores. During deployment of the Hybrid Data Pipeline server, you must specify the location of the MySQL Connector/J driver (refer to Progress DataDirect Hybrid Data Pipeline Deployment Guide for deployment details and the DataDirect Product Compatibility Guide for information on supported versions).

With the exception of OData parameters, the parameters described in the following table are exposed by Hybrid Data Pipeline and may be used to create a Hybrid Data Pipeline data source. (For details on OData parameters and configuration, see Configuring data sources for OData connectivity and working with data source groups.)

Note:
  • The MySQL CE data store icon does not appear by default on the Data Stores page. The icon will only appear if the MySQL Connector/J driver has been provided during the deployment process.
  • Since the MySQL Connector/J driver is in effect a third-party JDBC driver, it may require configuration and maintenance apart from Hybrid Data Pipeline. Therefore, you should refer to MySQL Connector/J driver documentation for information on support, functionality, and maintenance.
Field Description
Data Source Name

A unique name for the data source. Data source names can contain only alphanumeric characters, underscores, and dashes.
Description

A general description of the data source.

User Id, Password

The login credentials used to connect to the MySQL Community Edition database. A user name and password is required if user ID/password authentication is enabled on your database. Contact your system administrator to obtain your user name.

Note: By default, the password is encrypted.

By default, the characters in the Password field you type are not shown. If you want the password to be displayed in clear text, click the eye Watchful eye password icon icon. Click the icon again to conceal the password.
Server Name Specifies either the IP address in IPv4 or IPv6 format, or the server name (if your network supports named servers) of the primary database server, for example, 122.23.15.12 or mysqlcommunityserver.
Port Number The TCP port of the primary database server listening for connections to the database.
Database The name of the database that is running on the database server.
Extended Options

Specifies a semi-colon delimited list of connection options and their values. Use this configuration option to set the value of undocumented connection options that are provided by Progress DataDirect technical support. You can include any valid connection option in the Extended Options string, for example: 

Database=Server1;UndocumentedOption1=value[;
UndocumentedOption2=value;]

If the Extended Options string contains option values that are also set in the setup dialog, the values of the options specified in the Extended Options string take precedence.

Connector ID

The On-Premises Connector or Connector Group you are using to access an on-premises data source. Select the Connector from the dropdown. The names provided are labels specified during installation of a Connector or the creation of a Connector Group. If you have not installed an On-Premises Connector, and no Connectors have been shared with you, the Connector ID field and dropdown list will be empty.

If you own multiple Connectors that have the same name, a sequential numerical value is appended to the name of each Connector. For example, OnPremConnector1 and OnPremConnector2.