Azure Data Factory Oracle Connector - Proxy User authentication not working

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.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-06-06T19:23:17.777+00:00

Hello @Arjuna Ramachandra Varma Mandapati ,

Thanks for the question and using MS Q&A platform.

As per my internal research, looks like Proxy user authentication is supported.

Have you tried the below values configured in your connector? If not, could you please give a try as shown below and let us know how it goes.

User name format: - please try using just <UserID> for User name and adding an Additional connection property: Property: ImpersonateUser, Value: <ProxyUserID>

If you test connection is successful but wasn't able to list the tables, could you please try hardcoding the table name and try to do a data preview and let us know how it goes.

Thank you
Arjuna Ramachandra Varma Mandapati 1 Reputation point

2022-06-07T04:32:23.737+00:00

Thanks for the response.

I already tried Additional connection property ImpersonateUser and hard coded the required table name in the dataset. In data preview It shows an error message.
ERROR [42S02] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
The same table, I can query from the Oracle SQL Developer.

For additional connection property ImpersonateUser if I type an incorrect value also it says that the connection is successful. Check the below screenshot where I provided incorrect value and connection is successful. Based on my observation, it seems that it is ignoring the additional connection property.
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-06-08T20:42:32.33+00:00

Hello @Arjuna Ramachandra Varma Mandapati ,

Thanks for additional details. This looks strange and needs a deeper analysis.
For deeper investigation and immediate assistance, if you have a support plan you may file a support ticket, else please let me know here.

In case if you have support plan, please do share the support ticket number once it is filed so that we can track it internally.

Thanks
Harshal Sonparote 1 Reputation point

2023-03-16T17:40:18.16+00:00

Hi All - is there any solution available for this issue in ADF. I am facing similar issue.
Brian Lawes 0 Reputation points

2023-08-09T16:33:40.0866667+00:00

Same issue here. Working with support to figure it out. :)

1 answer

Brian Lawes 0 Reputation points

2023-08-25T15:37:34.47+00:00

Looks like this is not supported. Please use the link below to add your vote for this feature.

https://feedback.azure.com/d365community/idea/2b9f1402-6d26-ec11-b6e6-000d3a4f032c
Please sign in to rate this answer.

0 comments No comments
Sign in to comment