Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Visualize your Salesforce Data in Tibco Spotfire
Connect to Salesforce as an ADO.NET data source and create a simple dashboard in TIBCO Spotfire.
-
Transfer Google Calendars to SharePoint in Talend
Access SharePoint data in Talend using the CData JDBC Driver for SharePoint.
-
Create Data Visualizations in Cognos BI with Salesforce Data
This article describes how to use the CData ODBC Driver for Salesforce in Cognos BI.
-
Use CloverDX (formerly CloverETL) and CData JDBC Drivers to Transfer Data
The CData JDBC Drivers work with all tools that support JDBC. This allows for rapid data integration with a tool of your choice. This article shows how CData drivers can be used from CloverDX, a data integration tool, to transfer data between two data stores.
-
Query Salesforce from Node.js
Execute CRUD queries to live Salesforce data in Node.js.
-
Import Google Spreadsheets data into FileMaker Pro
You can use the CData ODBC Driver for Google Spreadsheets to access Google Spreadsheets in FileMaker Pro as a live data source.
-
Accessing QuickBooks with Entity Framework 6
CData ADO.NET Providers make it easy to access data from a variety of sources. In this article we show how to access data from QuickBooks using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the CData JDBC Driver for QuickBooks in KNIME
Access QuickBooks data and other data sources in KNIME using the JDBC Driver. You can follow the procedure detailed below to enable any CData JDBC driver in KNIME.
-
Analyze Data in MicroStrategy Using the CData ODBC Driver for Dynamics CRM
In this article we show the use of CData ODBC Drivers with the MicroStrategy BI platform.
-
Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. This article shows how to use the CData ADO.NET Provider for Salesforce with the DevExpress Chart Control.
-
Access Salesforce Data in QlikView Using the CData ODBC Driver for Salesforce
The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. For example, you can use the ODBC drivers to create visualizations that organize and present your Salesforce data in QlikView. In this article we outline simple steps to use CData ODBC Drivers from QlikView.
-
Using CData ODBC drivers from SharePoint Excel Services
This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.
-
Connect to Dynamics NAV with the CData OData Provider
This article uses the CData ADO.NET OData provider to retrieve data from Dynamics NAV. The process described will also work for other CData OData providers (JDBC, ODBC, SSIS, etc.).
-
Access SAP Tables and SAP Queries using CData SAP Providers
In this article we explain how our SAP products obtain table information and provide a free helper utility to add additional table schemas to our SAP Providers.
-
Using Microsoft Query in Excel to Connect to Salesforce
This article uses the CData ODBC driver for Salesforce to execute SQL with Microsoft Query in Excel. It will also demonstrate using parameters.
-
Install a Microsoft Excel Add-In Manually
Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.
-
Import Salesforce Data into Google Spreadsheets
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.
-
Import Salesforce Data into Microsoft Power Query
The CData API Server offers standards-based web service endpoints that allow a variety of applications to get data from Salesforce. These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into Microsoft Power Query.
-
Update a Google Calendar with a Microsoft Access Linked Table
This article explains how to update Google Calendar events by creating a linked table in Microsoft Access with the CData ODBC Driver for Google Apps.
-
Excel Spreadsheet Automation with the CDATAQUERY Formula
The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.