Integrate Data Beyond Your Enterprise with the eiConsole for Splunk

PilotFish, a leader in integration engine solutions, has been helping companies connect and exchange data with disparate systems for over 23 years. Splunk Inc. is the leading platform for Operational Intelligence. Splunk® is relied on for real-time insight and understanding gained from an organization’s enterprise machine data.  

PilotFish is pleased to announce both its partnership with Splunk and the eiConsole for Splunk.

The eiConsole for Splunk is the Integration Engine for Splunk users that effortlessly enables instant interaction with data beyond your enterprise. Now Splunk users can gain added insight from outside data sources and derive value from the full spectrum of data, from anything and anywhere.

The eiConsole for Splunk gives you the freedom to integrate Splunk with any database, system, device or application. It is a system, platform, and database agnostic and can be deployed onsite or in the cloud.

PilotFish software has been architected explicitly to support handling the nuances of any industry’s information exchange and the semantics of its data and standards. The eiConsole for Splunk provides out-of-the-box support for virtually every data format you might encounter outside your enterprise.

The eiConsole for Splunk provides instant connectivity, too, with over 2 dozen built-in connectors. If you need support for some other connectivity protocol, simply add it using our Open API or .Net bridge.

The eiConsole for Splunk makes it easy to integrate with data sources outside of your enterprise. Integrations are configured following a graphical Automated Interface Assembly Line. The assembly line consists of 7 stages. Start by configuring your source and target systems.

In the Source target stage, add a source, or two or three. You can choose from our library of built-in icons or use your own. Label your source for easy reference later. In the Target Stage, add Splunk as your target. (You can add as many source and targets as you like.)

Next, select the Listener stage. Choose the connectivity protocol from a drop-down of built-in connectors. Each Listener has a pre-configured panel with default settings that make it easy.

Next, select the Source Transform stage. The configuration panel opens, select the New Format button and type in a name. Uncheck Direct Relay and click the New button to open the data mapper.

The eiConsole features a 3-pane, drag & drop data mapper. Your source is on the left, the target is on the right. You create a mapping by simply dragging source and target fields into the middle pane.

Choose from a palette of XSLT structures and functions to do anything graphically that you can do programmatically. To create “for each” statements and “concatenation” simply navigate to the palette and drag them on to your mapping.

With the eiConsole, Complex Data Mappings can be created in minutes and are reusable too. While you never have to rely on scripting or coding, the eiConsole generates W3C compliant XSLT under the covers. If you want to work in code view, you can simply toggle back and forth in real-time between graphical and code views.

Besides productivity tools like the Data Mapper’s built-in format readers that allow you to instantly read in your data, the eiConsole offers a friendly name feature and lenient parsers.

Friendly Names replaces cryptic HL7 names with simple, understandable synonyms derived from field descriptions in the HL7 vocabulary. Lenient Data Parsers allow you to read in even non-standard compliant HL7 and EDI. The eiConsole allows you to easily normalize unknown or complex industry-standard formats, right within the data mapper. Where available, the eiConsole includes inline documentation, too.

The Data Mapper also includes a built-in testing mode. Simply load in your sample data and run your test. After you have mapped your data and tested return to the eiConsole’s main route grid and continue configuring your interface.

Once you have completed the next stage is the Route stage. Here we can add Routing Rules. You can send to All Targets or layer XPath expressions to route transactions. You can also add Transaction Monitoring to set up Email Alerts, Error Route Triggers and SNMP Traps.

Next, select the Target Transform stage. Here you can perform transformations on your data to match what the receiving system requires. As with the Source Transform stage, you can select from built-in transformation modules to instantly read in your data, or use the eiConsole’s Data Mapper to map your data to the Target format.

Moving along to the Transport stage, like the Listener stage you are presented with over 2 dozen built-in adapters including the eiConsole’s Splunk Event Logging Transport. This allows adapter allows Splunk users to post transaction data as an event to a running Splunk instance via HTTP.

Now that you have configured the interface, you can test it end to end in the eiConsole’s Testing Mode. Select Testing Mode from the Route Menu. In Testing Mode, you can start and stop your test at any stage and view the output of any stage. It alerts you to errors so that you can work iteratively until your interface is fully tested and ready for deployment.

The eiConsole for Splunk makes deployment easy, too. In the eiConsole, configurations are just files on the filesystem. To copy files simply navigate to the root directory chosen for these configurations, and copy the files over to the other server, use the eiConsole’s built-in drag & drop feature or deploy your interfaces through the eiDashboard, PilotFish’s web-based application for Operational reporting and management of your interfaces.

The eiConsole for Splunk effortlessly enables instant interaction with data beyond your enterprise. Splunk users can gain added insight from outside data by leveraging the eiConsole’s Splunk-specific Tools and Adapters:

• Splunk Search Listener – execute Splunk search queries and process the output
• Splunk Transport – Post transaction data as event data to Splunk
• Splunk Processor – Send events to Splunk at specified stages of interface progression
• Splunk Log Appender – Log4J appender configuration provided in a logging configuration file

With the eiConsole for Splunk, users can realize value from the full spectrum of data, from anything and anywhere. Download a Free 90-Day Trial of the eiConsole for Splunk. Try it! 

*Splunk is a registered trademark of Splunk Inc. in the United States and other countries.
HL7 is the registered trademark of Health Level Seven International.