Using Transformations

User Guide > Using Transformations

This topic describes how to design transformations that are saved as procedures to query and manipulate data stored in a data source

The data for modeling can come from a mix of relational (tabular) and hierarchical (such as XML) sources. Having tools to help you transform your data is helpful when designing your data virtualization layer.

This section assumes that you understand XML, XQuery, and WSDL.

• Studio Transformation Types

• Creating an XML, XSLT, or Streaming Transformation

• Creating an XQuery Transformation

• Upgrading XML to Tabular Mapping Transforms

• Executing a Transformation

• Converting XML to JSON using Design By Example

• JSON XML List Formatting Example

Information about the Any-Any Transformation Editor is in:

• Using the Any-Any Transformation Editor