Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
Property | Description |
---|---|
Connection Name | Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
|
Description | Description of the connection. Maximum length is 4000 characters.
|
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not
supported by Data Ingestion and Replication and the Data Access Management services. When you enable the secret vault in the connection, you can select
which credentials that the Secure Agent retrieves from the secrets manager. If you
don't enable this option, the credentials are stored in the repository or on a local
Secure Agent, depending on how your organization is configured. If you’re using this connection
to apply data access policies through pushdown or proxy services, you cannot use
the Secret Vault configuration option. For information about how to configure and use a secrets manager, see
"Secrets manager configuration" in the Administrator help .
|
Runtime Environment | The name of the runtime environment where you want to run the tasks. For Data Ingestion and Replication , you can use either a local Secure Agent
installation or serverless runtime environment. You can use a
serverless runtime environment for cloud source types. You cannot
run database ingestion and replication tasks on a Hosted Agent. |
User Name | User name for the database login. The user name can't contain a
semicolon. |
Password | Password for the database login. The password can't contain a
semicolon. |
Host | Name of the machine that hosts the database server. |
Port | Network port number used to connect to the database server. Default is
3306. |
Database Name | Name of the MySQL database that you want to connect to. The database name is
case-sensitive. Maximum length is 64 characters. Database
name can contain alphanumeric and underscore characters. |
Code Page | The code page of the database server. |
Metadata Advanced Connection Properties | Additional properties for the JDBC driver to fetch the metadata. Enter
properties in the following format: <parameter
name>=<parameter value> If you enter
more than one property, separate each key-value pair with an
ampersand (&). For example, enter the following property
to configure the connection timeout when you test a
connection: connectTimeout=<milliseconds> The default
connection timeout is 270000 miliseconds. |
Runtime Advanced Connection Properties | Additional properties for the ODBC driver to run ingestion and
replication jobs .If you specify more than one property, separate each
key-value pair with a semicolon. |