We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Oracle connection workflow (64 bit, indbc) not saving to the server

marcin2x4
9 - Comet

I'm trying to save in-db workflow using .indbc (as a workaround for setting up connections on the server) oracle connection file (OCI, ODBC configuration) and I get below errors:

 

 

 

image.png

 

 

image.png

 

I assume it is related to the fact that drivers are not available on the server, correct?

 

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

That seems to be the case. You can define the connection, but the drivers and supporting files still need to be installed on the Server workers.

marcin2x4
9 - Comet

I found the solution @CharlieS 

 

1. Instal 64bit driver on Alteryx Server (ODBC + OCI)

2. While uploading in-db workflows to the server use IN_DB Connection File (embedded credentials) in the workflow. That way Alteryx Server overrides default credentials with attached in the workflow using installed driver.