Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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.