Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export data from SQL server to SharePoint
Message
From
16/06/2017 10:01:18
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01652070
Message ID:
01652079
Views:
40
>>>Hi,
>>>
>>>How difficult is it to export data from SQL Server to SharePoint? Is it - typically - done on a batch basis (one time) or can it be done dynamically (continuously) ?
>>
>>What specifically are you trying to do in SharePoint? Short answer is a qualified "yes", but depends on what function SharePoint will do with the data.
>
>First, thank you for you message.
>SQL Server has a table and users would like to see some records of this table (probably in a user-friendly format) in the SharePoint. For example, all orders of a customer.
>Makes sense?

There are several ways you can do it.

Truthfully, I'd create a report in SSRS and deploy it to SharePoint. (SSRS has an integration to SharePoint feature). I've done webcasts on that. I can try to dig up the link to the webcast (it's been a few years, but I did multiple webcasts for it)

You can also create sharepoint lists that are associated with SQL data - though truthfully, if you can pull off the SharePoint to SSRS integration, that (IMO) is the way to go
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform