You can translate the question and the replies:

Can the Built-In XSLT Transformations capabilities be used to generate highly formatted, dynamic query, PDF documents?

We need to generate formatted documents from data in our SQL database including images. A parameterized query is used to access the data set for each document to be created. Can the Denodo built-in XSLT transformations capabilities be sued for this purpose? If so, do you have any detailed documentation on how to accomplish this? Thank you.
user
24-02-2021 14:44:33 -0500

1 Answer

Hi, If I face a similar situation, I would [create a base view using query](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) from the JDBC data source and then [publish](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services) this view as a Rest web service. After this, I would then navigate to ‘**Edit > Settings > XSLT Transformation**’ in the web service to perform the [XSLT Transformation](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/publication_of_web_services/xslt_transformations/xslt_transformations). You can take a look at the [Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/transforming_incoming_outgoing_soap_rest_messages_with_xslt_stylesheets/transforming_incoming_outgoing_soap_rest_messages_with_xslt_stylesheets#transforming-incoming-outgoing-soap-rest-messages-with-xslt-stylesheets) section of Virtual DataPort Administration Guide for more information. If you still need help and if you are a valid support user then you can raise a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps!
Denodo Team
25-02-2021 07:27:11 -0500
You must sign in to add an answer. If you do not have an account, you can register here