Both Batch Data Flow and BIX can be used in the PEGA ecosystem to extract data from an external schema into a PEGA table, or vice versa. Also, it is understood that the usage scope of Data Flows are much more wide ranging, and can handle several types of Data Sets.
My specific question is : I have a use case where millions of Customer transaction records are needed to be copied from an external database into a PEGA schema. In such a scenario, would Data flow be a better option to handle this than BIX? If yes, are there scenarios where BIX outperforms Data Flow ?
***Edited by Moderator Marije to add Capability tags***
Given the use case is to extract from a external table into Pega schema.
advantage of BIX is giving you a manifest information for every given extract which gives us a track of what is the extract that happened, how many etc. this data helps us reconciliation of data to check if everything is extracted or not.
where as Data flow does not give this manifest information.
I doubt if BIX can be used for external schema's outside of Pega. BIX extract happens based on pxCommitDatetime Or PxUpdateDatetime . if these are present in external schema outside pega then it is okay.