Combine Smartsheet with database
Hello,
is there a connector to databases, e.g. to keep the data in a smartsheet synchronously in a database table. That means read and write back.
If yes, which databases like SQL-Server or Oracle are supported?
I would be grateful for tips and hints on AddOns.
Thanks and greetings
Kay
Answers
-
Hi @KROnline
Nathan lists out the possible options for connecting with an SQL server in this other Community post, here: Smartsheet to SQL Server.
The Live Data Connector mentioned provides a read-only experience, though, so you may want to look into the API suggestions instead.
Cheers,
Genevieve
-
The live data connector seems to imply you can pull data from Smartsheet into your databases. I would like the opposite. I would like to create a dashboard as a single static SmartSheet and have it pull data from various databases which are not cloud based. Is it possible for Smartsheet to acquire data from on-premise databases in real time?