JDBC connection details of your own drivers

In this section, you will see the connection details needed to register a data source or manage your own JDBC driver.

Tip You can also see the connection details of the Collibra-provided JDBC drivers.

Note About the Connection properties table:

The Label column is the value that will appear in the connection details dialog box of the Data Source Registration wizard.
The Property column contains the parameters in which the user input will be saved.

Supported databases and drivers

Tip

This information varies depending on your data source type and authentication method.

Credentials

CyberArk

Kerberos

NTLM

Amazon Redshift

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes
Schema	schema	Yes

Cloudera Hive

Label	Property	Mandatory
URL (hostname:port)	host	Yes
Principal	principal	Yes
Schema	schema	Yes

Hortonworks Hive

Label	Property	Mandatory
URL (hostname:port)	host	Yes
Schema	schema	Yes

HP Vertica

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes
Schema	schema	Yes

IBM DB2

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes
Schema	schema	Yes

MapR Hive

Label	Property	Mandatory
URL (hostname:port)	host	Yes
Schema	schema	Yes

Microsoft SQL Server

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	databaseName	Yes
Schema	schema	Yes

MySQL

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes

Oracle DB

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
SID	sid	Yes
Schema	schema	Yes

PostgreSQL

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes
Schema	schema	Yes

Teradata

Label	Property	Mandatory
Hostname	host	Yes
Port	port	Yes
Database	database	Yes
Schema	schema	Yes

If you want to use NTLM authentication, you also need the following connection properties.

Label	Property	Mandatory
Security	integratedSecurity must be value `True`.	Yes
Authentication scheme	authenticationScheme must be value NTLM.	Yes

If you want to use Kerberos authentication, you also need the following connection properties.

Label	Property	Mandatory
Principal	principal	Yes
Kerberos realm	realm	Yes
Login context name	loginContextName You can find the value for this property in the jaas.conf file.	Yes
Jaas file name	com.collibra.jobserver.dto.catalog.JdbcConnection.jaasConfig	Yes
Kerberos configuration file	com.collibra.jobserver.dto.catalog.JdbcConnection.krbConfig	Yes

If you want to use CyberArk authentication, you need the following connection properties. If you use one of the CyberArk connection properties, Data Catalog automatically uses CyberArk authentication.

Label	Property	Mandatory
Keystore file	keystoreFile	Yes
Keystore password	keystorePass	Yes
Default truststore	defaultTruststore	No
CyberArk address	cyberarkAddress	Yes
CyberArk application ID	cyberarkAppId	Yes
CyberArk query	cyberarkQuery	Yes