How to integrate DB2 for iSeries (AS/400) in Azure Synapse Analytics (formerly SQL Data Warehouse)

Discover how to integrate DB2 for iSeries (AS/400) and Azure Synapse Analytics (formerly SQL Data Warehouse) and instantly get access to your data.

Replicate DB2 for iSeries (AS/400) data into Azure Synapse Analytics (formerly SQL Data Warehouse) and analyze it with your BI Tool.
How to integrate DB2 for iSeries (AS/400) in Azure Synapse Analytics (formerly SQL Data Warehouse) 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 Azure Synapse Analytics (formerly SQL Data Warehouse)

Microsoft Azure is a leading cloud computing infrastructure and platform created by Microsoft for building, managing, and deploying services and applications through Microsoft-managed global data centers. Azure Synapse is an analytics service bringing together enterprise data warehousing and Big Data analytics. Synapse offers a unified experience to ingest, prepare, manage and serve data for immediate BI and machine learning needs.

What is Data Virtuality Pipes?

Data Virtuality Pipes is an easy to use data integration tool. It allows to connect with DB2 for iSeries (AS/400), Azure Synapse Analytics (formerly SQL Data Warehouse) and more than 200 other cloud services and databases. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of Data Virtuality Pipes no longer have to worry about API changes. All connectors and data pipelines are fully maintained by us.



Choose your data sources: Google Analytics, Salesforce, Facebook, Amazon MWS and more



Move your data into a target storage: Amazon Redshift, PostgreSQL, Google BigQuery, Snowflake and more



Analyze your combined data using the Business Intelligence tools of your choice: Looker, Tableau, Excel and more


All connector bundles charged annually

2 Week Trial
unlimited connectors


Try Pipes at no cost. Full functionality. No strings attached.

Starter Bundle
Choose 1 connector


/ month

Medium Bundle
Choose up to 3 connectors


/ month

Large Bundle
Choose up to 5 connectors


/ month

most popular option

Request more than 5 connectors