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***
Pegasystems Inc.
IN
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.
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.
| Use Last Updated Time as Start | For classes that include the property pxCommitDateTime, select this check box to extract all data that was created or updated since the last time the Extract rule was run. This field is not relevant until the Extract rule has run at least once. |