RESOURCE CENTER FOR THE STATE OF CT

PilotFish State of CT Training Classes – Videos


PilotFish has provided onsite product training for State of CT employees.

Below are links to the recorded sessions as well as descriptions of the topics covered in each session. If you are interested in custom training for your department please click this link to contact the state’s Pilotfish Coordinator at DAS/BEST.

Executive Overview of the PilotFish Implementation at the State of Connecticut

The State of CT has licensed an Enterprise License of PilotFish Technology’s Integration Engine, the eiPlatform and the eiConsole the graphical, developer’s workstation complement. Any state agency or department, including State Universities and Medical Centers, may utilize this software as part of the State’s license. This session will cover the terms of the license and how state departments and agencies can leverage the technology.

PilotFish 101 – An Introduction to the eiConsole
1.    Demonstration of the eiConsole
      Learn the basic concepts and terminology as a simple Interface is explained and demonstrated.

2.    Developing Your First eiConsole Interface
      Learn how to build a sample interface from beginning to end. This is the "Hello World" of interface examples, touching all major components but each one only at a superficial level.

      Sub-topics:

      1. Creating a New Route
      2. Configuring the Interface Topology
      3. Generating a Simple File Specification to Convert Flat Files to XML
      4. Generating a Simple XSLT transformation with the Data Mapper
      5. Testing the Interface
Data Mapping in the eiConsole - The Basics
1.    Using the Data Mapper 
      Learn the basic steps involved in generating an XSLT transformation in the Data Mapper

      Sub-Topics:

            1. Creating a New XSLT transformation
            2. Loading the Source Format
            3. Loading the Target Format
            4. Loading Source & Target Sample Data
            5. Creating a Template from Target Sample Data
            6. Performing a 1-to-1 Mapping through drag & drop
            7. Performing a Tabular Mapping through drag & drop
            8. Adding Conditional Logic with xsl:if
            9. Adding Looping Logic with xsl:for-each
            10. Building Complex XPath Expressions
            11. Modifying XSLT in XSLT view
            12. Testing in the Testing Tab
Data Mapping in the eiConsole - XSLT and other advanced topics
1.    Advanced Data Mapper Topics
      Learn about some of the advanced features of the Data Mapper and XSLT.

      Sub-Topics:

            1. Recursive Templates
            2. Identity Transforms
            3. Keys and De-Duplication
            4. Custom Java Call-outs
SQLXML - Working with Databases and the eiConsole
1.    Using SQLXML to Manipulate Databases 
      Learn the basics of SQLXML and how it can be used in tandem with the DatabaseSQL Listener and DatabaseSQL Transport to acquire data from the database and update data in the database.

      Sub-Topics:

            1. Configuring the DatabaseSQLListener
            2. Generating a SQLXML Query File

                        a. Generating a simple SELECT query to acquire data from an Access database.
                        b. Using SQL:Iterate and SQL:Update to update the selected rows with a "Pending" status

            3. Testing the DatabaseSQL Listener in Testing Mode
            4. Building a Mapping to SQLXML in the Data Mapper

                        a. Using SQL:Execute to Wrap a Parameterized Query
                        b. Using SSL:InsertOrUpdate to Add and Insert Rows
                        c. Using SQL:Update to Update Rows with a "Complete" Status

            5. Configuring the DatabaseSQLTransport
            6. Testing the Interface in Testing Mode
Flat File Conversions - Using the File Spec Editor to convert files to and from XML
1.    Using the File Specification Editor
      Learn the basics of using the file specification editor to consume a flat or delimited file and to generate XML, or to use XML to generate a flat or delimited file.

      Sub-Topics:

            1. Creating a transformation from a delimited file to XML

                        a. Import headers from a file
                        b. Add a field manually
                        c. Test in Editor
                        d. Test in Testing Mode
                        e. Save output

            2. Creating a Transformation from a Fixed-Width File to XML

                        a. Import Record Definition from a Spreadsheet
                        b. Add a Field Manually
                        c. Build a Simple Record Control
                        d. Validate in the Preview Window
                        e. Test in Editor
                        f. Test in Testing Mode

            3. Create a Transformation to a Fixed-Width File from XML
            4. Create a Transformation to a Delimited File from XML
