posts - 88 , comments - 3 , trackbacks - 0

salesforce

Publish Reports with Salesforce Data in Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce data.Crystal Reports provides built-in support for the JDBC standard. The CData JDBC Driver for Salesforce enables you to use the Report Wizard and other tools to access Salesforce data in Crystal Reports. This article shows how to create a simple report that features Salesforce data.Connect To Salesforce DataFollow the procedure below to use the Report Wizard to create the Salesforce connection.If you have not already done so, ......

Posted On Tuesday, July 7, 2015 3:36 AM | Filed Under [ salesforce cdata jdbc reports Crystal Reports ]

Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.You can use the TDS Remoting feature to set up a linked server for Salesforce data. After you have started the daemon, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with Salesforce data just as you would a a linked SQL Server instance.Configure the DSNIf you have not already done so, specify connection properties in a DSN (data ......

Posted On Tuesday, June 30, 2015 2:15 AM | Comments (0) | Filed Under [ salesforce cdata ODBC Linked Server ]

Lightning Connect to NetSuite External Objects
Salesforce Lightning Connect enables Salesforce users to connect to data from OData sources from Salesforce in the same way that users interact with standard Salesforce objects. Through Lightning Connect, Salesforce customers can build real-time analysis from within their Salesforce dashboard and other Salesforce1 apps. In this article we are going to show you how you can enable bi-directional connectivity between NetSuite CRM and ERP data from Salesforce using the Cloud Drivers from CData Software ......

Posted On Wednesday, June 17, 2015 1:16 AM | Filed Under [ salesforce odata cdata cloud drivers Lightning Connect ]

Use Crystal Reports to create reports with Salesforce data
Crystal Reports provides built-in support for the JDBC standard. The CData JDBC Driver for Salesforce enables you to use the Report Wizard and other tools to access Salesforce data in Crystal Reports. This article shows how to create a simple report that features Salesforce data.Install the JDBC DriverInstall the CData JDBC Driver for Salesforce by including the driver JAR in the Crystal Reports classpath: Set the DataDriverCommon element in the CRConfig.xml file to the path to the JAR.The CRConfig.xml ......

Posted On Tuesday, June 16, 2015 2:09 AM | Filed Under [ salesforce cdata data reports Crystal Reports ]

Lightning Connect to SQLite External Objects
Use the CData Cloud Driver for SQLite to securely provide OData feeds of SQLite data to smart devices and cloud-based applications. Use the cloud driver with Salesforce Lightning Connect to create SQLite objects that you can access from apps and the dashboard.The CData Cloud Driver for SQLite enables you to access SQLite data from cloud-based applications like the Salesforce console and mobile applications like the Salesforce1 Mobile App. In this article, you will use the cloud driver and Salesforce ......

Posted On Friday, June 12, 2015 6:47 AM | Comments (0) | Filed Under [ salesforce odata cdata SQLite Cloud Driver ]

Tutorial: Access Salesforce Leads in SharePoint through an External List
You can use the CData Cloud Driver for Salesforce to give your users the capabilities to access and update Salesforce data in SharePoint. This article shows how to create an external list of Salesforce data that is always up to date. You will use an external content type as a template for the external list. The external content type enables connectivity over Web services, the protocol that cloud driver uses to provide access to live Salesforce data.Note that this tutorial applies to any of our data ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (0) | Filed Under [ salesforce .net sharepoint cdata ]

Import Salesforce Data into Google Spreadsheets
The Salesforce Cloud Driver enables applications to connect to Salesforce data via Web services. In Google Spreadsheets, you can consume Web services in the CSV format by calling the ImportData function. You can follow the three steps below to use the ImportData function to consume Salesforce data in Google Spreadsheets.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.Authenticate your ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (1) | Filed Under [ salesforce odata google google docs integration cdata ]

Using the CData Data Providers with the DevExpress Data Grid
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. You can use the DevExpress controls with any of the CData providers to visualize data from a wide variety of sources.In this article, you will use the Salesforce provider to databind to the DevExpress Windows Forms and Web controls. The standard ADO.NET process for databinding can be followed to enable bidirectional access to live data from UI controls. This article shows how ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (0) | Filed Under [ devexpress salesforce ado.net .net ]

Using CData JDBC Drivers in ColdFusion
The CData JDBC Drivers can be used in any environment that supports loading a JDBC Driver. In this tutorial we will explore using the CData Salesforce JDBC Driver from within ColdFusion.To begin, this tutorial will assume that you have already installed the CData Salesforce JDBC Driver as well as Adobe ColdFusion v10, and that you already have a Salesforce account and access token (See our forum for more details about getting an access token).Add the CData JDBC Driver to ColdFusion's lib directory.Copy ......

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

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 ]

Call Stored Procedures from Script Components
The source task and the destination task are the easiest ways to transfer data in SSIS. You can use source and script components to output data to the data flow.This article shows how to create a script component that functions as a source in the data flow: It passes data returned from Salesforce to downstream components. You will execute the CreateJob and CreateBatch stored procedures available in the Salesforce SSIS Component.Stored procedures can be used to search, update, and modify data. Stored ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ salesforce ado.net cdata ssis ]

Databind Wijmo Grid to Salesforce.com Data
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... ......

Posted On Thursday, September 27, 2012 3:38 AM | Comments (0) | Filed Under [ salesforce cdata databind Wijmo Grid cloud drivers ]

Access Salesforce Data as OData Feeds in Tableau
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 ......

Posted On Wednesday, September 26, 2012 5:32 AM | Comments (0) | Filed Under [ salesforce odata cdata tableau ]

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 ]

Using Object-relational mapping (ORM) with Salesforce Entities
Object-relational mapping (ORM) technique can bridge your logical business model with your physical storage model.Hibernate is a popular object-relational mapping library for Java, providing a framework for mapping object-oriented domain models to a traditional relational database.Note: Please see the article Using LINQ with QuickBooks to see the ORM approach using Microsoft .NET.The CData Salesforce JDBC Driver supports full integration with Hibernate.In this tutorial, we will generate an object-relational ......

Posted On Friday, April 27, 2012 6:11 AM | Comments (0) | Filed Under [ salesforce cdata ORM ]

Connect SalesForce to SQL Server through SSIS
Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more easily connect that data with features like reporting, full-text search, analytics, and more.This example demonstrates how to use the Salesforce ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from Salesforce and/or Salesforce Online into a Microsoft SQL Server database. The exact same ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ salesforce cdata ssis sql ]

Databind Charts to Salesforce Data
Databinding enables bidirectional access to data from UI controls. You can use the CData ADO.NET Provider for Salesforce to easily databind Salesforce data to Windows Forms and Web controls in Visual Studio. This article shows how to use wizards to databind Salesforce data to a chart that reflects any changes. The code walk-through section shows how to create the same chart in 10 lines of code.Databind to a ChartDatabinding consists of three steps: Instantiate the control, configure the data source, ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ salesforce .net cdata databind chart ]

Powered by: