Add the Catalog JDBC ingestion capability

Before you can register a specific data source via Edge, you must add the Catalog JDBC ingestion capability to the JDBC connection for that data source.

Note If you're using a Collibra Cloud site, go the Collibra Cloud site documentation to check if your data source is supported.

Prerequisites

Steps

  1. Open a site.
    1. On the main toolbar, click Products iconCogwheel icon Settings.
      The Settings page opens.
    2. In the tab pane, click Edge.
      The Sites tab opens and shows a table with an overview of your sites.
    3. In the table, click the name of the site whose status is Healthy.
      The site page opens.
  2. In the Capabilities section, click Add capability.
    The Add capability page opens.
  3. Select the Catalog JDBC ingestion capability template.
  4. Enter the required information.
    FieldDescriptionRequired

    Name

    The name of the capability.

    Yes

    Description

    The description of the capability.

    No

    JDBC connection

    The connection to the data source.

    Yes

    JDBC data source type (Deprecated)

    Deprecated field. The field was used to indicate the type of the data source. You no longer need to change this field.

    The required value is automatically identified. The value isn't shown in this page.

    Yes

    Supports schemas

    A text field where you have to enter True to enable database registration of data sources without schemas. If the data source doesn't have a schema, Data Catalog creates a Schema asset with the same name as the full name of the database.

    If the data source has schemas, you can ignore this field.

    No

    Other Settings

    This section can contain additional capability properties.
    Click Add Other Settings to add a property.

    For an overview of all available properties, go to Other Settings.

    Note No validation is performed on the values you add.

    No

    Debug

    An option to automatically send Edge infrastructure log files to Collibra Platform. By default, this option is set to false.

    Note We highly recommend to only send Edge infrastructure log files to Collibra Platform when you have issues with Edge. If you set it to true, it will automatically revert to false after 24h.

    For more information, go to Edge logging.

    No

    Log level

    An option to determine the verbosity level of Catalog connector log files. By default, this option is set to No logging.

    No

  5. Click Create.
    The capability is added to the Edge or Collibra Cloud site.
    The fields become read-only.

Available "Other Settings"

You can add the following properties in the Other Settings section to define how metadata is retrieved and how synchronization jobs are configured.

Note No validation is performed on the values you add.

Strategy properties

The following properties define the strategy for the retrieval of columns and tags.

Properties for the various synchronization jobs

The following jobs run in view of a synchronization:

What's next

If want to run profiling, you can already, add the JDBC Profiling capability to the connection.
You can then register the data source via Edge.