Create a MySQL metadata collector

  • Release version: Australia
  • Updated March 12, 2026
  • 3 minutes to read

    • Create a collector to import metadata from MySQL.

    Before you begin

    Before you begin, verify the following:

    Procedure

    1. Navigate to All > Workflow Data Fabric > Workflow Data Fabric Home.
    2. Select the Connect Hub Connect Hub icon icon in the left sidebar.
    3. Select Create > Metadata collector.
    4. From the System list, select MySQL.
    5. From the Connection type list, select one of the following:
      1. Select New connection to configure a new connection.
      2. Select Existing connection to reuse an existing connection and select an existing connection from the Connections list.
        The configuration form is filled with details from the existing connection. The name is appended with the word Copy and sensitive details like password aren't copied.
    6. Complete the form.
      Table 1. MySQL Server metadata collector form
      Field Description
      Connection name Unique identifier for the connection. This field can't be modified once the connection is established.
      Short description Purpose and details of the connection.
    7. Configure the authentication options.
      Table 2. Authentication options
      Field Description
      Username Username to use to connect to the database.
      Password Password of the databsase user.
    8. Configure the connection information.
      Table 3. Connection information
      Field Description
      Server Hostname of the database server to connect to.
      Server port Port of the database server (if not the default).
      Database Name of the database to connect to. Specify multiple databases by adding one value per line.
      Excluded database Name or regular expression indicating databases not to catalog when the Database field is empty.
      Note:
      This parameter is ignored if the Database field is specified.
    9. Configure the statistics and sampling options.
      Table 4. Statistics and sampling options
      Field Description
      Enable column statistics collection Enable harvesting of column statistics (that is, data profiling).
      Note:
      Enabling profiling can increase the collector’s runtime, as the collector must read table data to generate profiling metadata.
      Target sample size for column statistics Number of rows sampled for computation of column statistics and string-value histograms. For example, to sample 1000 rows, set the parameter as: 1000.

      Default: 100000
      Disable Lineage collection Skip harvesting of intra-database lineage metadata.
      Disable Extended Metadata collection Skip harvesting of extended metadata for data asset types such as database, schema, table, columns functions, stored procedures, user defined types, synonyms. Basic metadata for these data asset types will still be harvested.
      Enable Sample String Values collection Enable sampling and storage of sample values for string-valued columns.
      Exclude system functions Exclude harvesting of built-in system functions.
    10. Configure the connection and reliability options.
      Table 5. Connection and reliability options
      Field Description
      Server environment Friendly name for the environment in which your database server runs when the server name is localhost. Helps differentiate it from other environments.
      Database ID Unique identifier for this database. Used to generate the database ID when the database name is not sufficiently unique.
      JDBC properties JDBC driver properties to pass through to driver connection.
      SQL parsing timeout Timeout in seconds for SQL parsing during lineage collection.

      Default: 60
    11. Select Save.

    Result

    The metadata collector is created and appears on the Connectors page with a Configured status. It is now ready to connect to the source system and harvest metadata.

    What to do next

    After creating the collector, you can perform any of the following tasks: