Hybrid Data Pipeline exposes the following parameters for verified third-party drivers.

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.

Driver Class

The name of the class of the third-party driver which is plugged into Hybrid Data Pipeline.

User Id, Password

The login credentials used to connect to the JDBC 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.

Connector ID

The unique identifier of the On-Premises Connector that is used to access the on-premise data source. Click the arrow down arrow for a field) and select the Connector that you want to use. The identifier can be a descriptive name, the name of the machine where the Connector is installed, or the Connector ID for the Connector.

If you have not installed an On-Premises Connector, and no Connectors have been shared with you, this field and dropdown are empty.

If you own multiple Connectors that have the same name, for example, Production, an identifier is appended to each Connector, for example, Production_dup0 and Production_dup1. If the Connectors in the dropdown were shared with you, the owner's name is appended, for example, Production(owner1) and Production(owner2).

Metadata Exposed Schemas

Restricts the metadata exposed by Hybrid Data Pipeline to a single schema. The metadata exposed in the SQL Editor, the Configure Schema Editor, and third-party applications will be limited to the specified schema. JDBC, OData, and ODBC metadata calls will also be restricted. In addition, calls made with the Schema API will be limited to the specified schema.

Warning: This functionality should not be regarded as a security measure. While the Metadata Exposed Schemas option restricts the metadata exposed by Hybrid Data Pipeline to a single schema, it does not prevent queries against other schemas on the backend data store. As a matter of best practice, permissions should be set on the backend data store to control the ability of users to query data.

Valid Values

<schema>

Where:

<schema>

is the name of a valid schema on the backend data store.

Default: No schema is specified. Therefore, all schemas are exposed.

Connection URL

The URL used by the third-party driver to make a JDBC connection. This includes connection specific information like server name, the port to connect to, the database etc.