Enable everyone in your organization to access their data in the cloud — no code required.
Learn More →CData Software - Knowledge Base
Recent DB2 Excel Articles
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.
Transfer Data from Excel to DB2
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.
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.
Automated Continuous Excel Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Excel replication to IBM DB2.
Work with DB2 in MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for DB2 and work with IBM DB2 in Microsoft Excel on Mac OS X.
Use the CData ODBC Driver for DB2 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for DB2 to connect to IBM DB2 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM DB2 in Excel.