Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export data from SQL server to SharePoint
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01652070
Message ID:
01652086
Views:
37
>>>>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform