Get data from AS/400 into SQL Server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CAM - 25 Jul 2008 06:09 GMT

Hello,

I am a new user to SQL Server 2005. Currently I have the task in producing
a report using Crystal Report and viewing data thru ODBC to get data from
AS/400. It is a
cumbersome process, extracting the data Many times I do not need a report,
but a query or view. Is it possible to get data from
AS/400 and extract into SQL Server 2005 and even SQL Server Express 2005?
If so how? ODBC connect? Any tips will be appreciate. Thank you in
advance.

Cheers

Reply to this Message

Eric Isaacs - 25 Jul 2008 07:41 GMT

If you have ODBC access to the AS/400, you can likely create a linked
server from the AS/400 database to SQL Server. Here is a link to an
article that might get you started:

http://www.sqlservercentral.com/articles/Distributed+Queries/updatingas400linked
servertablesfromsqlserver/2331/

You may need to register (no cost) with sqlservercentral to view that
link.

-Eric Isaacs

Reply to this Message

Plamen@sqlstudio.com - 25 Jul 2008 13:48 GMT

I have used with AS/400 both ODBC and OLEDB, depends on which driver
and client interface you have. Normally the AS/400 client includes the
driver. Then you can create a linked server and query the data.
However, in my
experience this can be slow with a large data set (if you directly use
it for the reports). A better approach may be to download the data to
a table in SQL Server on regular intervals (can be scheduled as job)
and then use the SQL Server table for reporting.

If for any reason you have to update data on AS/400 then journaling
has to be enabled on AS/400.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply to this Message