Table of Contents

Search

  1. Preface
  2. Introduction to Cloud Integration Hub
  3. Hub administration
  4. Project and Asset Management
  5. Applications
  6. Topics
  7. Data Integration tasks
  8. File ingestion tasks
  9. Publications
  10. Subscriptions
  11. Tracking and monitoring
  12. Cloud Integration Hub REST APIs
  13. Glossary

Cloud Integration Hub

Cloud Integration Hub

Create topic tables in a relational database

Create topic tables in a relational database

You can use the following methods to create topic tables in a relational database:
  • Create a table from a connection. Use this method when the structure of a table in the data domain that the topic represents exists in a connection object. You can use relational, flat file, JDBC_IC, JDBCV2, and Salesforce connections to create topic tables. The
    Add Table From Connection
    dialog box shows up to 200 tables. You can also search for an object from a connection.
  • Create a table from a flat file. Use this method when the structure of a table in the data domain that the topic represents exists in a flat file.
  • Create a table from a metadata file. Use this method when the structure of a table in the data domain that the topic represents exists in a JSON, XML, XLS, or XLSX file. For more information, see Using metadata files to create topic tables in a relational database.
  • Create a new table. Use this method to define the structure manually if the structure of the table does not exist in a compatible file.
You can use more than one method to create tables in a single topic. For example, create two tables from a flat file, create three tables from a metadata file, and create a new table.
  • If you add a table or table column to a topic with associated publications or subscriptions, to publish and to consume the additional data, edit the mapping to include the additional table or column. If you do not update the mapping,
    Cloud Integration Hub
    won't publish the additional data to the publication repository and subscribers won't receive it.
  • In a topic table, encrypting fields increases the storage space, thus impacting the publication and subscription run time.

0 COMMENTS

We’d like to hear from you!