MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / How to Edit Environment Variables for Oracle Data Connection
How to Edit Environment Variables for Oracle Data Connection
user

Created/Edited - 4/26/2026 by Tessa Smithers | Alteryx

How To

Edit system environment variables for Oracle data connection:

 

The goal is to make the Oracle Instant Client discoverable to Alteryx. Environment variables should be investigated when you get an error connecting to Oracle or it's taking an unusually long time to connect.

 

Example of an error:
 

ocidll.png

Environment
  • Alteryx Designer, Alteryx Server
    • All versions
  • Oracle
    • All versions
  • Oracle Instant Client
    • All versions
  • Windows Administrator privileges
Procedure

 Search for 'env' in the Windows search bar and select 'Edit the system environment variables'.



searchenv.png 

2. Select 'Environment Variables...', go to the 'System variables' and scroll down to the 'Path' variable. If there are multiple paths referencing Oracle, ensure that the path you are editing is the first in the list.


pathvar.png 

3. Add the path to your Instant Client location to the list of paths.


envpath.png 

4. If you have a "tnsnames.ora" file to use for the data connection, search for a variable called 'TNS_ADMIN'. It should point to the location of the TNSNAMES.ora file. If it doesn't exist, click 'New' and add it.


tnsadmin.png 

 

Common Issues

Spoiler (Highlight to read)
You cannot get administrative privileges.
Edit the user paths instead. These changes will only be in effect for that set of user credentials.
Additional Information
Was this article helpful?