Thanks Bruno, looks good option.
Is there any sample or guideline to create the Queue and the Connection Factory?
There're a lot of parameters like the provider endpoint, destination type, bus name (is safe to use same bus name than other BAW queues) ....
I would like to try this option but the doc is really short on this.
If you have a sample configuration would be great.
------------------------------
Eduardo Izquierdo Lázaro
Automation Architect
DECIDE
+34609893677
------------------------------
Original Message:
Sent: Tue May 11, 2021 08:04 AM
From: Bruno Charpentier
Subject: Which is the best way to export BAW data to an external Data Warehouse without IBM BAI?
The best way is to use the emission of XML DEF events in a JMS queue (https://www.ibm.com/docs/en/baw/20.x?topic=events-capturing-business-automation-workflow-external-consumption). Then you can implement your own event consumer that parses the events and inserts them in the external Data Warehouse.
------------------------------
Bruno Charpentier
Original Message:
Sent: Tue May 11, 2021 07:54 AM
From: Eduardo Izquierdo Lázaro
Subject: Which is the best way to export BAW data to an external Data Warehouse without IBM BAI?
One option can be running queries directly against BAW DB tables like LSW_BPD_INSTACE, LSW_BPD_INSTANCE_VARIABLES, ... I guess this is not a recommended approach.
Maybe using a TWSearch JavaScript in a process to export results to a csv or directly to the external DW. For instance, the process can run daily lo export the data.
Or use System Task in the processes to write data to the external DW in specific process points. This option has some drawbacks.
Best option would it be using API REST, however I didn't find a, appropriated API, is there any?
What is the best approach?
------------------------------
Eduardo Izquierdo Lázaro
Automation Architect
DECIDE
+34609893677
------------------------------