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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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?
-
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.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives