Learn more
 

CData Software - Knowledge Base

Recent Articles

  • Transfer data from Excel to QuickBooks using the CData Excel Add-In

    This article explains how to transfer data from Excel to QuickBooks using the CData Excel Add-In for QuickBooks. For this example, we will use the Customers table;however, the same process will work for any table that can be retrieved by the Excel Add-In.

  • How to Execute Stored Procedures with the CData BizTalk Adapter for Salesforce

    You can use stored procedures provided by the CData BizTalk Adapter for Salesforce to automate working with Salesforce data in BizTalk. Stored procedures implement actions available in the underlying API.

  • Configure a One-Way Send Port for the CData BizTalk Adapter for Salesforce

    Use the CData BizTalk Adapter for Salesforce with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.

  • Configuring a Receive Location for the CData BizTalk Adapters

    This article will show how to configure a Receive Location using the CData BizTalk Adapters to pull data from a data source. The steps included discuss creating the receive location, setting up the connection string, configuring the location to pull data daily, and writing it to an XML file.

  • Configure a Solicit-Response Send Port for the CData BizTalk Adapter for Salesforce

    Use the CData BizTalk Adapter for Salesforce with a solicit-response send port to execute updategrams and data manipulation SQL in BizTalk.

  • Using the CData JDBC drivers with the Pentaho Report Designer

    The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce in Pentaho (a BI tool) to publish reports based on Salesforce data. A similar approach can be used with any other CData JDBC Driver.

  • Use Crystal Reports to create reports with Salesforce data

    The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.

  • Generating an Entity Data Model in Visual Studio Express

    The Entity Data Model Wizard can be used to easily generate an Entity Data Model in Visual Studio. However this feature is not available in Visual Studio Express. In this article you will use the edmgen utility available with .NET Framework 4.0 to generate the Entity Data Model.

  • Using Mail Merge with Salesforce, SharePoint, or Google Contacts

    The CData ODBC Drivers can be used from tools like Mail Merge in Microsoft Word to access live data from various sources (QuickBooks, Salesforce, SharePoint etc.). This article uses the CData ODBC Driver for Salesforce with Mail Merge, but this procedure can be follwoed for other CData ODBC drivers.

  • Bill an Invoice with the CData Excel Add-In for QuickBooks

    The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.

  • Analyze Salesforce Data with PowerPivot

    This article walks you through the process of using the CData ODBC Driver for Salesforce from PowerPivot. The technique described in this article can be used with any CData ODBC Driver.

  • Update Multiple Invoices using the CData Excel Add-In for QuickBooks

    The CData Excel Add-In for QuickBooks makes it easy to modify your QuickBooks data right in Excel. This article will explain how to use the CData Excel Add-In for QuickBooks to mark multiple Invoices at once for printing and e-mailing.

  • Using CData JDBC Drivers in ColdFusion

    This article will demonstrate how to use the CData JDBC Drivers with ColdFusion. Included are steps for adding the CData JDBC Driver as a data source, as well as basic ColdFusion code to query the data source and display results.

  • 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.

  • 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.