Loading SQL Data into Smartsheet
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?
Best Answer
-
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:
Let me know if you have any questions!
Regards
Sean
Answers
-
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:
Let me know if you have any questions!
Regards
Sean
-
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.
-
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?
