posts - 88 , comments - 2 , trackbacks - 0

April 2012 Entries

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 QuickBooks 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 QuickBooks ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from desktop editions of QuickBooks into a Microsoft SQL Server database. The same procedure outlined ......

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

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 ]

Using Cookie-Based Authentication with the CData SharePoint Data Provider.
This article walks through the process of using the SharePoint Data Provider and authenticating with SharePoint Online / Office 365. This tutorial covers how to perform authentication programmatically and with the Visual Studio Server Explorer.In addition to accessing lists from local installations of SharePoint server, the SharePoint Data Provider also supports accessing lists from SharePoint Online. SharePoint Online and Office 365 authentication requires a cookie based authentication. To connect ......

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

LINQ to QuickBooks
This article demonstrates how to use LINQ to access tables in QuickBooks through the QuickBooks ADO.NET Data Provider. To do this you will LINQ to Entity Framework, which is used to generate the connection and can be used with any CData ADO.NET Data Providers to access data via LINQ.In a new project in Visual Studio, right-click on the project and choose to add a new item. Add an ADO.NET Entity Data Model.Choose to generate from database and click next.Add a new Data Connection, and change your data ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata Entity Framework LINQ ]

Connect to QuickBooks From LightSwitch Applications
The CData Data Providers for ADO.NET enable you to integrate disparate data sources into LightSwitch applications. In this demo, you will create a LightSwitch application that connects with QuickBooks Desktop and displays account data in an editable grid. Any changes will be immediately reflected in QuickBooks. The procedure outlined below can be used with any CData ADO.NET Data Providers.Connect to QuickBooksTo connect to Desktop editions of QuickBooks, use the included Remote Connector application ......

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

Hooking into Google Apps With CData Google Data Provider
By Mike Gold, November 30, 2010 This article was originally written and hosted on c-sharp cornerIntroductionThe world is full of information and there are all kinds of ways to access it. The Microsoft .NET framework provides several convenient ways to access data from different data sources, whether it's an XML file, a web stream, or a database. For databases, Microsoft offers several techniques for retrieving the data. One of the simplest forms is through an ADO.NET Data Provider. The Data Provider ......

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

Query Google Calendars, Contacts, and Documents from PowerShell
Are you looking for a quick and easy way to access Google Drive from PowerShell? The CData Google Apps Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of from PowerShell scripts. Simply use the included .NET objects in your PowerShell scripts to connect to Google Apps and synchronize, automate, download, and more!Connect to Google AppsTo connect to any CData ADO.NET Provider from Powershell, first load the provider assembly, located in the lib subfolder in the ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ google google docs cdata powershell ]

Accessing website data using ADO.NET
Accessing Website Data Using ADO.NETBy i-programmer, January 24, 2011 This article was originally written and hosted on i-programmerIntroductionInt... 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. CData has implemented a range of common APIs as ADO.NET data providers - Google, QuickBooks, Salesforce and ......

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

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 ]

OLAP Reporting Directly from QuickBooks using ComponentOne OLAP for WinForms
By Rich Dudley, ComponentOne, December 6, 2010 This article was originally written and hosted on the ComponentOne Community SiteThe CData QuickBooks Driver abstracts the QuickBooks API into a familiar, database-like programming model. After installation, the QuickBooks connector is added as an ADO.NET Data Source, and QB now operates as a database of sorts. We can query "tables" containing customer, sales orders, invoice data and more. Since the data connection is two-way, we can also update data ......

Posted On Thursday, April 26, 2012 3:11 AM | Comments (0) | Filed Under [ quickbooks cdata olap WinForms ]

Powered by: