Real time access to iSeries

I have a database maintained on an iSeries. I have an application that uses
MS SQL. I need to pull data down from the iSeries to my MS SQL server in real
time or just once a week, doesn't matter. Is this easily doable and are there
any "gotcha's" to be aware of?
Thanks!
Mbrewer.
You should be able to create a linked server to an iSeries. In fact, the
Books Online has an example of defining the link in the sp_addlinkedserver
topic.
http://technet.microsoft.com/en-us/library/ms190479.aspx
Once you have a linked server, then you can create a schedule job to do the
updates from the iSeries database into SQL Server.
For more hits, do a Technet search: "sql server" DB2 "linked server"
Also, on Technet I searched: "sql server" iseries "linked server"
http://www.experts-exchange.com/Database/DB2/Q_22592124.html
There is also a BizTalk connector, but you probably are not using that
solution: http://technet.microsoft.com/en-us/library/aa770734.aspx
RLF
"Mbrewer22" <Mbrewer22@.discussions.microsoft.com> wrote in message
news:D26B76E1-A79C-4AE4-A4C9-F123C8B683F3@.microsoft.com...
>I have a database maintained on an iSeries. I have an application that uses
> MS SQL. I need to pull data down from the iSeries to my MS SQL server in
> real
> time or just once a week, doesn't matter. Is this easily doable and are
> there
> any "gotcha's" to be aware of?
> Thanks!