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