You can use the following products to read, transform, and write real-time data in PowerCenter:
PowerExchange Client for PowerCenter
. Use PowerExchange to capture change data from a variety of relational and non-relational sources on i5/OS, Linux, UNIX, Windows, and z/OS systems. PowerExchange change data capture (CDC) integrates with PowerCenter to capture, transform, and deliver change data across your enterprise in real-time mode.
The PowerExchange Client for PowerCenter (PWXPC) software is installed with PowerCenter and works with the PowerCenter Integration Service and PowerCenter Client tools to retrieve change data from the PowerExchange Listener. The Listener runs on or off the source system. You can include PowerExchange targets in workflows to write change data to target types that PowerCenter does not support, including targets on i5/OS and z/OS systems. You can also use PowerExchange to extract and load bulk data in batch mode to materialize or refresh a CDC target.
PowerExchange for JMS for PowerCenter
. Use PowerExchange for JMS to read from JMS sources and write to JMS targets. You can read from JMS messages, JMS provider message queues, or JMS provider based on message topic. You can write to JMS provider message queues or to a JMS provider based on message topic.
JMS providers are message-oriented middleware systems that can send and receive JMS messages. During a session, the Integration Service connects to the Java Naming and Directory Interface (JNDI) to determine connection information. When the Integration Service determines the connection information, it connects to the JMS provider to read or write JMS messages.
PowerExchange for WebSphere MQ for PowerCenter
. Use PowerExchange for WebSphere MQ to read from WebSphere MQ message queues and write to WebSphere MQ message queues or database targets. PowerExchange for WebSphere MQ interacts with the WebSphere MQ queue manager, message queues, and WebSphere MQ messages during data extraction and loading.
PowerExchange for TIBCO for PowerCenter
. Use PowerExchange for TIBCO to read messages from TIBCO and write messages to TIBCO in TIB/Rendezvous or AE format.
The Integration Service receives TIBCO messages from a TIBCO daemon, and it writes messages through a TIBCO daemon. The TIBCO daemon transmits the target messages across a local or wide area network. Target listeners subscribe to TIBCO target messages based on the message subject.
PowerExchange for webMethods for PowerCenter
. Use PowerExchange for webMethods to read documents from webMethods sources and write documents to webMethods targets.
The Integration Service connects to a webMethods broker that sends, receives, and queues webMethods documents. The Integration Service reads and writes webMethods documents based on a defined document type or the client ID. The Integration Service also reads and writes webMethods request/reply documents.
PowerExchange for MSMQ for PowerCenter
. Use PowerExchange for MSMQ to read from MSMQ sources and write to MSMQ targets.
The Integration Service connects to the Microsoft Messaging Queue to read data from messages or write data to messages. The queue can be public or private and transactional or non-transactional.
PowerExchange for SAP NetWeaver for PowerCenter
. Use PowerExchange for SAP NetWeaver to read from SAP using outbound IDocs or write to SAP using inbound IDocs using Application Link Enabling (ALE).
The Integration Service can read from outbound IDocs and write to a relational target. The Integration Service can read data from a relational source and write the data to an inbound IDoc. The Integration Service can capture changes to the master data or transactional data in the SAP application database in real time.
PowerCenter Web Services Provider
. Use PowerCenter Web Services Provider to expose transformation logic as a service through the Web Services Hub and write client applications to run real-time web services. You can create a service mapping to receive a message from a web service client, transform it, and write it to any target PowerCenter supports. You can also create a service mapping with both a web service source and target definition to receive a message request from a web service client, transform the data, and send the response back to the web service client.
The Web Services Hub receives requests from web service clients and passes them to the gateway. The Integration Service or the Repository Service process the requests and send a response to the web service client through the Web Services Hub.