Connect Oracle Autonomous Database in Microsoft Azure Data Factory
Content
Anyone in here have already connected Oracle Autonomous DB in Azure Data Factory?
We are trying to implement some data copies from SQL Server to Oracle, but I am not able to reach Oracle Autonomous Database, using standard host, port, service name and credentials. Maybe any security layer related to the Wallet is missing? I can't find any documents explaining.
The error when trying to connect is:
ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.
ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.
Thanks,
Guilherme
Version
18c0