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.