Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.How to Edit Environment Variables for Oracle Data Connection
Created
on - edited on by
KenL
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:
Prerequisites
- Alteryx Designer, Alteryx Server
- All versions
- Oracle
- All versions
- Oracle Instant Client
- All versions
- Windows Administrator privileges
Procedure
1. Search for 'env' in the Windows search bar and select 'Edit the system environment variables'.
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.
3. Add the path to your Instant Client location to the list of paths.
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.
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.
Edit the user paths instead. These changes will only be in effect for that set of user credentials.
Additional Resources
