We need to join IH with a custom table reading form internal PostgreSQL DB, apply a trasformation on it, and write the result to an external Oracle DB using Pega 8.3.

If possible we would like to use Pega functionalities avoiding custom ETL processes. Maximum expected volume is 1M records per day, with an AVG of 300k.

Is DataFlow able to do this? is it the best option we have or should we use BIX instead?

thanks