Dear Kentico Developers,

We are currently in process of planning a Kentico-based client portal. What our customer wants to accomplish (in general terms) is to display data from multiple MS SQL data sources to authenticated users in format of a dashboard with social-networking-like feeds - my orders, my invoices, etc.

What we have in mind to accomplish this is to create/use various 'datasheet templates' in .xml doc format that would be further used as respective 'data views' in HTML output generated via XSLT (Kentico cmsviewer control).

As far as we recognize it, the benefit of using 'datasheet templates' would be to: a) provide 'data containers' into which DB data would be loaded; b) provide a pre-defined structure that would enable us to operate on DB data using XML Schema for validation and XSLT for output, respectively.

Now, what we would like to kindly ask your opinion on is as follows:

1. Is it possible (with Kentico) to use the following pipeline: a) open multiple DB connections via C#, b) query respective DBs, c) load respective data into XML datasheet template, d) validate data against provided XML schema before transformation, e) apply XSLT transformation via Kentico cmsviewer, f) output 'data view' in HTML format.
2. Is our approach at all correct in context of Kentico's capabilities?
3. Would there be better, alternative methods to accomplish what we need to?

We shall be very grateful for your responses, thank you very much in advance -

With best regards -
Piotr Bonarski
Accreda Ltd