I want to fetch live data from SQL Server and make reports from it in Smartsheet. How can I do that. I have live data connector and Cdata. How can I export data from SQL Server to Smartsheet ?
Hi
My colleagues and I have recently completed a project for a roofing contractor MGC in Florida which demanded a flow of Data from SQL into Smartsheet and we did it via Appsheet.
If you want to read the case study do so here...
http://smarterbusinessprocesses.com/testimonials/
Using Appsheet we can add Conditional Logic and the slicing and dicing of data according to who the logged in user is, so people only see data they SHOULD see which is also a benefit for Smartsheet users.
Let me know if you want to know more? Craig Williams led on that project for us.
Hope that helps
RichardR