Just curious Is it possible to link Smartsheet to SQL Server to fetch data?Thanks
It might be possible with the premium add-on called Data Uploader.
Would that work?
Happy New Year!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Depending on your use case, you may be able to use the Live Data Connector to connect your SQL Server with Smartsheet. The Smartsheet Live Data Connector is built on ODBC standards and can be installed as a driver in other ODBC environments. But, it should be noted that the Live Data Connector is designed to work specifically with the applications listed on the requirements page (https://smartsheet-platform.github.io/odbc-docs/#requirements). With the Live Data Connector, we only support using it in those listed applications. It's also worth noting that the Live Data Connector provides a read-only experience, so if you need to write data to Smartsheet, this may not be a suitable solution.If you would like to request added support for SQL Server with the Live Data Connector, please feel free to submit an Enhancement Request using the link below:
Submit Product Enhancement Request
I did find an available solution through Zapier which you may find useful also:
You could also consider using the available Smartsheet API to develop a custom integration. It is designed to be simple and intuitive, and is based on widely accepted standards and conventions, including REST, JSON, and HTTP success and error codes. Here are some resources for learning more about the Smartsheet API:
Hope that helps!
I just performed an evaluation of Smartsheet-to-SQL Server using Zapier. Short answer: FAIL.
Overall I found Zapier's connection from Smartsheet to SQL Server to be an incomplete and unsupported piece of middleware. In its current form it is not robust enough to be used in a production application.
Thank you, Mark! This was really helpful/informational. Could you please let me know what you're exploring as an alternative since SQL to Smartsheet using Zapier does not work for you?
I have not yet explored any alternatives to Zapier for pulling Smartsheet data into SQL Server. The options I have seen are both significantly more complex and expensive.
Thanks for sharing. It seems like Smartsheet and a SQL Database do not work well together...hopefully it's on their roadmap to improve this relationship.
Has someone looked at 'automate.io' to handle this?
Hey, I was having similar difficulties integrating with 3rd party tools so I developed a little web browser plugin to run SQL against my Smartsheet workspace. I just enter my API key into the connections tab, hit refresh, and it creates SQL tables for all of my sheets. I included screenshots to this post!
I currently just use this tool internally, but if your interested I'd be happy to set up a demo environment for you to try it out! If there is enough interest from the community I will publish the tool on the Smartsheet Solution Center!
soooo please upvote!
Interesting. I am looking for something like this for my project. It would be great if you can help me out. I have some Smartsheet sheets and reports. I want to load them on my SQL server DB. I tried using Smartsheet Live Data Connector without much success.
Hello Graham, Im interested on this project.
I am exploring MS Fabric, but could not find a way to load smartsheet to a lakehouse.
I'm not familiar with MS Fabric or Lakehouse. I would recommend using the API to replicate your schema, then you can query the tables directly. I can help you out if you want to schedule some time, let me know
I've successfully used CozyRoc to both push and pull data between Smartsheet and SQL Server in the past. You install it as an extension on SQL Server and it allows some pretty strong bidirectional activity via SSIS. I haven't looked into it much in the last year, but it worked well for me at the time. I'm honestly a bit surprised no one else mentioned it above... so maybe there is some reason others aren't using it?
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello, I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error. =COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row)…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.