PilotFish Interface Exchange (PIE)

A marketplace for eiConsole (IDE) interface templates, components and industry bundles
eiConsole IDE 90-Day Free Trial!
Licensor contacts
The eiConsole IDE is highly recommended to support graphical development of interfaces for deployment to the eiPlatform runtime The eiPlatform is required to run in production interfaces configured using the eiConsole
eiConsole 10.13R1
Release Date
October 19, 2012
Resource Type

Product details

SQLXML - Selecting Rows
(eiConsole III - Interface & Training)


A full or Trial License of the eiConsole (Download a 90-Day Trial Now!). Completion of Level I Training.


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.

Core Concepts:

  • Databases
  • SQLXML Basics
  • SQLXML "Select"

How to Use This Example

Download the interface using the Free Download button under the eiConsole Interface logo.

Note: if you are not logged in to the eiConsole, or have arrived at this page via a browser, you will be prompted to login before the interface downloads into your eiConsole "PIE" inbox.

Note: If you have not downloaded and installed a FREE Trial you will have the opportunity to register via a simple process after you click the Free Download button.. Once you are logged in the interface will automatically download into your "PIE" inbox.

Next, download one of the tutorials on this page (from the right column) and walk through it step-by-step. You may check your work against the provided Route (Sample Data).