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***