PilotFish Interface Exchange (PIE)

This interface and related tutorials demonstrate and explain the use of SQLXML, a database-agnostic, XML-based language used in the eiConsole to query and update databases. In this tutorial we expand on SQLXML basics and introduce the "Update" and "Insert" instructions for updating and inserting rows. More...

This interface and related tutorials demonstrate and explain the use of SQLXML, a database-agnostic, XML-based language used in the eiConsole to query and update databases. In this tutorial we cover SQLXML basics and the "Select" instruction, including creating and configuring a database and its tables and then selecting data from it. More...

This interface and related tutorials demonstrate and explain the use of OGNL expressions in eiConsole module configuration items, which allow for dynamically evaluted, programmatic statements. In this tutorial, we cover using a standard Java class to create a "UUID." More...

This interface and related tutorials demonstrate and explain the use of Environment Properties in eiConsole module configuration items, which allow for externally defined values for Listeners, Transports, etc. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Templates") is modified to transform a "PeopleA" XML format to the "PeopleI" XML format. This mapping makes use of XSLT keys and the "Muenchian method" to perform de-duplication. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Templates") is modified to transform a "PeopleA" XML format to the "PeopleH" XML format using an "identity transform." Identity transforms allow users to make discrete changes to a document without remapping it in its entirety. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Conditions") is modified to use templates to transform a "PeopleA" XML format to the "PeopleC" XML format. This tutorial covers the use of named and matched templates, as well as parameters. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Java Call-Outs") is modified to transform a "PeopleA" XML format to the "PeopleG" XML format, which makes use of iteration, conditions, and variables to output "Neighbor" elements. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Tabular Mappings") is modified to transform a "PeopleA" XML format to the "PeopleF" XML format, which makes use of a Java method call-out to generate a unique ID. More...

This interface and related tutorials demonstrate the use of the Data Mapper in Route configurations to transform between XML formats. In this particular exercise, an existing Route (from "Data Mapping - Using Functions") is modified to transform a "PeopleA" XML format to the "PeopleE" XML format, which makes use of the Tabular Mapping tool to convert between Gender code sets. More...