Database: Structure import

General - Database

Function which allows access via a connector Connectors to the different schemas of an SQL database.

The function is available from the GenericsData module. From the pane on the left, choose the Import menu then the Database submenu.

This function is used to read all or part of the schemas, tables, views of the database accessible via the defined connector.

The integration of all or part of the tables and views will lead to the creation for each table of a repository AND a Business Entity.

connect_1

  • Step 1: Choice of connector (Required). This step allows you to choose the connector that will be used to access the different diagrams. Only the connectors authorized for the current user are proposed.

connect2

  • Step 2: Search criteria and options

connect3

5 search criteria can be specified

1 - Reading the system tables

2 - Option to exclude or include schemas.

3 - Option to exclude or include tables and views.

Attention The names of tables or views included (or excluded) must be separated by the comma character

4 - Consideration of foreign keys

5 - Exclusion or inclusion of views

  • Step 3: Reading the database

After specifying the different options, clicking on the Connect button executes the search for the different elements in the database.

information Note that the reading time may depend on the number of schemas, tables, views and links between tables.

  • Step 4: Display of the tables and views selected following the search

connect4

All diagrams, tables and views are presented.

It is then possible to choose all or part of the elements which will have to be integrated into DataChain.

Attention Before integration in DataChain, it is strongly advised to enter a description and to position Tags. This information will be integrated into the metadata of the Depots and Business Entities created and can be used as a filter for displaying the different catalogues.

  • Step 5: Integration phase

This phase consists of the actual integration of the chosen elements into DataChain.

The integration is carried out after clicking on the Execute button.

A popup indicating the progress of the integration is then available on the screen.

At the end of the treatment, an integration report is presented.

The integration of the selected elements from the connector is complete.