Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

HELP - InDatabase oracle 32bit connection

Dima1
7 - Meteor

Hi All

 

I want to connect to 32Bit Oracle using In-DB connection and have below error.

 

 

Could you please advise if it is possible to get this connection or alteryx support 32-bit only in Input data and not In-DB

 

 

 err.PNG

 

Thank you in advance

5 REPLIES 5
mborriero
11 - Bolide

You can connect to Oracle database either with IN-DB tool or not.

 

You need to configure your TNSnames.ora file.

 

Try to follow this guide to include your database information in the TNS file

 

http://kb.tableau.com/articles/howto/setting-an-oracle-connection-to-use-tnsnames-ora-or-ldap-ora

 

Then you will be able to connect to the oracle database.

 

Capture.JPG

 

 

 

 

 

 

AtsukoC
Alteryx Alumni (Retired)

You need 64-bit Oracle driver to use our In-DB tools. You can find more information here https://help.alteryx.com/11.3/DataSources/Oracle.htm

 

Thanks,

Atsuko

Dima1
7 - Meteor

 

Hi Atsuko,

 

thanks for reply!

 

I can connect to 32bit oracle using Alteryx and Input tool.

 

Do I still need any kind of drivers to install to get connection using In-DB 32bit?

 

Thanks!!

Dima1
7 - Meteor

UP

LindaT
Alteryx
Alteryx

In-DB only supports 64-bit connections.  There is no way to use 32-bit connections.

Labels