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

Using metadata files to create topic tables

Using metadata files to create topic tables

You can load a metadata file to
Cloud Integration Hub
and create a topic table that is based on the structure of the file.
When you use a metadata file to create a topic table, you can define table attributes in the file before you load it to
Cloud Integration Hub
. For example, define column data type and precision, or define a column as a filter accelerator that is not encrypted.
You can use JSON, XML, XLS, and XLSX metadata files to create topic tables.
The metadata file must contain the following fields, and must not contain any other fields:
columnName
Mandatory.
Name of the table column.
The name must begin with an alphabetic character or underscore and can contain only alphanumeric characters or underscores.
filterAccelerator
Optional.
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.
By default, false.
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.
  • On 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 define the value of the column's
    encryption
    field to
    false
    .
datatype
Optional. Data type of the field. By default, string.
The file can contain fields of the following data types:
  • string
  • decimal
  • double
  • int32
  • int64
  • date_time
  • text
precision
Optional. Applies to data types that support precision. The default precision value depends on the data type of the field:
  • String: 255
  • Decimal: 15
  • Text: 10000
scale
Optional. Applies to data types that support data scaling. The default scale value depends on the data type of the field:
  • Decimal: 0
  • All other data types: empty
encryption
Optional.
If a file doesn't contain all the required fields, or contains non-required fields, loading the file to
Cloud Integration Hub
fails.
If a file contains identical rows,
Cloud Integration Hub
adds only the first row to the topic table.
Example table in a JSON file
[ {"columnName":"id", "filterAccelerator": "false", "dataType": "int32", "encryption":false}, {"columnName":"name", "filterAccelerator": "false", "dataType": "string", "precision" : 100, "encryption":false}, {"columnName":"age", "filterAccelerator": "true", "dataType": "decimal", "precision" : 3, "encryption":"true"}, {"columnName":"city", "filterAccelerator": "True", "dataType": "string", "precision" : 50, "encryption":"FALSE"}, {"columnName":"salary", "filterAccelerator": false, "dataType": "decimal", "precision" : 15, "scale":2, "encryption":true} ]
Example table in an XML file
<table> <column> <columnName>id</columnName> <dataType>int32</dataType> <encryption>false</encryption> <filterAccelerator>true</filterAccelerator> </column> <column> <columnName>name</columnName> <dataType>String</dataType> <encryption>true</encryption> <precision>100</precision> <filterAccelerator>false</filterAccelerator> </column> </table>
Example table in an XLS or XLSX file
columnName
filterAccelerator
dataType
precision
scale
encryption
id
TRUE
int32
FALSE
name
FALSE
String
255
FALSE