Set up ODBC Connection For IIS DataStage (v.8.5)

Configure Access to ODBC Data Source For IIS DataStage (v8.5, Window Server)

Thie following information can also be found here.

From the Engine Tier;
· Launch the dos Prompt as Adminstratior
· Change to cd c:\windows\syswow64
· Lounch odbcad32.exe

 

     C:\Windows\SysWOW64>odbcad32.exe

 

 



· Select a ODBC driver that you want to use, for example, SQL server. Make sure to only use drivers that are provided by IBM

 

 

· Define the DSN Connection by select the System DSN tab, then select ADD. Give the DSN a name, and provide the server, user id and password. You can also specify a default database.

 

When you are done, make sure to test the connection. It all is fine, you should be able to see the DSN from the IIS components such as DataStage or Information Analyzer.

 

Related Note:

• Configuring the DataStage v8.5 Parallel Engine On Windows
• Start WebSphere InfoSphere Server Using Administrator User in Window 2008 Server