Skip to main content
This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.
LinkedIn
Copied!

Table of Contents

Data mapping in services and connectors - Concepts and terms

  Concepts and terms

Process Commander uses the term data mapping for the task of converting data received from, or sent to, an outside source or system into the formats, values, and objects needed within an application.

Most system interfaces, known as connectors and services, require data mapping in both directions, for the request and the response.

Typically the source (of outgoing data) and the destination (of incoming data) is a property on a clipboard page. For a developer, establishing the relationships among the external formats and structures and internal formats and structures can be laborious, exacting, and tedious. When dealing with legacy external systems, differences in character sets, the endian orientation of binary values, the representation of numbers and dates or times, and so on add to the complexity of data mapping.

TipFor more information about data mapping of SOAP messages, see PDNData Mapping XML, a document available from in the Integration area of the Pega Developer Network.

Process Commander offers several features that can simplify and speed this development task, including:

  • Eleven property modes and eleven Type values, accommodating needs for dates, times, numbers, and aggregates — arrays or repeating groups.
  • A flexible and powerful multilevel clipboard structure that supports embedded pages many levels deep.
  • A guided process for the development of connectors and conversion of WSDL files, database schema, and XML schema. See Using the Connector and Metadata Accelerator.
  • Direct execution of SQL statements, including stored procedures, through Connect SQL rules.
  • Automatic parsing of XML in arriving XML documents. See About Parse XML rules.
  • Automatic parsing of HTTP Post messages (sometimes called Common Gateway Interface query strings).
  • Data conversion routines provided by Edit Input rules. See About Edit Input rules.
  • Two parse rule for converting fixed-format records or string values into distinct property values. For simple cases, see About Map Structured rules. For more complex cases, see About Parse Structured rules.
  • A similar parse rule for converting tab-delimited input files into individual properties. See About Service File rules and About Parse Delimited rules.
  • Extensible libraries of functions for mapping, one each for inbound mapping (the MapTo library) and outbound mapping (the MapFrom library)
related topics Integration Mapping category
Apply-Parse-Delimited method
Apply-Parse-Structured method
Apply-Parse-XML method
Map-Structured method
Parse-Byte-Pos method
Parse-Char-Pos method
Parse-Fixed-Binary method
Parse-Packed-Decimal method

Up Concepts

Did you find this content helpful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us