Combine Smartsheet with database

KROnline

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

Genevieve P.

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

EricFromNorCal

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?

Genevieve P.

Hi @EricFromNorCal

Can you clarify where your data is stored? If Smartsheet does not have a direct integration, you may be able to use a third party application (such as Zapier) to bring in your data, or use the Smartsheet API.