Database Connection 2021.2 to 32-bit Oracle OCI

[stlkng]

Hello,

Using input data tool I tried to connect to our 32-bit Oracle OCI database and I got an error message "OCILogon2 Error:ORA-12514:TNS:listerner does not know of service requested in connect descriptor" What does this error mean? How do I get connected to an oracle database?

[Thableaus]

Hi @stlkng 

What kind of connection type are you using? How did you try to connect through Alteryx? ODBC? OCI, Quick Connect

There's this post that could help you do it -> https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas...

Cheers,

[BrandonB]

My first question would be, is it necessary for you to use the 32bit connection? 64bit is significantly faster if that is an option and 32bit connections are legacy and being phased out. 

Here is a helpful document that outlines Oracle connectivity within Alteryx: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas... 

[BrandonB]

@Thableaus you beat me to it!

[stlkng]

Options => Advanced Options => Manage Data Connections => Add

Connection => Other

Name: PRODP

Connection Type: User

Connection String: hit the drop down => 32-Bit Database Connections =>

Oracle OCI

TNS Server Name: PRODP

User Name and Pw I use to log into my 32 bit oracle OCI

[stlkng]

My main database is 32-bit Orace OCI - I'll read these 2 links and try - thanks