How to Set Up the MariaDB Database Source in CDGC

Configuring MariaDB catalog source in CDGC is like sculpting a masterpiece. You need the right access and permissions, like creating an Informatica user account and configuring read access. Once done, creating the connection in administrator service and executing the catalog source is like conducting a symphony. Finally, seeing the extracted metadata in data governance feels like unlocking a treasure chest. It’s a journey of discovery and empowerment! 🎨🔍🔒

What is MariaDB Scanner? 📋

In this video, we will see how to configure the MariaDB Catalog Source in CDGC. The agenda of today’s session is to understand what the MariaDB scanner is, the supported object types of MariaDB Catalog Source in CDGC, prerequisites to configure the MariaDB Catalog Source, and the steps to configure it along with a quick demo.

Supported Object Types 📄

The following objects will be extracted as part of the metadata extraction in CDGC:

• Column
• Database Schema
• Table
• View
• New Column

Prerequisites for Configuration 🛒

To extract metadata from the MariaDB Source system, you need access and permissions. The administrator must perform the following tasks:

• Create a user account for the Informatica user
• Configure read permission
• Verify select and show view privileges
• Configure read access on specific information

The information includes schema, tables, columns, table constraints, key column usage, and views in the source system.

Steps to Configure MariaDB Catalog Source in CDGC 📌

In order to create a Maria catalog Source metadata Command Center, you need to create a connection in the administrator service. Follow the steps:

1. Navigate to Administrator Service
2. Click on Connection and create a new connection
3. Provide the connection details and save it
4. Open Metadata Command Center and click on New
5. Search for MariaDB under connection
6. Choose the created connection and follow the filter conditions
7. Save the connection and execute the catalog source

Detailed Metadata View 📊

Once the job is successfully completed, you will be able to see the extracted metadata details under the results tab in data governance and catalog. Furthermore, you will be able to view the hierarchy of database tables, schema, column details, lineage, relationships, and data type information.

We would love to hear feedback from you! Thanks for watching! 🌟