What's the best way to import data from an external database in to the Appian database?

I have a relatively east concept idea that a business user wants to do.

They want to take their data in their SQL database and put it on Appian as a dashboard to be viewed by users.

What's the easiest way to do this?

I essentially want to query their database for all of the rows and assign them to a CDT and save them in the appian Database. Then, I can put this data in an interface grid for them to view.

Any thoughts/suggestions?

Thanks,

  Discussion posts and replies are publicly visible