Accessing SQL Server data-2

Tags:
SQL Server
I need to access data on an SQL server from our AS/400. I need something quick and cheap. Help!

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EXPERTJohnBrandt
    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.
    2,520 pointsBadges:
    report
  • Howard2nd
    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?
    30 pointsBadges:
    report
  • GPN01T
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following