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.