When you develop a publication real-time workflow, you create the source based on real-time data that you want to publish. You set the target of the publication real-time workflow to the
Data Integration Hub
publication repository. You can also add properties to store other
Data Integration Hub
values that you want to send from PowerCenter.
You define the source of a publication real-time workflow based on the following real-time data:
Data in the Apache Kafka stream
Structure of the JMS
Web service source
You create the source and the target definitions in the PowerCenter Designer in the same way that you create source and target definitions for other mappings. For general information about source and target definitions, see the
PowerCenter Designer Guide
.
When you create the source and the target definitions, consider the following guidelines:
Use the DIH__STAGING connection in the target definition.
The database target type must match the database type of the
Data Integration Hub
publication repository.
The target must contain DIH__PUBLICATION_INSTANCE_ID and DIH__PUBLICATION_INSTANCE_DATE columns.
The following image shows an example of a target with the DIH__PUBLICATION_INSTANCE_ID and DIH__PUBLICATION_INSTANCE_DATE columns: