Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zomino
Starting Member
2 Posts |
 Posted - 2010-01-29 : 09:22:20
|
| Hi,I'm about start on this new project of writing SSRS reports pulling data from AS400/db2 dabatase. I like to know what would be the best way of doing this. I'm considering performance, speed and best set up of this project. Should I link sql and db2 and run queries in sql cause I think this is faster than running the queries in ssrs or just use ODBC and pull the data directly from SSRS, please helpProject Scope:- write ssrs 2005 reports pulling data from as400/db2technology avaible:sql 2005 databaseas400/db2 databasessrs 2005 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-30 : 01:10:01
|
| I would suggest creating a linked server with as400/db2 database and using four part names in sql to refer to as400/db2 database objects |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2010-01-31 : 13:23:31
|
| Actually I had great experience with utilizing ODBC and then creating a datasource with ODBC as the delivery mechanism.I see you posted to an old thread (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132814)I had no issues performance wise using that methodJohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|
|
ssrs 2005 pulling data from AS400/db2