To execute an XTM and save output as an XSL file:

  1. Click Operations > Run. The Execute XTM window will appear.

  2. Click Save as XTM and run.

  3. In the Save as XTM and Run box, enter the full path and file name for the XSL file, or select a file and path by clicking the browse button.

  4. In the Source XML box, enter a full path and file name for the XML file to import data from, or select a file and path by clicking the browse button.

  5. Click OK. The XTM Tool will create an XSL file and add new data to the selected tables in the database.

 

Example:

XSL output:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

version="1.0"

xmlns:xtm="dbmaker.xml.xtm.XMLTransferMap"

extension-element-prefixes="xtm">

<xsl:template match="/">

<xtm:connect driver="dbmaker.sql.JdbcOdbcDriver" datasource="jdbc:dbmaker:DBSAMPLE4">

<xtm:table owner="DELPHI" name="CHINESE" select="/root/CHINESE">

<xtm:column name="ID" select="number(@ID)"/>

<xtm:column name="TEXT" select="@TEXT"/>

</xtm:table>

</xtm:connect>

</xsl:template>

</xsl:stylesheet>