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.
to select a location.
Select the publication repository type.
. 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.
. 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.
. The topic instance contains only the latest data changes. If you choose this topic type, verify that the data source includes delta indicators.
. 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.
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, and Salesforce connections to create topic tables. The
Add Table From Connection
dialog box shows up to 200 tables.
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 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
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.
The topic page shows the Topic Diagram.
Optionally, add publications and subscriptions to the topic. Perform one or both of the following actions: