I'm very new to GSA and looking for the possibility to integrate GSA search into a public site .

On the site, except limited number of static content, more than 80% of the content is dynamically generated based on user choice , they are stored in the Sql Server(s) as various tables, views( not PDF, not Word files ) across the application. Some tables and cols store our business rules as well.

How should I approach to get the database content crawled and indexed?

GSA offer anything or interface so I can import a list of table / cols ?

Any sample to do "GSA Collection" to sub divide a site based on database content?

Also how to make the hit results looks like organized content hosted by the site with URL ( as if pulled out from a document pool with focal topic - make sense to the end user )?

Maybe too many questions for one post.