Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export data from SQL server to SharePoint
Message
From
16/06/2017 12:37:14
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01652070
Message ID:
01652085
Views:
46
>>>>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
>>>
>>>Thank you, Kevin. I think if the customer decides to integrate my app data with a SharePoint, they will be choosing the path and doing the work. But I will "copy and paste" your suggestion to them. Of course, I will take all the credit :).
>>>Seriously though, this customer is currently using my app with VFP data and I am interested that they would upgrade to the SQL Server VFP application. I wrote to them that getting the data from VFP database to SharePoint is not possible (at least I don't know how).
>>
>>You can create an SSRS report that points to VFP data. And then you can deploy the SSRS report to SharePoint. It's definitely a few steps but then you get the functionality of previewing SSRS inside of SharePoint.
>
>I have never done SSRS reports so this would require some learning. I need to think about this approach.
>Thank you very much for the suggestion.

As a general statement, if you work with SQL Server, and you work with VFP apps, and you're in positions where you need to show data in web pages/web apps and/or SharePoint, I definitely recommend getting involved with SSRS.

It's a great general purpose reporting tool. It's not perfect...but it usually does the job
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform