Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export data from SQL server to SharePoint
Message
From
16/06/2017 13:47:03
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01652070
Message ID:
01652088
Views:
44
>>>>>>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
>
>I will see if I can find a good tutorial on SSRS on youtube or elsewhere. Thank you.

SSRS has a very nice feature - IT'S FREE!
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform