CData Software - Knowledge Base

Recent DB2 Excel Articles

Use the CData ODBC Driver for DB2 from SharePoint Excel Services

How to update DB2 from Excel

This article explains how to transfer data from Excel to DB2 using the Excel Add-In for DB2.

Explore Geographical Relationships in DB2 with Power Map

Create data visualizations with IBM DB2 in Power Map.

Use the CData ODBC Driver for DB2 in Microsoft Power Query

You can use the CData DB2 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM DB2 into Microsoft Power Query.

Automated Continuous Excel Online Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Excel Online replication to IBM DB2.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Author and Share Power BI Reports on Real-Time DB2

Use the CData ODBC Driver for DB2 to visualize IBM DB2 in Power BI Desktop and then upload to the Power BI service.

CData Software is a leading provider of data access and connectivity solutions. Our standards-based connectors streamline data access and insulate customers from the complexities of integrating with on-premise or cloud databases, SaaS, APIs, NoSQL, and Big Data.

Connect With Us

Get Started

Data Connectors

ETL/ ELT Solutions

Cloud & API Connectivity

OEM & Custom Drivers

Connect With Us

Get Started

Data Visualization

Company

Resources

CData Software - Knowledge Base

Recent DB2 Excel Articles

How to connect to DB2 from MS Excel on Mac OS X

Automated Continuous SharePoint Excel Services Replication to IBM DB2

Import and Visualize DB2 in Power View

Automated Continuous Excel Replication to IBM DB2

Use the CData ODBC Driver for DB2 from SharePoint Excel Services

Use the CData ODBC Driver for DB2 from SharePoint Excel Services

How to update DB2 from Excel

Explore Geographical Relationships in DB2 with Power Map

Use the CData ODBC Driver for DB2 in Microsoft Power Query

Automated Continuous Excel Online Replication to IBM DB2

Excel Spreadsheet Automation with the QUERY Formula

Author and Share Power BI Reports on Real-Time DB2