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.
Required 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
-
On the main menu, click
, and then click
Catalog.
The Catalog Home opens. - On the main toolbar, click
. - In the Register with Edge section of the Create dialog box, click Register a data source.
The Register content page opens.The Register content page shows a list of available JDBC connections that you can use to register your database.
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. - In the row of the data source that you want to register, click Add.
The Add Database page opens. - 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 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.
ImportantA Database asset should have only one relation of the type 'Technology asset groups / is grouped by Technology asset' to a System asset.
Database name
The name of the database in the data source to which you created a 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.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.
Owner
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 as Owner will receive the Owner 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.
- Click Register.
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.
The Database asset page opens.
A list of available schemas in the database is generated.
- We highly recommend to not remove the relation between the Database asset and the System asset.
- A Database asset should have only one relation of the type 'Technology asset groups / is grouped by Technology asset' to a System asset.
What's next?
You can now configure the synchronization of your data source then synchronize the metadata.