Loading SQL Data into Smartsheet

Benjamin O'Leary

Hello,

Is it possible to set up a connection between Smartsheet and SQL Server with automatic updates? For example, if I have a SQL query that updates daily, I want to be able to have a Smartsheet table with the same data that also updates daily alongside the SQL component.

Is it possible to accomplish this without the use of third-party apps?

Sean Morgan

Hello @Benjamin O'Leary ,

It appears you may have already gotten a response from our Support Team.

Although a connection cannot be set up directly, you may wish to review our articles on the Live Data Connector for bringing information into Smartsheet from outside sources. See more on this below:

https://help.smartsheet.com/learning-track/integrations-and-add-ons/live-data-connector

https://help.smartsheet.com/articles/2476166-smartsheet-live-data-connector-connect-smartsheet-and-third-party-tools-via-ODBC

Let me know if you have any questions!

Regards

Sean

Sean Morgan

Hello @Benjamin O'Leary ,

It appears you may have already gotten a response from our Support Team.

Although a connection cannot be set up directly, you may wish to review our articles on the Live Data Connector for bringing information into Smartsheet from outside sources. See more on this below:

https://help.smartsheet.com/learning-track/integrations-and-add-ons/live-data-connector

https://help.smartsheet.com/articles/2476166-smartsheet-live-data-connector-connect-smartsheet-and-third-party-tools-via-ODBC

Let me know if you have any questions!

Regards

Sean

lisamoy

Can you elaborate this answer? I would like to know if you can feed SQL query data to smartsheet Then use smartsheet sheets and dashboard for 5 minute updates from sheet that has data directly feeding from SQL query.

Laurie Mason

@Sean Morgan

https://community.smartsheet.com/discussion/comment/276830#Comment_276830

It was my understand that Live Data Connector is only to export data from Smartsheet, usually to a program like Tableau that provides visualization. Did I miss something on this? Like @Benjamin O'Leary and @lisamoy I am searching for a solution that will allow the automation of the an import of data into Smartsheet from SQL. I know it can be done using Data Shuttle from .csv or Excel, but that adds an additional step to the process. Any suggestions?