Import Data from Database

Good day,

I am looking for a solution that will allow me to automatically populate a Process Owner column in Smartsheet from an Oracle table (for example).

From what I have been able to find, the Live Data Connector is not capable of importing data from a Database to Smartsheet (It can go the other way, which in this case, isn't the direction I'm looking for).

Is there a solution already built into Smartsheet that will allow for me to connect to a Database (Oracle, Athena...) without the use of Third Party applications?

Warm regards,

Ryan

Find more posts tagged with

functionality

Automations

Importing and Exporting

Accepted answers

All comments

Andrée Starå

Hi @ryan_desautels

I hope you're well and safe!

You could use the Premium App, DataShuttle, or the Smartsheet API.

Is that an option?

I hope that helps!

Have a fantastic weekend & Happy Thanksgiving!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ryan_desautels

Hello @Andrée Starå

Thank you for your reply!

I will look into the Smartsheet API. That may be an option, although it may be a bit beyond my skills at the moment (but nothing that can't be learned).

Warm regards,

Ryan

Andrée Starå

@ryan_desautels

Excellent!

Happy to help!

More info.

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

https://developers.smartsheet.com/

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.