As part of evaluating whether or not to port an existing application to Kentico, I would like to use a data source Web part to perform a query on an external database (from the existing application) and then use transformations to display it.

If I understand correctly, I need to place the data source on the page and then a basic repeater. I then set what transformation to use on the basic repeater.

My question is, where do I define the transformation? Were I using a custom table (something else I'm looking into), then I would set it in the properties for the custom table. Or, similarly, if it were a document type (the data being stored would be inefficient to store as a document), then I would set it under the document properties. The problem here is that I don't have any such "nice" place to put the template. I'm considering creating a dummy document type just to store templates for this purpose. Is there another way?