Supported data sources for data source registration

Collibra Data Intelligence Cloudsupports several databases to register as a data source. Depending on your data source, you can useCollibra-provided Catalog connector, or your own JDBC driver.

Your own JDBC drivers

For certain data sources, you can use your own JDBC driver. The following table contains the packaged data sources and versions that have been tested.

Data source	Tested versions	Support for profiling and sample data	JDBC driver version
Amazon Redshift	1.0	Yes	v. 1.1.13.1013
Cloudera Hive	5.10 - 5.14	No	Apache driver v. 1.2.1
Hortonworks Hive	2.5, 2.6	No	Apache driver v. 1.2.1
HP Vertica	7.0	Yes	v. 07.01.0200
IBM DB2	10.5	Yes	v. 4.9.78
MySQL	5.6, 5.7	Yes	v. 5.1.38
Oracle	11g, 12c	Yes	v. 12c
PostgreSQL	9.4, 9.5	Yes	v. 9.4.1207
Microsoft SQL Server	2014, 2016	Yes	v. 5.1.38 Note Only Microsoft drivers and drivers available via Collibra Marketplace are supported.
Teradata	15.0, 16.20.07.01	Yes	No driver tested
Snowflake

Note We cannot guarantee that other data sources or driver versions work correctly. If you use a generic JDBC driver or an unsupported version, data ingestion, data profiling and sample data may not work as expected.

Authentication and permissions

Both ingestion andprofiling(includingsamplingandadvanced data type detection) rely on JDBC drivers to operate. Those drivers authenticate to the data sources as a user registered in that data source with specific permissions attached to the user profile in the data source.

To ingest a database without profiling,Data Catalogrequires read access to the database metadata: description of schema, tables, columns, including some more complex properties such as the primary and foreign keys.

However, if you enable one or more profiling options,Data Catalogalso requires the permission to read the full table. Which permissions are required exactly depends on the data source type, version and configuration. Additionally, they can also differ according to the provider and version of the JDBC driver. Most of the queries required to retrieve the information above are hidden by the driver. As a consequence,Collibracannot give a exhaustive list.

Note Collibrasupports severalauthentication methods, including credentials, NTLM, CyberArk and Kerberos. If you are using a certifiedCollibra provided driver on theCollibraMarketplace, you can also authenticate usingWindows Authentication.

Tip If you need more detailed information, we recommend to contact your JDBC driver provider.

Warning Currently, if youregister a data source viaEdge, you cannot profile your metadata and you can only use username/password authentication.