CData Software - Knowledge Base



Recent Articles


  • Using IMAP with the Gmail Data Provider

    The CData Gmail Data Providers provide access to the full search capabilities of IMAP through a simple SQL interface. This article will demonstrate how to use the Gmail demo to query your Gmail account.

  • Using SQL to Query Gmail

    The CData Gmail Data Providers provide access to the full search capabilities of IMAP using standard SQL. This article will explore some examples to demonstrate the ease of creating powerful custom queries to search your Gmail account.

  • Download files from a SharePoint site using the CData SSIS Components

    The CData SSIS data flow components allow you to easily import and export data from various data sources. However in some cases the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS data flow.

  • Insert Invoices with the Excel Add-In for QuickBooks

    The CData Excel Add-In for QuickBooks can be used to easily retrieve and insert QuickBooks data. In this article, you will insert an Invoice into QuickBooks.

  • Transfer Company File Data using the CData Excel Add-In

    This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.

  • Working with QuickBooks using LINQPad

    The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use the CData ADO.NET Provider for QuickBooks to connect to QuickBooks in LINQPad. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.

  • Build an MVC Application with Connectivity to QuickBooks

    CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.

  • Sync Google Contacts with QuickBooks

    The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.

  • Databind Wijmo Grid to Salesforce.com Data

    Use the CData API Server to add a Wijmo grid containing live Salesforce.com data to your website. The same process to access live data can be followed with any of the 80+ other supported sources.

  • Create OData Services with the Salesforce Data Provider

    This article shows how to publish an OData feed of Saleforce data by creating a WCF Service Application. This article uses the ADO.NET Provider for Salesforce, but the same steps will work for any of the CData ADO.NET Providers.

  • Extending QuickBooks Desktop Reporting

    The CData ADO.NET Provider for QuickBooks Desktop make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Profit and Loss Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.

  • Extending QuickBooks Online Reporting

    The CData Data Providers for QuickBooks Online make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Item Profitability Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.

  • Access QuickBooks from Aqua Data Studio

    Connect to the CData JDBC Driver for QuickBooks through the Aqua Data Studio connection manager.

  • Use the CData JDBC Drivers to Create New Data Sources in DbVisualizer

    Connect to the CData JDBC Driver for QuickBooks through the DbVisualizer database management tool.

  • Access QuickBooks Company File Data from DBeaver

    Use the CData JDBC Driver for QuickBooks to access QuickBooks as a JDBC data source through the DBeaver connection manager.

  • Access QuickBooks from RazorSQL

    Connect to QuickBooks company file data through the RazorSQL database query tool.

  • Connect to QuickBooks Data from PowerBuilder

    This article demonstrates how to access QuickBooks data from PowerBuilder using the CData ADO.NET Provider for QuickBooks.

  • Securing the CData API Server

    This document shows how to secure connections from end-users to the API Server for your data source.

  • Minimum Requirements for CData API Server

    This page lists the minimum system requirements for using CData API Server.

  • Using CData JDBC Drivers from IntelliJ IDEA

    CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to use any CData JDBC Driver to create a JDBC data source in the IntelliJ Java IDE. You will then use the JDBC data source to execute queries in the Table Editor.