It's all cloud could and cloud now-a-days. Everyone are moving towards the cloud for making life easier.
In this post I will be explaining on how to extract/Import data from SharePoint Lists which is hosted on SharePoint Online of Office 365 using SSIS.
There is no direct way to connect to the SharePoint Online using SSIS.
For connecting to SharePoint Online using SSIS, we need the below components installed before stating.
In this post I will be explaining on how to extract/Import data from SharePoint Lists which is hosted on SharePoint Online of Office 365 using SSIS.
There is no direct way to connect to the SharePoint Online using SSIS.
For connecting to SharePoint Online using SSIS, we need the below components installed before stating.
- Microsoft OData Source for Microsoft SQL Server 2012
Download from http://www.microsoft.com/en-in/download/details.aspx?id=42280 - SharePoint Server 2013 Client Components SDK
Download from http://www.microsoft.com/en-in/download/details.aspx?id=35585
Once you download and Install both the components,
- Open the Visual Studio and create a new Integration Services Package
- Drag and Drop "Data Flow Task"
- In the "Data Flow Task" Drag and Drop "OData Source"
- Right-Click on "OData Source" and Click Edit
- Enter the "Connection Manager Name" and "Service Document Location" For Service Document Location, append "/_vti_bin/listdata.svc" to the SharePoint site
For Office 365, we need to use "User this user name and password" - Click "All" and change the "Microsoft Online Services Authentication" to True
- Click "Test Connection"
- Click "OK"
- Then Choose "Collection" in "User Collection or resource path"
- In the "Collection" choose the list you want to import
- When you click on "Preview..." you will be able to see the data from the list
- Now add the destination connection and run the package to import data from the SharePoint Online list
17 comments:
This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic
JAVA Training in chennai
Thanks for Sharing.
There's another ref yet few months older but solid info
http://whitepages.unlimitedviz.com/2014/03/using-the-odata-source-connector-with-sharepoint-online-authentication/
I have read your blog its very attractive and impressive. I like it your blog.
.Net Online Training | .Net Online Training India
Dot Net Online Training | ASP.NET Online Training
Good one, very informative.. thanks for sharing your views and ideas.. it is very useful to me.. thanks once again..
Java Training in chennai | Software Testing Training in chennai
Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Madurai Travels ! Best Travels in Madurai | Tours and Travels in Madurai
hi, nice information is given in this blog. Thanks for sharing this type of information, it is so useful for me. nice work keep it up. digital marketing company in delhi
Thank you for sharing this post Website Development Company in Rohini
Epoxy Grout manufacturer in delhi
animal feed bags supplier
Laminated Doors manufacturer in hubli
nice topic which you have choose.
second is, the information which you have provided is better then other blog.
so nice work keep it up. And thanks for sharing. led lawn lights in delhi
we have provide the best ppc service in Gurgaon.
ppc company in gurgaon
website designing company in Gurgaon
fridge repair in faridabad
Bosch Fridge Repair in Faridabad
Godrej Fridge Repair in Faridabad
Haier Fridge Repair in Faridabad
Panasonic Fridge Repair in Faridabad
Bali Honeymoon Packages From Delhi
Bali Honeymoon Packages From Chennai
شركة كشف تسربات المياه بالخبر
best website designing company in Delhi
Great Article Artificial Intelligence Projects
Project Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Post a Comment