Hello,
I need to log on to my Oracle database, using the Alteryx In-Database, using a proxy user.
**When using a proxy user (Oracle), the right syntax looks like: proxy_user[owner_user].
The problem is that Alteryx does not allow to type more than 30 characters in the username. The length of my the proxy_user[owner_user] is more than 30 characters.
When I connect with the same parameters with other tool such as SQL Developer it works fine.
Any idea how could I connect properly with my parameters in Alteryx? Is there another option?
Thanks in advance!
Solved! Go to Solution.
Sorry to hear the character limit is causing a problem!
I don't believe it's possible to alter that character limit, however, I think you could create a connection string and use that instead.You would need to paste the connection string directly in to the 'Connect a File or Database' field:
Your connection string would need to be formatted like this: