Table of Contents

Search

  1. Preface
  2. Introduction to Cloud Integration Hub
  3. Hub administration
  4. Project and Asset Management
  5. Applications
  6. Topics
  7. Data Integration tasks
  8. Publications
  9. Subscriptions
  10. Tracking and monitoring
  11. Cloud Integration Hub REST APIs
  12. Glossary

Cloud Integration Hub

Cloud Integration Hub

Topic Structure properties

Topic Structure properties

The
Topic Structure
area of topic page includes the following properties:
Create Table From
Add tables to the topic. The topic must contain at least one table.
You can use one or more of the following methods to add tables to the topic:
  • 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.
  • 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.
  • 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.
Show
Lists the tables in the topic. You can select to show a specific table.
The list of topic tables shows the following properties for each table:
Table
Name of the topic table. A topic table name must begin with an alphabetic character or underscore and can contain only ASCII alphanumeric characters or underscores. The name must be unique in the
Cloud Integration Hub
repository.
Column
Name of the table column.
The name must begin with an alphabetic character or underscore and can contain only alphanumeric characters or underscores.
Filter Accelerator
Indicates that the column will be used in subscription queries and requires performance-related handling by
Cloud Integration Hub
. Use this indicator with topics that you plan to use for unbound subscriptions.
When you use filter accelerators, consider the following guidelines:
  • Filter accelerators slow down the writing of publication data to the
    Cloud Integration Hub
    publication repository.
  • Filter accelerators have no impact on subscriptions that do not use filters.
  • In a hosted
    Cloud Integration Hub
    publication repository, by default,
    Cloud Integration Hub
    encrypts the topic data. To use a column as a filter accelerator you must change the value of
    Encrypted
    to
    No
    for the column.
Data Type
Select from the list of available data types. By default,
Cloud Integration Hub
reads the data as string.
Precision
Enabled only for data types that support precision.
For a String data type, the maximum precision that
Cloud Integration Hub
supports is 1900 characters.
Scale
Enabled only for data types that support data scaling.
Encrypted
Determines whether or not
Cloud Integration Hub
encrypts the column data. On a hosted publication repository,
Cloud Integration Hub
encrypts all columns by default. You can turn off the encryption for specific columns, for example, for columns you plan to use as filters in your mappings.