Azure Data Factory Oracle Connector - Proxy User authentication not working

2022-06-03T16:50:17.93+00:00

Azure Data Factory Oracle connector is working with regular user name and password. But when we are trying to use the proxy user authentication like username[schema] it throws error message.

ERROR [28000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied

Same connection syntax works in Oracle SQL Developer Tool. with Data Factory oracle connector we tried with Additional Connection Properties. Added ImpersonateUser property name with required value. Connection succeeded but the dataset table list doesn't shows the required tables. We observed that connector is not validating the additional connection properties, if we provide property name as test it doesn't throws any error.

Is Data Factory Oracle Connector support proxy user authentication? If so what is the syntax or additional property name?

We are not looking for proxy server which is clearly mentioned as not supported in documentation.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,285 questions
{count} votes