Register a data source via Edge

Before you can synchronize your data source, you have to register the data source to create an initial structure in a selected community in Data Catalog.

Before you begin

• You have enabled data source registration via Edge.
• You have set up a JDBC connection in Edge with the capabilities:
  • Catalog JDBC ingestion capability for the registration of the data source.
  • JDBC profiling capability for profiling and classifying the data.
  • Make sure the user in the JDBC Edge connection has the minimum user permissions to read the metadata from the source. For information, go to the connection properties.
• You have created a System asset.

Requirements and permissions

• You have a global role with the Catalog global permission, for example, Catalog Author.
• You have a global role with the View Edge connections and capabilities global permission, for example, Edge integration engineer.
• You have a resource role with the Configure external system resource permission, for example, Owner.

Steps

1. On the main toolbar, click , and then click Catalog.
   The Catalog Home opens.
2. In the tab bar, click Integrations.
   The Integrations page opens.
3. Click the Data Source Registration tab.
4. On the main toolbar, click .The Create dialog box appears.
5. In the Register with Edge section of the Create dialog box, click Register a data sourceIntegration Configuration.
   The Register contentIntegration Configuration tab page opens.
6. In the row of the data source that you want to register, click AddRegister.
   The Add Database pageRegister a Data Source dialog box opens.
   Note You can register multiple databases via the same JDBC connection. If a database is already registered, the name of the Database asset is shown in the Data sources column.
   
7. Enter the required information.

   Field	Description
   Community	The name of the parent community in which the assets will be created.
   System	The name of the System asset. After you have registered the database, a relation of the type Technology Asset groups / is grouped by Technology Asset is created between this System asset and the newly created Database asset. Important  A Database asset should have only one relation of the type 'Technology asset groups / is grouped by Technology asset' to a System asset.
   Owner	Tip By default, this field is called Owner, referencing the out-of-the-box Owner resource role. If you change the name of this out-of-the-box resource role, the updated name will be displayed instead. After the registration, a new domain and Database asset will be created specifically for this database in the community that you have specified. The user you select in this field will receive the responsibility for the domain. This ownership is then inherited by the Database asset. By default, the current user is selected. Note  An owner must be associated with the Database asset for synchronizations to run. The owner can be changed later on, but should not be removed.
   Database name	Select the name of the database that you want to register via the JDBC connection. The drop-down menu automatically shows which databases exist in your data source. You can refresh the list by clicking next to the drop-down menu. Note  Some data sources allow you to use one Edge connection to register multiple databases. In that case, the drop-down will show more than one name. We map Project ID in Google Bigquery, and Data Source in AWS Athena and AWS Glue to Database. Sometimes you can also see CDATA as an option, for example CSV. For information on changing the name, go to Customizing the database name for database-less data sources. The name will also be the name of the Database asset that is created as a result of registering the data source via Edge. Important  If you rename a database in the data source, the Edge synchronization process will consider it a new database. We don’t detect the renaming of a database at this moment.
   Description	A description of the data source.

8. Click Register.
   

When the registration of your data source is complete:

• A message appears at the top right.
• A Physical Data Dictionary domain containing a Database asset is created.
• A relation of the type "Technology asset groups / is grouped by Technology asset" is created between the Database asset and the System asset.
• If you registered a database without schemas, a new Schema asset is automatically created with the same name as the database or with a name as defined in the Edge capability.
• The Database asset page opens and a list of available schemas is available on the Configuration tab page of the Database asset.

What's next?

You can now configure and start the synchronization of the schemas in the database.