Saturday, September 13, 2008

SSIS: Connect Using IBM UniData ODBC Driver

Straight to the point on how to create connection using IBM UniData ODBC Driver in SQL Server Integration Services 2005/2008. This driver allow connection from IBM UniData to SQL Server where SQL Server Integration Services as the intermediaries. I assume that UniDataODBC and Uni Call Interface Configuration Editor (UCI Editor) from UniData 7.1 Client installation has been installed.

Add ODBC Data Source, Control Panel>Administrative Tools>Data Source (ODBC)

ODBCDataSource

Setup the Data Source Name, Database and User base on your IBM database configuration. As for the Server dropdownlist, the list is available base on the configuration at Uni Call Interface Configuration Editor (UCI Editor)

UniDataODBCDriverSetup


Create or open Integration Services Project then on Connection Managers tab, right click to add a new connection manager.

newconnection

Select ODBC Connection Manager Type

newconnection2

Basically that is all needed to setup the connection using IBM UniData ODBC Driver. If using Windows Server 2003 x64 then view my post on SSIS: Using UniData ODBC Driver on Windows Server 2003 x64

No comments: