Question
Banerjee
US
Last activity: 23 Dec 2022 15:25 EST
Exporting interaction history in real time using kafka
Hi,
We have a requirement of exporting interaction history in real time using kafka topic. The platform version is 8.7.3. Whenever an insert happens in any of the IH tables (IH Fact and IH Dimension), can we configure a declare trigger to run, use the trigger activity to compose the JSON message from the IH data attributes and place the message on the kafka topic?
Is this approach recommended? The IH fact table will have huge number of inserts, but the number of inserts in channel or action dimension tables are very minimal. Would there be any performance impacts?
Thanks,
Jaydeep
***Edited by Moderator Marije to add Capability tags***