For topics that store the topic data on a relational database or on a Hadoop repository, you can use one or more of the following methods to add tables to the topic:
Add tables from a database. Use this method if the structure of the data domain that the topic represents exists in a relational database in your organization. For example, if the structure exists in one of the applications that publish to the topic.
Add tables from Enterprise Data Catalog. Use this method when the structure of the data domain that the topic represents exists in Enterprise Data Catalog. Select tables from an Enterprise Data Catalog asset that the Data Integration Hub topic must use.
Add tables from a flat file. Use this method when the structure of the data domain that the topic represents exists in a flat file. You can only use delimited files to add a topic table.
Add tables from a PowerCenter workflow. Use this method if your organization has a PowerCenter workflow that extracts data from the source applications and the targets of the workflow represent the structure in which you want to keep the data. The developer creates the workflow in PowerCenter Workflow Manager. Data Integration Hub generates the topic structure based on the targets in the workflow.
Add tables from a metadata file. Use this method when the structure of the table in the data domain that the topic represents exists in a JSON, XLS, XLSX, or XML file.
Create a table. Use this method when the structure of the data domain that the topic represents does not exist in a database in your organization, in a PowerCenter workflow, or in a file, and you want to define the structure manually in Data Integration Hub.
You can use more than one method to add tables to a single topic. For example, add two tables from a database and one table from a PowerCenter workflow definition file.
For topics that store the topic data on a file repository, the only method that you can use to add a topic table is by creating the table. You need to define a table for each expected file. The table stores metadata only.