Operator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Automatic Database Subscription

Use this type of subscription to consume data into a relational database target if you want

Data Integration Hub

to create the PowerCenter workflow for the subscription.

For subscriptions with a relational database target, select the relational database connection.

Data Integration Hub

explores the target 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 target connection,

Data Integration Hub

maps the topic tables and fields to target 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 target.

If none of the tables that are defined in the topic structure exist in the target 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 target.

If the connection does not contain metadata access,

Data Integration Hub

cannot explore the target 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.

If the subscribing application requires only a subset of the data that is published to the topic, you can define which tables and columns to consume. You can also filter the rows to consume.

Data Integration Hub

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

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

General. Define basic subscription properties.

Processing.

If you want to run a post-process on the subscription, select a subscription post-processing workflow. If the post-process includes parameters, the parameters appear in this page and are optional. If required, set the values of the parameters.

Join. You can pull data from multiple topic tables into a single target table by creating joins. You can create multiple joins, and you can combine data from joins into new joins.

Target. Select the data access connection to the target to which

Data Integration Hub

writes the data.

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

Data Integration Hub

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

Filter. Define the data that the subscription consumes by setting filter conditions on table columns.

Schedule. Define the method and the frequency of data consumption. You can select to consume the published data immediately after the data is ready, to run the subscription manually or by an external trigger, or to consume the data according to a schedule that you define.

Delivery. Define the delivery options of the data to consume. For subscriptions that run either manually or by an external trigger or that run by schedule, choose the data delivery scope and delivery format: all available subscriptions, all available subscriptions - aggregated, or the latest subscription only.

For all subscriptions,

choose how

Data Integration Hub

handles data that exists in the target application: append the new data to the existing data in the target, insert new rows, or overwrite the existing data in the target. For subscriptions where the type of topic to which the subscription subscribes is Full, if you select to append the new data or to insert new rows, you can select to delete rows that don't exist in the topic from the target.

Rename Saved Search

Table of Contents

Operator Guide

Operator Guide

Automatic Database Subscription

Automatic Database Subscription