Prerequisites

Perform the following tasks:

1. Download Collibra DGC version 5.6.5 for your platform (Windows/Linux).

2. Install and Configure Collibra. See Collibra Documentation for more information.

3. Download the MYSQL 5.1.38 JDBC driver.

Connect Collibra DGC to SingleStore

1. Open the DGC Agent on your browser: http://<IP_address_of_the_server_running_Collibra_DGC>:4400/.

2. On the Collibra DGC portal, select Catalog > Create.

3. On the Create dialog, select Register Data Source. On the Register Data Source dialog, select MySQL.

4. Enter the Schema name and then select Next.

5. Upload the MySQL JDBC Jar (Version 5.1.38). Select Next.

6. Create the JDBC driver for the selected JAR. Add the following entry and select Update:

   JDBC

   Copy

    Connections *
   
    jdbc:mysql://$host:$port/$database
   
    Driver Class Name *
   
    com.mysql.jdbc.Driver

   Add the following details to the connection properties table:

   Label	Property	Mandatory
   Host Name	host	X
   Port	port	X
   Database Name	database	X

7. In the Connection Details dialog, enter the Schema Name, Host Name, Port, and Database Name.

   Enter the Username and Password for your SingleStore database and select Next.

Once the database is successfully registered, you are ready to manage your SingleStore data using Collibra Data Governance Center.