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 |
|
Movva
Starting Member
15 Posts |
 Posted - 2009-09-15 : 09:32:56
|
Hi, Our users are requesting for a report on a data that is on AS400. I would like to do it using Reporting Services in SQL Server 2005. But before I do start thinking about developing it I want to know if SQL Server Reporting Services can talk to AS400. Please provide with any inputs if any of you had done this before. have few more questions to add to thos posting. Our proudction box runs on SQL Server 2005. I have SQL Server 2008 Express edition on my developer box. I am not sure if I can connect to the AS 400 from my developer box (using SQL Server 2008 Express edition) and develop a report in SSRS. If I can connect and develop a report then can I deploy/move that report to the production box that has SQL Server 2005? If I can't deploy the Reports that were developed in SQL server 2008 express edition to SQL Server 2005 then I will have to develop a report directly on SQL Server 2005 production server. Thanks, L |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-24 : 09:53:09
|
| Movva, You most certainly can use DB2/400 as your datasource. I have not been on a /400 in 2 years but I think I can still describe what we did.1) You need iSeries Access (or whatever they are calling it now) installed on your report server and on your development PC2) You need to create an ODBC data source with the EXACT SAME NAME on your server and any developer PCsYou then create your Shared Data Source and on the drop down for Type, select ODBC. Click the Edit button to the right of Connection String and select the ODBC data source you created from the drop down titled Use User or System Data Source Name. Test the connection and you can go from there. Depending on how they install iSeries Access, you may have a slightly different syntax for some of your table and library names.John |
 |
|
|
Movva
Starting Member
15 Posts |
Posted - 2009-09-24 : 11:41:56
|
| John, Thanks for all the useful inputs. I have been dragged onto a different thing now. As this is going to a new (that I never did before) so I just created a report in ASP.NET directly connecting to AS400/iSeries to save time. But I will definitley try creating the same report using SSRS in my personal time. So that I could build reports easily for all future requests. I will get back to you to let you know how it goes. If I were successfull then I will probably write a small article (as there is nothing available online so far to my knowledge) to help our fellow deverlopers out there who have the same scenario.Thanks again!Movva |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-24 : 12:48:07
|
| You would like it. I did 18 years on AS400 (installed my first in Singapoe for Kodak Before it was officially released) and it is by far the easiest and most stable platform I have ever dealt with. We had our BI tool in SSRS but we had drill throu to the original data on AS400 at my last AS400 job.John |
|
|
|
zomino
Starting Member
2 Posts |
Posted - 2010-01-28 : 10:46:27
|
| Hi,I'm about start on this new project that is similar to Movva's. I can directly pull data from AS400/db2 dabatase using ODBC connection in SSRS, I just like to know if this would be the best way of doing this. I'm considering performance, speed and right set up of this project. Should I link sql and db2 and run queries in sql cause I think this is faster than storing the queries in ssrs, please help.Project Scope:- write ssrs 2005 reports from as400/db2technology avaible:sql 2005 databaseas400/db2 databasessrs 2005 |
|
|
|
|
|
|
SSRS - Data source AS400