Forum Stats

  • 3,769,716 Users
  • 2,253,014 Discussions
  • 7,875,158 Comments

Discussions

Connect Oracle Autonomous Database in Microsoft Azure Data Factory

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