# Connect with Collibra Platform

Collibra is a data intelligence platform that helps organizations streamline data management, governance, and collaboration. It enables businesses to discover, understand, and trust their data by providing tools for data cataloging, data lineage, and policy management. Collibra enhances decision-making by ensuring data quality, security, and compliance across various data sources.

You can connect your SingleStore deployments to Collibra Platform using the [SingleStore JDBC driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-java-jdbc/the-singlestore-jdbc-driver.md) ("the driver"). The driver enables Catalog to register database information and extract the structure of the source into its schemas, tables, and columns. The driver can retrieve the following SingleStore database components:

* Schemas
* Tables
* Views
* Columns
* Primary keys

## Prerequisites

* Access to an Edge site or a Collibra Cloud site.
* Global System administration and Manage connections and capabilities permissions.
* An active SingleStore deployment.
* SingleStore JDBC driver version 1.2.6+ `.jar` file.

## Configure the Connection to SingleStore

To connect using the SingleStore JDBC driver, perform the following tasks:

1. Create a JDBC connection.


2. Register a data source.

## 1. Create a JDBC Connection

Refer to [Create a JDBC connection](https://productresources.collibra.com/docs/collibra/latest/Content/Edge/JDBCConnections/ta_create-jdbc-connection.htm?data-source=singlestore) for information on creating a JDBC connection to SingleStore in Collibra Platform.

Specify the following connection settings while configuring the JDBC connection:

* **Name**: Specify **SingleStore**.
* **Driver class name**: Specify `com.singlestore.jdbc.Driver`.
* **Driver jar**: Download the SingleStore JDBC driver `.jar` file from its [GitHub repository](https://github.com/memsql/S2-JDBC-Connector/releases/latest), and upload the JAR file.
* **Connection String**: Enter `jdbc:singlestore://{host}:{port}/{db}`, where:

  * `host`: IP address or the hostname of the SingleStore deployment.
  * `port`: Default is `3306`.
  * `db`: Name of the SingleStore database to connect with.

Specify the following connection properties to configure the connection to your SingleStore deployment:

* **User**: Username of the SingleStore database user with which to access the database.
* **Password**: Password for the SingleStore database user.

> **📝 Note**: SingleStore does not support foreign keys. Hence, you must set the `foreign-keys-strategy` property to `SKIP` under Catalog JDBC Ingestion Edge capability.

## 2. Register a Data Source

Use the JDBC connection created earlier to register a data source. Refer to [Register a data source via Edge](https://productresources.collibra.com/docs/collibra/latest/Content/Catalog/RegisterDataSource/Edge/ta_register-a-data-source-via-edge.htm) for more information.

## View Technical Lineage

You can also view the technical lineage graph for SingleStore to visualize the journey of the data objects in your data sources and data transformation details. Refer to [Technical Lineage](https://productresources.collibra.com/docs/collibra/latest//Content/CollibraDataLineage/co_collibra-data-lineage.htm#technical-lineage) for more information.

Here are a few sample queries:

* Visualize pipeline metadata for external functions:
  ```sql
  SELECT PIPELINE_NAME, CONFIG_JSON, STATE, CREATE_TIME 
  FROM information_schema.PIPELINES 
  WHERE DATABASE_NAME = '<database_name>';
  ```
* Select and parse executed queries from history for internal relations:
  ```sql
  SELECT QUERY_TEXT FROM information_schema.MV_QUERIES 
  WHERE ACTIVITY_NAME LIKE 'InsertSelect%';
  ```

## References

* [Registering and integrating data sources in Catalog](https://productresources.collibra.com/docs/collibra/latest/Content/Catalog/to_register-integrate.htm)
* [Create a JDBC connection to SingleStore](https://productresources.collibra.com/docs/collibra/latest/Content/Edge/JDBCConnections/ta_create-jdbc-connection.htm?data-source=singlestore)

***

Modified at: September 26, 2025

Source: [/db/v9.1/load-data/integrate-with-singlestore/connect-with-collibra-platform/](https://docs.singlestore.com/db/v9.1/load-data/integrate-with-singlestore/connect-with-collibra-platform/)

(An index of the documentation is available at /llms.txt)