Dynamic sitemap possible with app connector data?

Hi, I have a database I’m currently maintaining for internal purposes. There’s a subset of information that I’d like to make available as a public directory that is optimized to attract search traffic.

I wonder if the cleanest way to do it is to create a new app and pull in that information via the app connector. However, the data needs be indexed, and I assume that needs to happen via a dynamic sitemap.

If the data resided in the new app, generating a dynamic sitemap would be simple enough. However if instead I’m pulling in that data via the app connector API, can a dynamic sitemap be generated?