SingleStore Managed Service

Connecting Collibra DGC to SingleStore DB

  1. Open the Collibra DGC as above.

  2. Navigate to Catalog, click Create.

  3. On the Create pop up, select Register Data Source. Select MySQL on the Register Data Source pop up.

  4. Enter the Schema name. Click Next.

  5. Upload the JDBC Jar (Version 5.1.38). Click Next.

  6. 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

  7. 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.

  8. The database is registered successfully.