Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Export data from SQL server to SharePoint
Message
De
16/06/2017 10:01:18
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01652070
Message ID:
01652079
Vues:
41
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform