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)