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

Topic structure in a relational database

Topic structure in a relational database

When you create a topic in a relational database, you define the data structure on the publication repository where publications publish data to and subscriptions consume data from. The topic structure can consist of multiple tables.
Cloud Integration Hub
generates the tables in the publication repository where it retains the data that is published for the topic.
Cloud Integration Hub
uses the data structure for the publications and subscriptions that are associated with the topic.
For example: Create a Sales topic that represents sales data. Applications from all the stores in the organization publish sales data to the Sales topic. The accounting application subscribes to the Sales topic and consumes published sales data from all stores, or, if a filter is applied, from specific stores.
Before you define publications and subscriptions for the data that is published and consumed in
Cloud Integration Hub
, you need to define the canonical structure that will hold the data that is published to
Cloud Integration Hub
in the
Cloud Integration Hub
publication repository. You define the canonical structure when you define the topic. You can define multiple topics that represent different source data sets.

0 COMMENTS

We’d like to hear from you!