Create topics, add publications and subscriptions to topics, and subscribe to topics.
Creating a topic
Use the Navigator to create topics.
1In the Navigator, click New > Topic.
The New Topic page appears.
2Enter 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.
3Click Browse to select a location.
4Select 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.
5If 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.
6Choose 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.
7Enter 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.
8Enter 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.
9Click 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 new table. Use this method to define the structure manually if the structure of the table does not exist in a compatible file.
10Define the table in the create table dialog box and then click OK.
The structure of the table shows in the Topic Structure area.
11Add 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.
12Click Save.
The topic page shows the Topic Diagram.
13Optionally, 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 .
- To add a subscription to the topic, expand the Subscriptions area and click New Subscription. For more information about creating subscriptions, see .
Subscribing to a topic
Use the Explore page to subscribe to a topic.
1On the Explore page, navigate to the object that you want to subscribe to a topic.
2In the row that contains the object, click Actions . Select Subscribe and then configure the subscription.