Saturday, February 25, 2012

Reporting on IBM DB2 UDB Database

It is my understanding that I can use Microsoft Reporting services to report on other databases other than SQL Server. What would i need to do to report on an IBM UDB database? Any help would be appreciated.Yes you can connect to other databases. We connect to an Informix database via ODBC.

1) You need to create an ODBC Datasource "System DSN". (Control Panel/Administrative Tools/Data Sources ODBC). Test it and make sure it works, then:

2) Create a "Linked Server" using the SQL Server Enterprise Manager which can be found in the "Security" subdirectory. You will need to supply the Datasource you created in step 1.

Good Luck! Jane

No comments:

Post a Comment