Catalog Source Configuration > MariaDB > Before you begin
  

Before you begin

Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:

Verify permissions

To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.

Permissions for metadata extraction

To extract MariaDB metadata, you need account access and permissions to the MariaDB source system.
Verify that the administrator performs the following tasks:

Permissions to run data profiles

You can run profiles with the permissions required to perform metadata extraction.

Permissions to run data classification

You can perform data classification with the permissions required to perform metadata extraction.

Permissions to run glossary association

You can perform glossary association with the permissions required to perform metadata extraction.

Create a connection

Create a MySQL connection object in Administrator with the connection details of the MariaDB source system.
    1In Administrator, select Connections.
    2Click New Connection.
    3In the Connection Details section, enter the following connection details:
    Connection property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    4Select the MySQL connection type.
    5In the MySQL Connection Properties section, select the runtime environment where you want to run the tasks.
    6In the Connection section, enter the following connection details:
    Property
    Description
    Type
    Type of connection.
    Select MySQL from the list.
    Runtime Environment
    The name of the runtime environment where you want to run the tasks.
    User Name
    User name for the database login. The user name can't contain a semicolon.
    Password
    Password for the database login. The password can't contain a semicolon.
    Host
    Name of the machine that hosts the database server.
    Note: The host name is auto populated with the port number if you have enabled the Secret Vault licenses in your Organization. You can remove the port number and enter the host name.
    Port
    Network port number used to connect to the database server.
    Default is 3306.
    Database Name
    Name of the MariaDB database that you want to connect to.
    Note: The database name is case-sensitive.
    Maximum length is 64 characters. Database name can contain alphanumeric and underscore characters.
    Code Page
    The code page of the database server.
    Metadata Advanced Connection Properties
    Additional properties for the JDBC driver to fetch the metadata.
    To configure an SSL connection, use the serverSslCert property to specify the path to the server certificate.
    If you specify more than one property, separate each key-value pair with an & symbol.
    For example,
    connectTimeout=100&serverSslCert=/data/mariadb/ssl/server-cert.pem
    7Click Test Connection.
    8Click Save.

SSL Properties

You can configure a MySQL connection to use SSL to securely communicate with the MariaDB database.
The following table describes the SSL properties:
Connection property
Description
Use SSL
Determines whether the Secure Agent establishes a secure connection to the MariaDB database.
When you select this option and the MariaDB database server is SSL enabled, the Secure Agent establishes an encrypted connection.
If you don't select the Use SSL checkbox, the Secure Agent establishes an unencrypted connection.
Verify Server Certificate
Applicable if you select Use SSL.
If you select this option, the client validates the server certificate that is sent by the database server.
Require SSL
Applicable if you select Use SSL.
If the MariaDB database server is not SSL enabled, the connection either fails or the Secure Agent establishes an unencrypted connection depending on whether you selected this option.
If you select this option, the connection fails if the Secure Agent can't establish a secure connection.
If you don't select this option, the Secure Agent establishes an unencrypted connection if it can't establish a secure connection.
The following table describes the MariaDB connection properties for the JDBC driver version 8.x when you enable Use SSL:
Connection property
Description
Trust Certificate Key Store
The path and file name of the truststore file. You must prefix the file path with file colon (file:).
For example, file:C:\SSL\mariadb_new\truststore
Trust Certificate Key Store Password
The password for the truststore file.
Client Certificate Key Store
The path and file name of the keystore file. You must prefix the file path with file colon (file:).
For example, file:C:\SSL\mariadb_new\keystore
Client Certificate Key Store Password
The password to access the keystore file.

Create endpoint catalog sources for connection assignment

An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.
You can then perform connection assignment to reference source systems to view complete lineage with source system objects.