How to integrate DB2 for iSeries (AS/400) in MySQL

Discover how to integrate DB2 for iSeries (AS/400) and MySQL and instantly get access to your data.

WITH DATA VIRTUALITY PIPES
Replicate DB2 for iSeries (AS/400) data into MySQL and analyze it with your BI Tool.
How to integrate DB2 for iSeries (AS/400) in MySQL with Pipes


About DB2 for iSeries (AS/400)

IBM DB2 is a relational database management system for enterprise-wide solutions developed by IBM. A relational database is a database in which all of the data is logically contained in tables. These databases are organized according to the relational model. In a relational database like IBM DB2, referential integrity ensures data integrity by enforcing rules with referential constraints, check constraints, and triggers.

About MySQL

MySQL is a popular open-source RDBMS (relational database management system). It has become one of the leading database choices for large-scale websites including YouTube, Twitter, Facebook, and Yahoo. MySQL is offered under two different editions: the open source MySQL Community Server and the proprietary Enterprise Server. The MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins but is built from the same code base.  

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to DB2 for iSeries (AS/400), MySQL and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.