When you define the structure of the topic by adding tables from a database, you select or create the database metadata connection and then select the tables to include in the topic structure.
The
Add Tables from Database
page contains the following properties:
Database Connection
Name of the data access connection. You can browse to choose from the list of connections, or create a connection, in the
Select Metadata Connection
dialog box.
Find Topic Table
Optionally, search for tables in the database. Note the following guidelines:
To search for tables by table name, enter a string in the
Find Topic Table
text box and then click
Search
.
To search for tables that use a schema other than the default schema, clear the option
Show default schema only
, enter a string in the
Schema
text box, and then click
Search
.
To clear the search results and show only tables that use the default schema, select the option
Show default schema only
and then click
Show All
.
The search is not case sensitive.
You can search for a substring.
Select Topic Tables
Select tables in the database to include in the topic structure.
Data Integration Hub
adds the columns DIH_PUBLICATION_INSTANCE_DATE, DIH_PUBLICATION_INSTANCE_ID, and DIH__UPDATE_STRATEGY_FLAG to each topic table. When you finish creating the table, the columns show in the