There is an increasing number of DB2 on iSeries projects that require enterprise DataDirect ODBC, JDBC, ADO.NET connectivity. From consulting on these projects, I hear great feedback on all the things we're doing right for DB2 on iSeries data access, and it's interesting to hear that core business systems -ERP, MRP, BCPS, etc- continue to run on this platform for decades across a wide range of industries.
Note: You may see DB2 on iSeries referenced as "IBM DB2 for I", "DB2 UDB for iSeries", "DB2/400" or "DB2 on AS/400".
Progress DataDirect is focused on building high performance and feature rich data connectivity to DB2 on iSeries (as well as DB2 on LUW and z/OS). This is achieved through our wire protocol technology across ODBC, JDBC, ADO.NET (including Entity Framework) applications that run across all technologies and platforms. And absolutely NO database client libraries are required (read first hand how SPARDAT simplified their DB2 client architecture).
From recent projects, we have proven this architecture is superior for production loads in demanding business critical applications running on the latest physical and virtual systems across public and private clouds.
In addition to improved performance with each release, the latest Connect for ODBC 7.0, JDBC 5.0 and ADO.NET 4.0 drivers include support for V7R1. Each driver supports multiple versions of DB2/400 including V5R3, V5R4, V6R1 and V7R1.
The Connect for ODBC DB2 for iSeries driver supports the latest 32-bit and 64-bit HP-UX PA-RISC, HP-UX Itanium, SUSE Linux, Redhat Linux, Solaris SPARC, Solaris x86, AIX and Windows platforms.
The Connect for JDBC DB2 for iSeries driver supports J2SE 5, Java SE 6 and Java 7 (32-bit and 64-bit).
The Connect for ADO.NET DB2 for iSeries driver supports .NET Framework Versions 2.0 SP1 or higher, 3.0 SP1, 4.0, and 4.0 SP1.
And the range of platform support is backed by the largest data connectivity verification suite in the world that run over 80 million tests and growing.
For DB2 on iSeries Entity Framework support, Microsoft has been getting a lot of requests for use with LightSwitch and we delivered the solution. And Alex Woodie from Four Hundred Stuff recently wrote an article about our DB2/400 support with LightSwitch.
We also certify our Connect for JDBC DB2 on iSeries drivers with Hibernate.
In summary, you can read about all the advanced DB2 on iSeries data connectivity features built into the drivers.
DataDirect R&D and QA have decades of cumulative experience developing and testing connectivity to DB2 on iSeries including Ed Steward, Senior Software Engineer, who has 10+ years experience dating back to V5R1. And I have found iSeries experience in other corners on the 4th floor of the DataDirect office in Morrisville, NC. Bruce Rudd, DataDirect SupportLink Manager, started his career at a blue chip manufacturer developing COBOL applications on AS/400, and then developed a web application to route accounting software for delivery trucks. And Hugh Raiford, Vice President of Sales DataDirect Americas once lead product management and marketing efforts at ClientSoft which was a leader in AS/400 integration prior to be being acquired by NEON Systems and later acquired by Progress Software.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.