ODBC Connection Instructions for Data Warehouse Use

ODBC Connection Instructions for Data Warehouse Use

PLEASE make sure that you are connected to the VPN before proceeding. VPN software instruction can be found at https://depaul.service-now.com/sp?id=kb_article_view&sysparm_article=KB0010476 DUO two-factor authentication is required. Details available at https://depaul.service-now.com/sp?id=kb_article_view&sysparm_article=KB0010668


1. To match 32 bit applications, right mouse click on odbcad32.exe in C:\Windows\SysWOW64 and choose “Run as Admin”. Please hit "Yes" in the popup window when asked.

NOTE: Conversely, if your ODBC application is 64bit, run odbcad32.exe from C:\Windows\System32 (this is correct even though it may seem the reverse).

2. Choose System DSN and click on Add

3. Choose Oracle in OraClient12c_home2

NOTE: The number after “_home” is not important.


4. Choose Test Connection (If you intend to use this connection please save the Data Source Name)