I am looking for AS/400 to AS/400 data warehouse solution. However, in my research, most companies seem to be going from the AS/400 to NT. Is this simply a cost issue? I like the stability of the AS/400 and would like to stick with it if possible. Are there many AS/400 - AS/400 solutions available?


Sid Adelman’s Answer: We are seeing quite a few NT data marts for departmental implementations. These choices are often for political reasons where department heads want to distance themselves from IT.

There are not as many AS/400 data warehouse tools and solutions as there are for NT, but there are plenty and, perhaps, as many as you will need. NT may or may not be more cost-effective. You have to look at the total cost of ownership including hardware, software, consultants, internal personnel costs, administration, etc. (most organizations fail to take all the attendant costs into consideration). You are right to consider stability, and be sure to also consider security capabilities and the architectural scalability of these two platforms for both the size of the data warehouse and for the number of users. Consider the efforts and expertise required as you grow – and you will surely grow if your data warehouse is successful.

IBM claims more than 15,000 BI implementations also with a large number of references. Ask them for these references and check out those references before you move to another platform. Ask about database size, number of users, availability and performance.

You can visit these Web sites for more information on AS/400 data warehouse solutions and partners:


Douglas Hackney’s Answer: The biggest challenges you’ll face on the AS/400 platform are lack of tools and price/performance vs. NT/SQL Server.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access