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

Connect In-DB to 32-bit Database

FieldEngineer
5 - Atom

I'm currently trying to use the Connect In-DB tool to import data from an absolutely behemoth database and wanted to use the Filter In-DB tool to cut down on the amount of data.

 

However while I am able to successfully connect the 32-bit Oracle database using the Input Data tool, I am receiving the "architecture mismatch" error with the Connect In-DB tool.

 

I'm guessing the issue is because the database itself is 32-bit. Does anyone know of any workarounds similar to what is available with the Input Data tool?

 

Thanks!

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

You are correct that 64-bit drivers are required for the use of In-Database tools on Oracle..

https://help.alteryx.com/2018.2/DataSources/Oracle.htm

 

In most cases, the operations of the In-Database tools are the same as constructing more complex queries within the standard Input tool. If you provide more information of what you'd like to achieve, we could help with the necessary syntax. For example, if you wanted to filter a table to only return records that meet a specified criteria, a WHERE clause can be added to the input query to achieve the same results.

 

 

 

FieldEngineer
5 - Atom

Thank you for the clarification. I was initially attempting to do the same in the SQL Editor however when I was checking the viability of my WHERE clause by clicking Refresh, it kept returning blank results. My assumption is that there was some sort of peculiarity with the date/time (YYYY-MM-DD  HH:MM:SS) stamp of my data that just wasn't jiving with the syntax of my WHERE clause.

Labels