Yes, the connection from Oracle to ADF through SHIR is secure. It utilizes encrypted channels for data transmission.
If the cloud data store supports HTTPS or TLS, all data transfers between data movement services in Data Factory and a cloud data store are via secure channel HTTPS or TLS.
Azure provides a secure connection through TLS 1.2 encryption for data in transit between Oracle and Azure Data Factory.
To enable encryption in transit while moving data from Oracle follow one of the below options:
- In Oracle server, go to Oracle Advanced Security (OAS) and configure the encryption settings, which supports Triple-DES Encryption (3DES) and Advanced Encryption Standard (AES), refer here for details. ADF automatically negotiates the encryption method to use the one you configure in OAS when establishing connection to Oracle.
- In ADF, you can add EncryptionMethod=1 in the connection string (in the Linked Service). This will use SSL/TLS as the encryption method. To use this, you need to disable non-SSL encryption settings in OAS on the Oracle server side to avoid encryption conflict.
Absolutely, enabling TLS 1.2 on both the Oracle server and ADF SHIR configuration will further enhance the security of your data during migration. Ensure that non-SSL encryption settings in Oracle Advanced Security are disabled to prevent any encryption conflicts.
More info on this subject here : https://learn.microsoft.com/en-us/azure/data-factory/data-movement-security-considerations
Hope this helps