Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Catalog
  4. Applications
  5. Topics
  6. Creating Topics
  7. Topic Properties
  8. Publications
  9. Creating Publications
  10. Publication Properties
  11. Subscriptions
  12. Creating Subscriptions
  13. Subscription Properties
  14. Events and Event Monitoring
  15. Dashboard and Reports
  16. Glossary

Operator Guide

Operator Guide

Database Table Properties

Database Table Properties

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
Structure Preview
area of the
Structure
page of the topic wizard.

0 COMMENTS

We’d like to hear from you!