Connecting Collibra DGC to SingleStoreDB
Open the Collibra DGC as above.
Navigate to Catalog, click Create.
On the Create pop up, select Register Data Source. Select MySQL on the Register Data Source pop up.
Enter the Schema name. Click Next.
Upload the JDBC Jar (Version 5.1.38). Click Next.
Create the JDBC driver for the selected JAR. Add the entries as shown below and click Update:
Connections * jdbc:mysql://$host:$port/$database Driver Class Name * com.mysql.jdbc.Driver
The connection properties table should include the following information:
Label
Property
Mandatory
Host Name
host
X
Port
port
X
Database Name
database
X
In the connection details pop up, enter the Schema Name, Host Name, Port, and Database Name. Enter the Username and Password for the database and click Next.
The database is registered successfully.