Question

3
Replies
183
Views
Sandip_Chatterjee Member since 2016 1 post
AI4Process
Posted: February 28, 2019
Last activity: March 21, 2019
Closed

Pega BIX OOTB Operation Mechanis,

Hi All,

I was wondering if I can get some reference material / helps regarding the below questions (as I couldn’t find anything relevant in PDN or BIX Documentation so far) would be really great.

Context:

  • Pega GOA and ROD (Ratingen Oracle Database) Integration via Pega BIX

Current Scenario:

  • BIX Extract rules is set up with a case data model consisted with 4 different tables (for different page lists)
  • Target DB has 1 main table and 3 sub tables at ROD side. (Sub tables are for Page Lists)
  • An agent is set up to invoke OOTB pxExtractDataWithArgs to generate and write information to target tables.
  • For each trigger – there will be only one case data that BIX is going to send out.

Questions:

  • How does BIX insert case data into all 4 different tables - Does it happen sequentially, i.e. records are inserted in one table after another, or does it happen in parallel , i.e., case data is inserted into all four tables at once/in parallel?
  • Does Pega commit as a whole at Transaction Level , or does it commit for each insert statement independently.

We tried to DB trace but still unable to decode the details. This questions we are asking as the downstream database system i.e. ROD is trying to find a way to conclude the Pega DB transaction for their design purpose.

I really appreciate your help, please let me know if you need any more details.

***Moderator Edit-Vidyaranjan: Updated SR details***

Pega Platform Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn