PilotFish Interface Exchange (PIE)

Prerequisite

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

Synopsis

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"
• SQLXML "XMLOut"

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).