Data Integration Connectors
- Data Integration Connectors
- All Products
Property | Description |
|---|---|
Encryption Method | The method that the Secure Agent uses to encrypt the data
sent between the driver and the database server. You can use
the encryption method to connect to Microsoft Azure SQL
Database. Default is None. |
Crypto Protocol Version | Cryptographic protocols to use when you enable SSL
encryption. |
Validate Server Certificate | When set to True, Secure Agent validates the certificate
that is sent by the database server. If you specify the HostNameInCertificate parameter, Secure
Agent also validates the host name in the certificate. When set to false, the Secure Agent doesn't validate the
certificate that is sent by the database server. |
Trust Store | The location and name of the truststore file. The
truststore file contains a list of Certificate Authorities
(CAs) that the driver uses for SSL server
authentication. For the serverless runtime environment, specify the
following certificate path in the serverless agent
directory: /home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<TrustStore_filename> |
Trust Store Password | The password to access the contents of the truststore
file. |
Host Name in Certificate | Host name of the machine that hosts the secure database. If
you specify a host name, the Secure Agent validates the host
name included in the connection with the host name in the
SSL certificate. |
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 a semicolon. For example, enter the following
property to configure the connection timeout when you test a
connection: LoginTimeout=<value_in_seconds> The
default connection timeout is 270
seconds. When you use Kerberos authentication
to connect to Microsoft SQL Server, you need to add the
KRB5_CONFIG ,
KRB5CCNAME , and
JAASCONFIG properties. For more
information, see Configuring Kerberos authentication. |
Runtime Advanced Connection Properties | Additional properties for the ODBC driver required at run time. If
you specify more than one property, separate each key-value
pair with a semicolon. When you use Kerberos
authentication to connect to Microsoft SQL Server, you need
to add the KRB5_CONFIG and
KRB5CCNAME properties. For more
information, see Configuring Kerberos authentication. |