Show TOC

Object documentationXML Connector Locate this document in the navigation structure

 

The XML Connector allows you to connect to and query any XML-compliant data source and return data in SAP Manufacturing Integration and Intelligence (SAP MII) format.

You send the data as XML using XSL transformation.

 

The system includes a default XML connector. If you want to allow security access to specific XML documents or queries, you add other XML connector server instances and set server permissions for each instance.

You must transform the XML data from the data source to SAP MII XML format using an XSL Transformation (XSLT) file. For SAP MII to process the data, the XSLT file, data source, and query must be referenced.

An XSL style sheet contains instructions for formatting a class of XML documents. The style sheet consists of the following:

  • A language for transforming XML documents

  • An XML vocabulary for specifying formatting semantics

If you want to use the XML Connector to retrieve data from one XML source and send it to another system, you must apply a style sheet to the SAP MII-formatted data to make it available to the other system.

Structure

Each data query returns an XML Document Object Model (DOM). Since XML is case-sensitive, the XML output must use correct element and node names.

The XML data file includes the following levels:

  • Rowsets

    • Rowset

      • Columns

      • Rows

Rowsets contains the following attributes:

  • Document creation date

  • Software version

  • Start Date (SD) and End Date (ED) settings used by the query

The Columns node contains metadata, and is followed by one or more Row elements. The metadata describes columns, which can be mapped into SAP MII display objects or used in KPI calculations and agent activities. The Columns node requires the following attributes:

The Rows node contains data returned by the query object. Each data set is returned as a separate data element in a Row node.