Cloud Integration Hub

Back Next

Creating a topic

Use the Navigator to create topics.

In the Navigator, click

New

Topic

The

New Topic

page appears.

Enter the topic name.

The name must begin with an alphabetic character or underscore and can contain only alphanumeric characters or underscores.

Optionally, enter a description for the topic.

Click

Browse

to select a location.

Select the publication repository type.

Relational

. Stores published data in a relational database. Select this repository type for topics that you use for publications and subscriptions that publish and consume relational data.

File Store

. Stores published files in a file store. Select this repository type for topics that you use for publications and subscriptions that publish and consume files as-is.

If you use a relational publication repository, select the topic type.

Incremental Load

. The topic instance contains only the latest data changes. If you choose this topic type, verify that the data source includes delta indicators.

Full Load

. The topic instance contains all of the data changes that occurred after the last publication.

Choose whether to prevent new publications and new subscriptions to the topic. If you choose this option you cannot create publications and subscriptions that publish to and subscribe from the topic.

Enter the number of days to retain consumed data in the publication repository in the

Retention period for consumed data

field. Enter a value between 1 and 90 days. For each publication instance, the retention period for consumed data starts if all the subscribers have either successfully consumed or discarded the data. That is, after all the events that are associated with the publication instance are either in a Complete or in a Discarded event status.

Enter the number of days to retain unconsumed data in the publication repository in the

Retention period for unconsumed data

field. Enter a value between the retention period for consumed data and 90 days.

Click

Create Table From

and select one of the following methods:

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.

Define the table in the create table dialog box and then click

The structure of the table shows in the

Topic Structure

area.

Add the number of tables that you require to the topic. You must add at least one table to the topic. You can use multiple methods to add tables to the topic.

To edit or to delete a topic table, rest on a row in the table and click the Action menu at the right end of the line. From the menu select the required action: add row, rename table, delete row, or delete table.

Click

Save

The topic page shows the Topic Diagram.

Optionally, add publications and subscriptions to the topic. Perform one or both of the following actions:

To add a publication to the topic, expand the

Publications

area and click

New Publication

. For more information about creating publications, see Creating a publication.

To add a subscription to the topic, expand the

Subscriptions

area and click