posts - 88 , comments - 3 , trackbacks - 0

ssis

Connect SharePoint 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 SharePoint ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from SharePoint and/or SharePoint Online into a Microsoft SQL Server database. The exact same ......

Posted On Tuesday, June 16, 2015 4:10 AM | Filed Under [ ado.net sharepoint cdata ssis SQL server ]

Design a Custom SAP Function Module to Circumvent RFC_READ_TABLE Limitations

While the SAP SDK provides the RFC_READ_TABLE for accessing data from SAP tables, using it to select data is limited to 512 bytes at a time so you may not be able to retrieve all columns. You can resolve this limitation by defining a custom function module that will allow you to select any result set you need.

Posted On Monday, June 15, 2015 2:01 AM | Filed Under [ cdata jdbc ODBC ssis SAP netweaver ]

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 ]

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 ]

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: