Unable to connect to Oracle database from ADF

• Question

• 

  

  0

  Sign in to vote

  Hi,

  We need to connect to Oracle database which is installed on our internal server from Azure data factory. I have installed the "Microsoft Integration Runtime" service which successfully connects to the local database; but is unable to establish connection to the oracle database hosted on a server (it is part of the same network).
  

  When establishing the connection via Linkedservice we receive error as:

  Connection failed

  [{"code":9603,"message":"ERROR [28000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied\r\nERROR [28000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied"}]

  Kindly let us know any possible workarounds or options.
  

  
  

  • Edited by Manjiri.Mudgal Tuesday, November 6, 2018 12:22 PM

  Tuesday, November 6, 2018 12:22 PM

  Reply

  |

  Quote