Hi,
I'm evaluating Sql Server 2005 for my company. Here we also use AS400 DB2 for our ERP. Could I use Reporting Service to create report on DB2 in the same way as someone could use MS access?
TIA
Marco Paci
Yes. You need to go to the IBM web site and download the db2 drivers. I think the package is IBM DB2 Client Access Enabler (CAE).
You then need to write your DB2 SQL in the report which can get kind of hairy. If I can get away with it, I write SSIS packages and write the reports using SQL Server.
No comments:
Post a Comment