Registering and synchronizing a data source via Edge

Registering a data source via Edge makes metadata from the data source available in Collibra Data Intelligence Platform. The data flow is as follows:

Before you begin

• Ensure the following settings are enabled:
  • Database registration via Edge to allow registering a data source via Edge.
  • Database profiling via Edge to allow profiling and classification via Edge.
  • Catalog experience to have access to the Configuration tab page in the Database asset.
• You have created and installed an Edge site.
• You have created a JDBC connection for your data source and have added the capabilities: Catalog JDBC ingestion capability and JDBC Profiling capability, if you also want to profile and classify the data source.
  If no JDBC connections and capabilities are configured, the following message appears in the Data Source Registration pageRegister content page: "No data available" and you cannot continue registering the data source.

Steps

The following table shows the steps required for registering a data source via Edge.

Step	What?	Description	Results
1	Register a data source	Creates the structure for the metadata in Collibra.	A Physical Data Dictionary domain containing a Database asset is created. A list of available schemas is created on the Configuration tab page of the Database asset. For more information, go to the full overview.
2	Configure the synchronization of your data source	Allows you to define synchronization rules to indicate what you want to register. You can: Include and exclude tables of the schema. Specify the target domain in which to create assets. Exclude database views. Include source tags.	The information on the Configuration tab page of the Database asset is completed.
3	Synchronize one or more schemas manually Add a synchronization schedule to synchronize automatically	Makes the metadata available in Collibra.	Schema, Table, Column and Foreign Keys assets are created in the specified domain, and registration data becomes available. For more information, go to the full overview.
4	If needed, profile and classify the synchronized data.	Data profiling creates a summary of a data source that is registered with Data Catalog and determines the data type of columns in the data source. The summary mainly contains statistics and graphics to give the user an idea what the registered data is about. Classification analyzes and predicts the content of registered data sources based on a subset of the data itself, helping you to easily gain insights on what kinds of data you have and where it resides.	The Table and Column assets contain profiling information and the Columns are classified.

Additional information

If you want to learn more and watch a recording, check out the Data source registration via Edge training on Collibra University.