Do we need to worry about encryption in transit if we use Push Down Optimization in ETL tools Informatica etc

28 Views Asked by At

In ETL tools, Push down optimization enables processing on the Databases. since data never makes it to ETL server, do we need to worry about encryption in transit? Thanks

1

There are 1 best solutions below

0
Koushik Roy On

Absolutely not. Reason

  1. Pushdown optimization does all operations in DB side so its safe.
  2. Even if Informatica pulls data into its serve, it imports data in binary format and that is not human readable so i do not think there is any risk here.