Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Automatic Database Publication

Use this type of publication to publish data from a relational database source if you want

Data Integration Hub

to create the PowerCenter workflow for the publication.

When you create the publication, you select a relational database connection.

Data Integration Hub

explores the source connection, searches for the tables and fields that match the names of tables and fields that are defined in the topic structure, and performs one of the following actions:

If all or some of the tables that are defined in the topic structure exist in the source connection,

Data Integration Hub

maps the source tables and fields to topic tables and fields, based on a name match. You can edit the mapped tables and fields and manually map them to other tables and fields in the topic.

If none of the tables that are defined in the topic structure exist in the source connection,

Data Integration Hub

displays a warning and generates the mapping based on the topic tables. You can exclude fields or tables from the mapping, or manually map the tables to other tables in the topic.

If the connection does not contain metadata access,

Data Integration Hub

cannot explore the source connection.

Data Integration Hub

displays a warning and generates the mapping based on the topic tables. You can exclude tables and fields from the mapping. You cannot edit the mapping.

Data Integration Hub

generates the workflow based on the mapping. The workflow runs during the publication process. The publisher publishes only tables and fields that are mapped from the source to the topic. If the tables that are defined in the mapping do not exist in the source connection, you must add the required tables to the source before you run the publication. Otherwise, the publishing workflow fails during run time.

If you want to run a pre-process on the publication, you might be required to set pre-processing settings. Before you start creating the publication, get the required parameter settings.

The following pages appear in the publication wizard for this type of publication:

General. Define basic publication properties.

Processing. If you want to run a pre-process on the publication, select a publication pre-processing workflow. If the pre-process includes parameters, the parameters appear in this page. The content of the page depends on the workflow parameters that the developer defines. The developer imports the workflow to

Data Integration Hub

with the parameter definitions. The developer also determines the layout of this page. If required, set the values of the parameters.

Source. Select the data access connection to the source from which

Data Integration Hub

reads the data.

You can combine data from multiple source tables into a single topic table by creating a join or multiple joins.

A join combines columns from two or more tables in the database. You can create multiple joins, and you can combine data from joins into new joins. Joins are virtual entities, and are not created in the source database or in the topic.

Field Mapping. Review the publication field mapping, and if required, edit the mapping that

Data Integration Hub

generates by default. You can manually map source tables and fields to topic tables and fields.

Filter. Define the data that the publication published by setting filter conditions on table columns.

Schedule. Define the method and the frequency of data publishing. You can select to run the publication manually or by an external trigger, or you can select to publish the data according to a schedule that you define.

Permissions. Assign categories that restrict access to the publication. You can assign permission to a publication only if the associated application has assigned categories. If you do not assign categories to the publication, it inherits the categories from the associated application. If there are no categories assigned to the application, all

Data Integration Hub

users can access the publication.

Summary. Review the publication settings and save the publication.

Publication Types

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal