posts - 88 , comments - 3 , trackbacks - 0

sql

Using SQL to Query Gmail
The Gmail Data Provider makes it easy to search email from a Gmail account. Instead of learning the details of the IMAP search command, you can simply use the simple SQL syntax. However, the full IMAP search specification is supported. You can also search based on multiple criteria at the same time. This article will demonstrate how to use SQL to execute simple and advanced IMAP searches. Message FieldsFor simple searches, such as searching for all emails from a particular person, you can use message ......

Posted On Thursday, December 20, 2012 1:56 AM | Comments (0) | Filed Under [ ado.net google cdata jdbc gmail data ssis excel add-in sql ]

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 ]

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 ]

Powered by: