community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Asteroid

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?

 

Highlighted
Alteryx Certified Partner

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.

Asteroid

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.