Workflows & Data Orchestration - Combining routes with the eiConsole, error handling & notification
1.    Building Synchronous and Chained Interfaces 
      Learn the basic pattern used to develop synchronous and chained interfaces, using a simple Web Service as an example. The concepts of Response Listeners and Synchronous Responses will be covered.

      Sub-Topics:

            1. Synchronous Responses

                  a. Creating a Route with a Synchronous Listener
                  b. Testing the Route

            2. Route-to-Route Interfaces

                  a. Configuring the First Route
                  b. Configuring the Second Route
                  c. Testing with the eiPlatform Emulator

            3. Handling Synchronous Responses

                  a. Creating the Skeletal Request Route
                  b. Creating the Skeletal Response Route
                  c. Passing the Results of a Transport to a Response Route
                  d. Returning the Results of an Interface to a Synchronous Listener with the SynchronousResponse Transport

2.    Building Orchestrated Interfaces
      Learn about Orchestration Listeners and Transports and how to configure and test them. 

      Sub Topics

            1. Overview of Process Orchestration Concepts
            2. Configuring Orchestration Transports for Joining
            3. Configuring Orchestration Listeners

3.    Implementing Error Handling with Transaction Monitors 
      1.    Transaction Monitors
            Learn the basics of exception handling in the eiPlatform and the eiConsole, covering some of the common patterns that are used to manage error handling.

            Sub-Topics:

                  1. Brief Introduction to Transaction Monitors
                  2. Implementing an E-Mail-based Transaction Monitor
                  3. Implementing an Error Route Trigger to Customize Error Messages
                  4. Passive Error Handling
                        a. Logging and Log Files
                        b. Debug-Tracing
PilotFish 201 - Working with environment variables, transaction attributes and OGNL
1.    Using Environmental Variables, Transaction Attributes, and OGNL 
      Learn the concepts of Environmental Variables, Transaction Attributes, and OGNL in interface building. The developer will build a trivial interface which will illustrate how each of these concepts may be used.

      Sub-Topics:

      1. Environmental Variables

            a. Editing the "environment-settings.conf" File
            b. Using Environmental Variables in Configuration Items
            c. Inserting Environmental Variables in the Data Mapper

      2. Transaction Attributes

            a. Overview of Transaction Attributes
            b. Viewing Transaction Attributes in Testing Mode
            c. Getting and Setting Transaction Attributes with Processors
            d. Getting and Setting Transaction Attributes in the Data Mapper

      3. OGNL and Advanced Expressions

            a. Overview of Configuration Expression Syntax
            b. OGNL Expressions
            c. XPath Expressions
            d. Environment Variable Expressions
            e. Transaction Attribute Expressions
Deploying Interfaces - A look at the eiPlatform comfiguration, deployment and management
1.    Deploying the eiPlatform
      Learn the eiPlatform Deployment Process.

      Sub-Topics:

            1. Review the Structure of an eiPlatform Working Directory
            2. Building the Logging and Audit Database
            3. Deploying the eip.war File
            4. Configuring the eiPlatform Root Directory
            5. Configuring Logging Levels
            6. Deploying a Simple Interface
Focus on DDS - Creating ``Adapter`` Web Services with the eiConsole
PilotFish will walk through the use of WSDLs and SOAP web services for the DSS interface, which accepts SOAP messages and transforms them appropriately for connected web services. This acts as a "wrapper" layer for existing services, providing alternative input formats without requiring modification of the existing service.

a. Providing Web Service Adapters

      Learn about web services, WSDLS, and how these were used for DSS.

      Sub-Topics:

            1. Overview of the Interface Requirements
            2. Review of Federally-provided WSDLs
            3. Demonstration of Interface and Explanation
