Get Data from ION Database connector based on event

Prabodha Amarapema

We have a requirement to retrieve data from a database based on an incoming document in an ION Data Flow. However, the current database connector only supports scheduled data retrieval. I recall that this option was available in the on-prem version.

I’m bit hesitant to use a schedule, as I need this to run in an event-driven manner.

Any suggestions?

Kevin Heiman

The MT ION currently does not support the process response ( Process/Acknowledge verbs used in one) pattern for a Database connector. Supported
We have used solutions where this is broken into a Write followed by a Read.

Several ways to approach that using IO Box or simply a response table. Generally there needs to be some correlation identifier.
Assuming you chose to use Write Database to start the transaction, the Database Stored Procedure as transaction parameters and a correlation ID and it would assemble the response and write it to a) staging File b) out box c) set a flag in the transaction. There could even be a DB trigger to do the processing.
You would schedule a Read service to read the staging Database (or outbox) and process that with the correlation ID.

You may want to have the read mark the transaction as processed or remove it. Or even return all available responses in one go.
We have use other variations but it is a matter of using the various read and write.
You can add other parameters to the Connection point Stored Procedure invocation to pass additional environment data.