Quick start
This quick start takes you from an IBM i table to change events in your target. It has four steps: prepare IBM i, install InfoCDC and add a table, choose a consumer, and verify the flow.
Step 1. Prepare IBM i
Check the following for every table that you want to replicate:
- The IBM i OS release level is 7.1 or later.
- The table is journaled with
*AFTERor*BOTHrecord images. Use*BOTHif you need delete operations or filtering on specific column changes. - The table has a primary key or a unique key. For a legacy file without a key, plan a user-provided composite key.
For the complete list, see IBM i requirements and considerations.
Step 2. Install InfoCDC and add a table
- Contact the Infoview sales team to receive the application save file and a trial license.
- Upload the save file to IBM i, restore it in the
QGPLlibrary, and runCDCINSTALL. Enter the license string when you are prompted. See Installation for the commands. - Open the main menu with
ADDLIBLE INFOCDCCOMandCDCMAINMNU. - Select Work with Table Configuration, type the library and table name, and press F6. Choose the operations to listen for and the columns to replicate, then press F10 to save. See Table maintenance.
InfoCDC creates the objects that it needs for the table, such as the data queue and the format table. It adds the replication flow in INACTIVE status, so that the consumer can connect to the data queue first.
Step 3. Choose a consumer
Connect one consumer to the data queue. Pick the one that matches your target.
Use the Hub to replicate directly to a JDBC database (such as MySQL, PostgreSQL, or SQL Server), to write files to cloud storage, or to publish to a message broker.
- Install and start the Hub.
- Create a connection to your IBM i system. See Getting started with the web UI.
- Create an outbound Data Flow that reads the InfoCDC data queue. See the configuration example for a database target and File sinks for files.
Use the connector if you operate Kafka and want the changes in Kafka topics.
- Download the connector from Confluent Hub and install it in your Kafka Connect environment. See the Quick start of the user manual.
- Configure the source connector for the InfoCDC data queue. See Source connector configuration properties.
Use the connector if you process changes in Mule flows.
- Install the connector in your Mule project. See Installing and configuring.
- Add the Data Queue Listener as the message source of a flow. See Configuring the Data Queue Listener.
Step 4. Start the flow and verify
- On IBM i, open Work with Replication Flows, start the flow with option 1 (or press F2 to start all inactive flows), and press F5 to confirm that the flow is active.
- Change a row in the journaled table.
- Check that the change arrives at your target: a row in the database, a message in the Kafka topic, or an event in your Mule flow.
If you use the Hub and the Data Flow does not start or fails, see Data Flow states and errors.
Next steps
- Hardening and scaling before you go to production.
- Tutorials and examples for end-to-end scenarios.