Focus on DPH - Working with HL7 in the eiConsole
PilotFish will walk through the topography and layout of the DPH Immunization interface, which covers transforming between CDC-recommended content for HL7 and the Maven XML integration format. Validation of HL7 content prior to transformation is also discussed.

      a. Transforming to and from HL7

      Learn about the HL7-Specific Features of the eiConsole

      Sub-Topics:

            1. Review of the HL7 Transformer and Options
            2. Data Mapper Support for HL7
            3. Data Mapper Code Look-Ups
            4. Testing HL7 Data
Focus on DESPP - Collecting data from the Web with the eiConsole
PilotFish will walk through the DESPP interfaces, which involve processing payments via PayPal, as well as posting and retrieving information pertaining to background checks. This will also cover processing of data from web forms.

a. Providing Web-based, Electronic Form and Payment Processing

      Learn about how the eiConsole is being used by DESPP for electronic form capture and handling, electronic payment processing, and querying.

      Sub-Topics:

            1. Overview of the Interface Requirements
            2. Handling Electronic Form Input
            3. Processing Payments in the eiConsole
            4. Updating the Query Database
            5. Demonstration of Concepts
Focus on Core IT - Orchestrating file movement with the eiConsole
PilotFish will demonstrate and walk through the Core IT "file mover" interface, which picks up data from a database and places the content into files in various directory locations. This section covers the practical applications of database querying / updating, environment setting configurations, and dynamic expressions.

a. Interface Overview

      Learn about the migration of the "FileMover" interfaces to the eiConsole

      Sub-Topics:

            1. Overview of the Interface Requirements
            2. Triggering the Interface
            3. Querying the Database for File Transmissions
            4. Validation, Encryption, and Other Processing
            5. Delivery Mechanisms
            6. Testing the Interface
Working with PilotFish - How to engage PilotFish for your first project

PilotFish in concert with the State of CT has put together a complete process for working with PilotFish. This session, among other topics, will cover how to get started, how to use the PilotFish Requirements Questionnaire to establish parameters for your project and how to schedule a face to face with PilotFish to review your requirements.

Understanding the PilotFish Interface Exchange (PIE)
The PIE (PilotFish Interface Exchange) is a Web-application that enables any entity in the web universe to easily and rapidly share interfaces and interface components that were developed using the PilotFish XCS eiConsole. The PIE encourages collaboration between all members of an industry ecosystem.

In this session you will learn:

      1. How to use the PIE.
      2. How to leverage the PIE to your own department's advantage.
      3. How to use the PIE Wizard to publish your interfaces.
      4. What interface or components are good candidates for being published on the PIE.
Validation and the Automated Interoperability Test Portal
The PilotFish Automated Interoperability Test Portal is a cloud-based solution that provides all of the resources required to establish standardized initial and ongoing information exchange. The portal links to a web repository for an exchange partner's implementation guides, sample message formats, sample data and the exchange partner’s contact information. This provides an organization's or exchange partner's trading partner with everything they need to build an interface. The Portal's fully automated testing facility is provided to trading partners to allow validation of information exchanges before going live and without live support from the organization. In the session you will learn:

      1. How the Portal works.
      2. What are the features of the Portal and how it can be best utilized.
      3. What kind of validation can be accomplished with the Portal.
      4. What agencies or departments may be able to leverage the Portal for their own use.

Want to learn more and see how PilotFish products can help your agency or department? Click this link to contact the state’s CJIS Program Coordinator at the Department of Information Technology.

Ready to get started now? Download a full license (for state employees) now.

Not a CT department or agency? For a free consultation and to let us show you how you can benefit from this breakthrough technology, please call PilotFish Technology at 860 632 9900 x 309 or click the link below to email us.

This is a unique website which will require a more modern browser to work! Please upgrade today!