posts - 88 , comments - 3 , trackbacks - 0

sharepoint

How to Access Data from a SharePoint List Based on a Custom View
The CData ADO.NET Providers for SharePoint you to integrate live SharePoint data with other applications. For example, Visual Studio provides built-in support for ADO.NET data sources. This article shows how to use Server Explorer in Visual Studio to access the data screened by a SharePoint custom view.Implementing Access Control with a Database QueryThe CData ADO.NET provider's data model exposes each SharePoint list as a separate table; all custom views are available by querying the Views table. ......

Posted On Friday, June 26, 2015 3:21 AM | Comments (0) | Filed Under [ ado.net sharepoint cdata ]

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 ]

Access QuickBooks Online Data in SharePoint External Lists
Provide your QuickBooks Online data to SharePoint users as an external list.You can use the CData Cloud Driver for QuickBooks Online to give your users the capabilities to access and update QuickBooks Online data in SharePoint. This article shows how to create an external list of QuickBooks Online data that is always up to date. You will use an external content type as a template to create the external list. The external content type enables connectivity over Web services, the protocol that the cloud ......

Posted On Friday, June 12, 2015 7:03 AM | Comments (0) | Filed Under [ sharepoint cdata quickbooks online ]

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 ]

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 ]

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 ]

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 ]

Powered by: