Reputation: 557
Can I get some guidance on how I could read the CDC journal log on our IBM (AS/400) database. Today we are repliacating the journal events onto a MSSQL database but I would like to look into doing this with C# instead.
Today the CDC journal events stored int MSSQL are later produced onto a kafka topic for other consumers to use, and this could maybe be done faster if the journal are read by the C# application itself than the reading from the MSSQL database.
Upvotes: 0
Views: 615
Reputation: 416
You might try using Apache NiFi to reduce the code under management for your end to end flow. https://community.hortonworks.com/articles/113941/change-data-capture-cdc-with-apache-nifi-version-1-1.html
Upvotes: 0
Reputation: 23803
There is a system API available, Retrieve Journal Entries (QjoRetrieveJournalEntries) API
You might find it easier to have a server side program call the above API and send the information to your C# client.
Upvotes: 2