Oracle Proxy User

Question

Has anyone been successful with getting Alteryx to connect to a Gaia Oracle Service (GOS) w/ Kerberos database via a Proxy user?

I can currently connect to the GOS Db without a problem using the proxy settings through SQL Developer but trying to replicate it in Alteryx to use the proxy user it is not possible.

Ie: Open SQL Developer - > Go to the connection -> Right click properties -> Click Proxy User -> enter specific proxy user i want to use

Within Alteryx:

connection string i've used:
oci:[]/[]@host:port/servicename [Just shows things my LDAP ID has access to]
OCI:[]/[]@MY_SERVER_TNS [Just shows things my LDAP ID has access to]

OCI:ProxyUserName/[]@host:port/servicename  [Errors out]
OCI:ProxyUserName/[]@MY_SERVER_TNS [ Errors out]

And for those unfamiliar, [] is the correct password when it comes to Kerberos connections.

TNS in my TNS file :
MY_SERVER_TNS= (DESCRIPTION =
(CONNECT_TIMEOUT=120 sec)
(RETRY_COUNT=20)(RETRY_DELAY=3)
(TRANSPORT_CONNECT_TIMEOUT=3 sec)
(ADDRESS_LIST =
(LOAD_BALANCE=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.svr.us.abc.net)(PORT = 0000)))
(CONNECT_DATA= (SERVICE_NAME = MY_SERVER_TNS_DP012345_123456789098_O_READWRITE)))

jbravman_ · Answer

So turns out you can't really do it in Alteryx, especially via OCI. went through an alternate method to just get rid of proxy user requirement.

danilang · Answer

Hi @jbravman_

Is there away to print out the final connection string that is being output from SQL developer.  If so, you may be able to replicate that connection string in the OCI connection string.  Another option is to try other providers, like the Oracle 12c client, generic ODBC or OLEDB.

Dan