Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

mszpot89
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.

mszpot89
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.