I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
Hello @Senthil Anandarangan
Although there is no dedicated integration with SQL, you can use the ODBC connector to communicate with Smartsheet.
See more on this here: http://smartsheet-platform.github.io/odbc-docs/#overview
You can raise an Enhancement Request on the right hand side for other integrations you'd like to see within Smartsheet 😀
Thanks for your response. I am looking for WRITE into the Smartsheet. From the link it looks like ODBC connector supports only READ from the Smartsheet. Is WRITE from SQL to SmartSheet possible by using Smartsheet DataUploader?
Apologies for the delay in response.
Data Uploader is it's on application for adding data into sheets, from a source E.G Excel sheets.
Contrary to this, you may be able to achieve this with the 3rd party application Zapier
@Sean Morgan , @Senthil Anandarangan
Hope you guys are doing well !!!
I am new to smart sheet and want to establish Smartsheet and SQL connection.
Can you let me know how can I do that.
In addition to that.. I have setup ODBC connection as well.. but not sure how to process further.
Thanks & Regards,
We've build several tools and solutions to sync data from/to SqlServer and MySql with smartsheet.
As an example we can read a table or view, and automaticly insert/update smartsheet rows based on a custom mapping.
If you would like to know more, please contact @Richard Rymill SBP or me for more details.
As Smartsheet Integration partners of some 12 years experience, we can certainly resolve your needs for you. We offer a free initial consultation. Please let me know a good time to meet?
ps Etienne is our Development manager.