Question
Can BIX export data into different type of database?
We're using PEGA with IBM DB2.
Recently, we were asked to export application data into another database for data analysis.
The target database is MemSQL, can we accomplish this with BIX?
Besides, how can we export data only once with BIX?
For example, we have a work table, and also a BIX target table created.
We planned to run the BIX periodically, how can we make sure that works only be exported once?
There will be errors if the target table has primary key when export a single work twice.
Thanks very much.
***Edited by Moderator: Pallavi to update platform capability tags***
The target database is MemSQL, can we accomplish this with BIX? ---> you can create a different schema and you can mention it as target schema in BIX.
We planned to run the BIX periodically, how can we make sure that works only be exported once? ---> You can make use of filter criteria for this.