Customizing the database name for database-less data sources

Important 

In Collibra 2024.05, we've launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

When you create a JDBC connection for a database-less data source, such as Hive, MongoDB, or Teradata, the default database name is set to CData. When you register the data source via Edge, CData is listed in the Database name drop-down menu on the Add Database page Register a Data Source dialog box.

You can use the CustomizedDefaultCatalogName connection property to customize the database name when you connect to your data source. Collibra then uses the value of the CustomizedDefaultCatalogName connection property as the database name when you register the data source via Edge. To use this property, you must use a Collibra-provided driver that is newer than version 23.0.8409. For details about specifying the CustomizedDefaultCatalogName connection property for each data source, go to Overview of Catalog connectors.

If you customized the database name and want to create technical lineage for the database-less data sources, ensure that you take the following actions: 

Important Don't update the database name after you have registered the data source.

If you add or change the CustomizedDefaultCatalogName connection property after a database was registered, we treat the database as a new one, and you must register the data source again with the new database name. Renaming a database while keeping the existing registered assets is not possible.

Note If you add the CustomizedDefaultCatalogName property to the JDBC connection after the database was listed for the first time in the Database name drop-down menu on the Add Database page Register a Data Source dialog box, both the new database name and CData will appear in the Database name drop-down menu. Make sure to select the new database name when you register the data source.

This property is available for the following database-less data sources:

  • Amazon DynamoDB
  • Apache Cassandra
  • Apache HBase
  • Apache Hive
  • Apache Spark SQL
  • Avro
  • Azure Cosmos DB
  • Azure Table Storage
  • CSV
  • Elasticsearch
  • Excel
  • Google Sheets
  • Greenplum
  • IBM Cloudant
  • IBM Db2
  • Impala
  • JSON
  • MarkLogic
  • MongoDB
  • Parquet
  • Salesforce
  • SAS Data Sets
  • Splunk
  • Teradata
  • XML