Combine Smartsheet with database

Options
KROnline
KROnline ✭✭
edited 06/14/22 in Add Ons and Integrations

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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
    Options

    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?