Today I wondered how to get #OpenText #BizMapper to insert a data row into a #database table, after processing the input source that is read from a #DB, while it constructs a document output to the file system (or an #mq, not a db).

It does not seem possible.

The solution is to turn around the process: get the data row entered first, then use that to construct the output document, then update the data row in post.

#ETL #dataMapping #EnterpriseMessagePump

#EnterpriseMessagePump #ApacheKafka #FreeBook by Graig, Petrie, Berglund (2020): "Apache Kafka Transaction Data Streaming for Dummies", published by Wiley & Sons Inc, shared by Confluent for marketing purposes. Direct download link:
https://assets.confluent.io/m/2726595b67969f09/original/20191007-EB-Apache-Kafka-Transaction-Data-Streaming-For-Dummies.pdf
#EnterpriseMessagePump #ApacheKafka #FreeBook by Graig, Petrie, Berglund (2020): "Apache Kafka Transaction Data Streaming for Dummies", published by Wiley & Sons Inc, shared by Confluent for marketing purposes. Direct download link:
https://assets.confluent.io/m/2726595b67969f09/original/20191007-EB-Apache-Kafka-Transaction-Data-Streaming-For-Dummies.pdf