How to download data from AS 400

What is the best method to download data from AS400?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr. KlahnPrincipal Software EngineerCommented:
Over a standard TCP/IP network?  FTP.
Pawan KumarDatabase ExpertCommented:
You can use SSIS to fetch data from AS400 to MS SQL Server.
AS 400 offers ODBC and OLE DB drivers so you can access it from almost anywhere by any programming language which supports ODBC or OLE DB access, e.g. C#, FoxPro, VB etc.

Many drivers exist, you may look e.g. here:

Microfocus also delivers drivers

Of course, you should preferably ask your AS400 support for more info.

Connections strings are described here:
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Scott PletcherSenior DBACommented:
We use a linked server.  Create a linked server(s) pointing to the AS400 you want to access.  Naturally you'll need an id on the AS400 that has access to what you want to read / write.

Then you use it in SQL just as you would any other linked server.
Gary PattersonVP Technology / Senior Consultant Commented:
One time, or a repeated automated process?
IBM AS/400 DB2 data (tables/physical files), or flat files from the AS/400 IFS?
What format do you need the data in?
Gary PattersonVP Technology / Senior Consultant Commented:
FTP is a good solution for IFS files, but generally a bad solution for database data.

For database data:

ODBC/JDBC/OLEDB/ADO.NET connectors are all available for IBM i (iSeries, AS/400) DB2, so any tool you like that supports these protocols can be used, like SQL Server Linked Server or SSIS.

Most shops use IBM i Access for Windows emulator, which includes an easy interactive Data Transfer Function for uploading and downloading data to/from IBM i DB2 (easiest way to do "one time" or occasional transfers).  DTF supports a lot of different target formats, like Excel, CSV, and more.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Shalom CarmelCTOCommented:
How to download data from AS 400?

As you can see for yourself, there is a large number of tools, protocols and techniques available. Some were not mentioned (like ssh/sftp). The key parameters are:
* Is it a one time download?
* What size is the download?
* What is the data?
* Does it need conversion?
* How secure does it have to be?
* What platform is doing the downloading?
zachvaldezAuthor Commented:
This suggestion will help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.