posts - 88 , comments - 3 , trackbacks - 0

PowerPivot

Analyze Salesforce data with PowerPivot
The ODBC protocol is used by a wide variety of Business Intelligence (BI) and reporting tools to get access to data from different databases. The CData ODBC Drivers bring the same power and ease of use to nontraditional data sources such as Salesforce, Microsoft CRM, QuickBooks, etc. This article uses the CData Salesforce Driver to import data into PowerPivot.Connect to SalesforceFollow the steps below to connect to Salesforce in PowerPivot.If you have not already, configure an ODBC data source name ......

Posted On Wednesday, February 13, 2013 9:40 AM | Comments (0) | Filed Under [ salesforce cdata ODBC PowerPivot ]

Use the Cloud Driver to Access SQLite Data in Microsoft PowerPivot
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 ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ salesforce odata cdata PowerPivot SQLite Microsoft ]

A Developers Guide to Creating OData Services with the Salesforce Data Provider
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 ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ salesforce odata cdata PowerPivot Excel ]

Powered by: