I have used sql data source and Repeater web parts to access data from external database and display in the web page, but i need some steps to create transformaion to display the data.
You need to create a new document type that is a placeholder/container that does not hold any data. You can then create transformations within there that hold what you're looking for.
Please, sign in to be able to submit a new answer.