posts - 88 , comments - 2 , trackbacks - 0

November 2012 Entries

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 ]

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 Source or the SSIS Destination model.This article shows how to use the DownloadDocument stored procedure included in the CData SSIS Components for SharePoint to download files from SharePoint. The CData SSIS Components surface additional functionality available in the underlying API as stored procedures. While this article ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ sharepoint cdata ssis sql ]

Build an MVC Application with Connectivity to QuickBooks
This article shows how to use wizards in Visual Studio to create a simple MVC (model, view, controller) project and execute CRUD (create, read, update, and delete) commands to QuickBooks using the Entity Framework methods.Establish a ConnectionBefore getting started, you will need to establish a connection to QuickBooks.To connect to QuickBooks Desktop, use the Remote Connector application included with the installation. The Remote Connector is a lightweight, stand-alone server that enables you to ......

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

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 LINQPad to connect to QuickBooks using the CData ADO.NET Provider for QuickBooks. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.Create the Data ModelIn a new console project in Visual Studio, create a data model using the ADO.NET Entity Data Model wizard.Select an existing connection or click New Connection to ......

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

Sync Google Calendar with SharePoint Calendar
The CData Data Providers make it easy to build applications that need to move data from one source to another. The simple, uniform SQL syntax makes it easy to retrieve and update data in Google and SharePoint.This article shows how to use the demo Windows application to sync Google and SharePoint calendars.Connect to Google and SharePointTo connect to Google, specify the User and Password connection properties. Alternatively, you can use OAuth.To connect to SharePoint On-Premise, specify the User ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ sharepoint google cdata calendar ]

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 included, fully functional application that can be used to synchronize contacts between Google and desktop editions of QuickBooks. The application can easily be modified to synchronize contacts with QuickBooks Online and QuickBooks POS.Connecting to QuickBooks and GoogleTo connect to Google, specify the User and Password connection properties. The provider also supports the OAuth ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ quickbooks cdata contacts QuickBooksPOS QuickBooksOnline ]

Access Salesforce From Excel Macros (VBA)
The CData Salesforce Excel Add-In makes it easy to retrieve and update data from Salesforce from within Microsoft Excel. In addition to using the CData ribbon, you can use Excel Macros (VBA) and Excel Functions to access the full functionality of the CData Excel Add-Ins.In addition to create, read, update, and delete operations, the add-in also includes stored procedures that expose other capabilities supported by the Salesforce API. This article shows how to write an Excel macro that can be used ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) |

Powered by: