Enable everyone in your organization to access their data in the cloud — no code required.
Learn More →CData Software - Knowledge Base
Recent Excel Articles
Explore Geographical Relationships in GraphQL with Power Map
Create data visualizations with GraphQL in Power Map.
Author and Share Power BI Reports on Real-Time Authorize.Net
Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop and then upload to the Power BI service.
Explore Geographical Relationships in ServiceNow with Power Map
Create data visualizations with ServiceNow in Power Map.
Use the CData ODBC Driver for ServiceNow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ServiceNow in Excel.
Use the CData ODBC Driver for ServiceNow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ServiceNow in Excel.
Work with DB2 in MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData Software ODBC Driver for DB2 and work with IBM DB2 in Microsoft Excel on Mac OS X.
Use the CData ODBC Driver for Dynamics GP in Microsoft Power Query
You can use the CData Dynamics GP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Dynamics GP into Microsoft Power Query.
Import Excel Online into the Power BI Service for Visualizations
Use the CData Software Cloud Hub to create an OData feed for Excel Online and create custom reports in the Power BI Service.
LINQ to Excel Services
LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData ADO.NET Data Providers. This example uses LINQ to access information from the Excel Services Data Provider.
Import and Visualize Azure Data Catalog in Power View
Create data visualizations based on Azure Data Catalog in Excel.
Create Dynamic Excel Grids Using the Infragistics XamDataGrid
Use the CData ADO.NET Provider for Excel and the Infragistics XamDataGrid to build dynamic grids.
Use the CData ODBC Driver for Excel Online in Microsoft Power Query
You can use the CData Excel Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Excel Online into Microsoft Power Query.