CData Software - Knowledge Base



Recent Articles


  • Using CData JDBC Drivers from NetBeans

    CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to develop with CData JDBC Drivers using the NetBeans Java IDE.

  • Databind Charts to Salesforce Data

    Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

  • Demo: Migrate Data from Salesforce to SharePoint

    CData Data Providers offer a wide range of uses, including the ability to migrate data between sources quickly. Download this demo that helps you transfer Salesforce.com data into SharePoint.

  • Setting Up Pseudo Columns with LightSwitch.

    Pseudo columns behave like normal columns and are used to refine data by passing them through Where clauses. This tutorial will show you how to expose pseudo columns such as MaxResults.

  • Using Cookie-Based Authentication with the CData SharePoint Data Provider.

    The SharePoint Data Provider offers connectivity with an on-premise SharePoint Server as well as SharePoint Online and Office 365. This walk-through demonstrates how to properly authenticate and connect to SharePoint Online / Office 365.

  • Export Data from SQL Server to Salesforce Through SSIS

    Easily push SQL Server data to Salesforce using the CData SSIS Tasks for Salesforce. This example uses an SSIS workflow to populate Salesforce with data from a SQL Server database using the CData SSIS Tasks for Salesforce.

  • Import Salesforce Data into SQL Server using SSIS

    Easily back up Salesforce data to SQL Server using the CData SSIS components for Salesforce.

  • Faster Reporting using the QuickBooks Provider

    The CData ADO.NET Provider for QuickBooks features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.

  • Faster Reporting using the CData Provider for Salesforce

    The CData ADO.NET Provider for Salesforce features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.

  • Connect Salesforce to SQL Server through SSIS

    Easily back-up Salesforce data to SQL Server using the CData ADO.NET Provider for Salesforce. This example uses an SSIS workflow to populate a database with Salesforce data using the CData ADO.NET Data Provider for Salesforce.

  • Connect SharePoint to SQL Server through SSIS

    Easily back-up SharePoint data to SQL Server using the SharePoint Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider.

  • Connect QuickBooks to SQL Server through SSIS

    Easily back up QuickBooks data to SQL Server using the QuickBooks Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with QuickBooks data using the QuickBooks ADO.NET Data Provider.

  • LINQ to QuickBooks

    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 Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.

  • Query Google Calendars, Contacts, and Documents from PowerShell

    Are you looking for a quick and easy way to access Google Drive and other Google Apps from PowerShell? The CData Google Apps Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of from your PowerShell scripts. The provider simplifies authentication and interaction with Google Apps. Simply use the included .NET objects in your PowerShell scripts to connect to your Google Apps accounts and synchronize, automate, download, and more!

  • Accessing Website Data Using ADO.NET

    An article from iProgrammer explores accessing Web data through the CData Data Providers: Interacting with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API. Now there is a better way...

  • OLAP Reporting Directly from QuickBooks using ComponentOne OLAP for WinForms

    Rich Dudley from ComponentOne explores using the CData QuickBooks Data Provider and ComponentOne OLAP to build a powerful QuickBooks reporting application, all without writing a single line of code.

  • Excel Files as Data Sources Using CData ADO.NET Providers

    Bjoern Meyer from Text Control explores using the CData Data Providers with TX Text Control Words, the Text Control Reporting template designer.

  • Hooking into Google Apps With CData Google Data Provider

    Mike Gold reviews the CData Google Data Provider on C# Corner: This is a review of a component called the CData Google Data Provider which allows you to access the Google API through a SQL-like Data Provider interface. This provider opens up the entire Google Application Suite to the .NET developer through familiar ADO.NET tools and classes.