Accessing SQL Server data-2
I need to access data on an SQL server from our AS/400. I need something quick and cheap.
Help!
Software/Hardware used:
Software/Hardware used:
ASKED:
January 18, 2005 5:50 PM
UPDATED:
January 31, 2005 12:37 PM
Answer Wiki:
i'm not sure of this but you can use Biztalk for something like that.
and if you want to export the data in a sql database to the AS/400, not just storing it in the SQL server and accessing it from the AS/400, then you can use the Export wizard to export the data to any common file format between the two systems, SQL server supports many kinds of formats like CSV text files. it may help
To see all answers submitted to the Answer Wiki: View Answer History.
BizTalk server will not allow native access TO an SQL server FROM AS/400. Exporting data is not the issue. The only methods currently available are using an IBM supplied package, Java/JDBC or a 3rd party package using API’s. There are two out there that I know of that work fairly well. Anyone interested can send me an offline message for the names/sites.
Try more info in your question. A – What application on the AS/400 needs data from the SQL database? B – What format does that application need the data in? C – Does the SQL server run on a website? D – Are you familiar with ‘scripting’ (PERL, PHP, Python, REX, …)? E – And while I am asking, are they on the same network?
How much data latency can you afford ? If it can be handled in a batch environment then you could just use MS-DTS (which is free with SQL Server) to extract the data to the AS/400. Just needs an ODBC driver (e.g. IBM’s Client Access). Could schedule a DTS job to run every minute (depending upon data volumes)
and have it maintain a mirror of the MS-SQL data in the AS/400 environment. Quick, cheap, simple!
Gary Nuttall