September 2012 Entries
The Salesforce Cloud Driver provides Salesforce data as Web services, which enable connectivity to the live data. This article shows how to consume JSONP-formatted Salesforce data from a Wijmo Grid.If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.Load the required Wijmo, jQuery, and Knockout libraries:http://code.jquer... ......
This article will explain how to use the Salesforce Cloud Driver to provide the underlying connectivity to Salesforce data in Tableau's business intelligence tool.If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.In Tableau, select 'Connect to data'. In the 'On a server' section, click OData.In the resulting wizard, enter the OData URL of the cloud driver's endpoint. Append the name of ......
Use the CData SQLite Cloud Driver to connect to live SQLite data in the PowerPivot business intelligence tool.This article will explain how to use the cloud driver to provide SQLite data as OData services and then consume the data in Microsoft Excel's PowerPivot business intelligence tool. Follow the steps below to retrieve and edit SQLite data in Power Pivot. While the example will use the Salesforce Connector, the same process can be followed for any of the CData Cloud Drivers.If you have not already ......
The ADO.NET Provider for QuickBooks enables you to request almost any report available in QuickBooks Desktop and QuickBooks Online. The ADO.NET Provider for QuickBooks enables you to access reports as views, or read-only tables. This article shows how to customize the included reports and create new reports.Many QuickBooks Desktop reports are already included as views. However, you may want to extend a report view. For example, if you do not see a column you need in one of the included reports, you ......
The CData ADO.NET Provider for Salesforce enables you to use the Windows Communication Foundation (WCF) framework to rapidly develop service-oriented applications that provide Salesforce data to OData consumers. This article shows how to create an entity data model to provide the underlying connectivity to Salesforce, as well as how to create a WCF Data Service to expose the OData service. You can then consume the feed with any OData client, for example, Power Pivot or an application that uses the ......
The CData ADO.NET Data Providers enable you to visualize and manipulate information from disparate data sources in LightSwitch applications. This entry demonstrates how to execute stored procedures in LightSwitch. This article uses the CData Email Data Provider, but the same process will work with any CData ADO.NET Data Provider.Create the RIA ServiceOpen Visual Studio 2010 and create a new WCF Service Library Project.Add a new Domain Service Class to the .Web project.In the new Domain Service Class, ......