TransformData

This method is used for streamed forward-only direct database-to-file transformation.

There are several limitations in the usage of this method:

  • DataStructure has to contain only a single entity.
  • Transformation script has to be a single walk-through forward only. Any attempts to perform “jumps” in the data can result in incorrect output.

PARAMETERS

DataStructure

The Data Structure Reference

The Data structure (including a filter set, if required) you want to load data to. The service will automatically translate all the data model and filters to SQL statements and will load all the data required.

DataParameters

Context Store Reference, Data Constant Reference, System Function Call

Parameter names should correspond to the parameters required by the data structure (e.g. BusinessPartner_parId).

OutputFile

Context Store Reference, Data Constant Reference

Full path to an output file.

XslParameters

Context Store Reference, Data Constant Reference, System Function Call

In case the XSLT stylesheet requires some parameters, this is the place to bind them. The parameter name has to be the same as the one defined as <xsl:param> in the transformation.

You can pass also a complete context to the transformation so you can use other than the one specified using the Data parameter. In this case you need to specify ArrayResultDataType = Xml in the Context Store Reference. Then you can reference the data inside the stylesheet like this:

<!-- do not forget to set ArrayResultDataType = Xml
in the context store reference! -->
<xsl:param name="invoiceContextStoreData"/>
<xsl:template match="/">
<!-- now you can reference the context as a node set -->
<xsl:for-each select="$invoiceContextStoreData/ROOT/Invoice">
<result invoiceNumber="@InvoiceNumber"/>
</xsl:for-each>
</xsl:template>

XslScript

Transformation Reference

Reference to a XSLT transformation script.

EntityName

Context Store Reference, Data Constant Reference

Name of entity, that is being processed.

Parameter

Type

Description