Home > Products > LANSA Integrator
Request More Information

LANSA Integrator

Data integration software for open business connectivity

This video requires Flash version 8 or higher.
It Appears that you do not have the Flash Plug-in Installed or you have an older version of the plugin. Please update or install the Flash Plug-in to view this content.
Get Flash

LANSA’s data integration software enables integration of Application-to-Application (A2A) and Business-to-Business (B2B) transactions through XML and Java services. It allows bi-directional XML – and other data formats – to be exchanged between you and your trading partners, regardless of platform. It also enables integration of user-written Java services with LANSA, C, RPG and COBOL applications.

What can LANSA’s data integration software do?

  • Automate orders between a manufacturer and distributor by dynamically linking ERP systems.
  • Exchange information between ATMs and server-based banking systems.
  • Integrate a Java-based credit card application with an order entry system.
  • Send and receive XML transactions between suppliers and distributors.
  • Exchange data between a stand-alone Wireless device and the server.
  • Publish or utilize 3rd-party Web services via SOAP.
  • Provide SOAP interfaces to your existing business functions.
  • Integrate heterogeneous CRM and back-office systems via XML over MQ Series.
  • Provide secure (digital certificates and password protected) PDF documents via email for contract agreements.
  • SMS updates on the status of order or delivery transactions in real-time.
  • And many more practical applications...

Overcome the challenges

LANSA’s data integration software provides a productive environment for integrating data between diverse platforms and applications. Integrating data and applications across diverse platforms typically requires complex technologies like XML, Java, C# and more. LANSA’s data integration software includes many XML and Java services for B2B and A2A integration. In addition, integration is automated for Java programs that are required for business logic.

LANSA’s data integration software eliminates the need for your programming staff to learn these complex technologies.

A flexible data integration solution

LANSA Integrator, our data integration software enables integration of A2A and B2B transactions through XML, SOAP and Java services
LANSA Integrator enables integration of
A2A and B2B transactions through
XML, SOAP and Java services

Some of your partners may mandate the use of XML or EDI to exchange data, others may use more basic formats like Excel spreadsheets or flat files. LANSA Integrator is a flexible data integration software solution that allows you to use communication formats – from XML schemas to spreadsheets – and meet any technical requests.

How LANSA Integrator works

Dynamic Transactions
Data can be sent directly from your customers or suppliers via XML or any number of standard file formats. LANSA Integrator accepts the transmitted data, validates it, sends a response back and then creates the transaction into your back-end application.

SOAP Wizard
The SOAP Wizard is an application that allows you to use Web Services from the included Java Service Manager (JSM). LANSA Integrator’s Agent and Server SOAP services let you call or offer Web services easily. Offer your own Web services to expose your own set of operations, with custom parameters and return values, which a third-party client can connect to and use. Or communicate with a third-party Web Service to allow the Java Service Manager to communicate with a SOAP-based Web Service using a WSDL file supplied by that service.

Integrating with Java
For third-party or user-defined Java classes, the Java Service Manager takes any complex task or protocol and simplifies it into a series of commands. The LANSA or 3GL developer who wants to utilize these classes only needs to understand how to use the commands offered by the Java Service Manager – they do not need to be experts in Java.

Visual XML Wizard
The Visual XML Wizard allows you to visually map the attributes of XML Schemas or XML documents to LANSA fields and lists. The Wizard then automatically creates stylesheets that can be used to transform inbound XML to LANSA fields and lists or to transform LANSA fields and lists to outbound XML.

The Visual XML Wizard enables rapid mapping of complex XML tags to LANSA fields and working lists. This eliminates the code needed to map XML tags to the data for a LANSA programmer.

User Agent
The User Agent automates B2B transactions with simple formats like spreadsheets and text files or uses more complex XML files if required. Enter data via Windows clients (and soon Palm and Pocket PC clients) and send the validated files to remote hosts.

Remote Function Invocation
Remote Function Invocation (RFI) is middleware that makes remote integration as easy as coding to a local object. Windows developers write to local objects that automatically reflect changes to remote host objects with all network communications automated.

RFI is much faster than JDBC – network traffic is minimized and it is easier to code. Instead of a proprietary interface, RFI allows the developer to define any object and have it reflected remotely.

Interact with 5250 applications automatically
Use LANSA Integrator to automatically enter data into fields on screens in existing 5250 applications, just like a data entry operator would. For example, take customer orders from a file and automatically enter the data into the existing order entry program – orders go through the same validations and processing as manually entered orders. Automate processes by performing operations such as:

  • Connect, logon and disconnect a 5250 session
  • Enter values into fields on screens
  • Send function keys such as ENTER and F3

This feature also works in reverse to extract data from fields and labels on screens.

Note: This feature requires aXes Terminal Server which is a separately licensed product and additional software license fees apply.

One of the many ways you can use LANSA Integrator to dynamically exchange data between organizations
One of the many ways you can use LANSA Integrator to dynamically exchange data between organizations

Features:

Business Process Management

  • Easily integrate Java services with LANSA and 3GL on iSeries, AS/400, Windows and Linux
  • Shipped services for A2A and B2B integration including data transformation
  • Easily integrate additional custom services
  • XML and EDI document parsing, generation, transformation and support for compiled style sheets (XSLT)
  • Real-time data integration and batch data exchange capabilities
  • LANSA Repository for metadata management
  • LANSA high level language for productive process logic definition
  • Event recognition and trigger capabilities
  • Visual XML Wizard maps XML schemas and XML documents to LANSA and 3GL data
  • User Agent Java client uploads files to remote host using FTP, HTTP or MQSeries

LANSA Integrator Architecture

  • Java Service Manager (JSM) provides an interface for calling Java services
  • Consistent OO deployment for all services
  • Fast and scalable multi-threading in single Java Virtual Machine
  • Property editor
  • Secure HTTPS, SFTP and other open standards
  • Extensive tracing for debug and audit

iSeries and AS/400 Specific Services

  • Native services support data queue, message queue and user space communication
  • Read/write documents stored locally on IFS

Remote Application Services

  • Remote Function Invocation (RFI) middleware for Java developers
  • SQLService to access remote SQL databases

Data Format Services

  • File formats include CSV, XLS, TSV and TXT
  • Data from DB2/400, Microsoft SQL Server, Oracle, Sybase, MySQL and more
  • Supports ASC X12 and UN/EDIFACT EDI file formats and SEF (Standard Exchange Format) Editor
  • Embedded XML parser with XML editor
  • Automatically generates XSL style sheets for transformation
  • LANSA working list services

Transport Services

  • Supported transport layers include MQSeries, SMTP, POP3, HTTP, HTTPS, SOAP, FTP and SFTP
  • JSM Direct HTTP service extension for inbound and outbound Web services, SOAP and user-defined B2B transactions
  • Supports EDI-INT (AS2 certified), AS3 and EDI
  • Supports secure SMTP email
  • Supports TCP/IP versions 4 and 6

Other Services

  • PDF services to create text and graphical PDF documents
  • SMS Service to send SMS messages via SMTP or HTTP
  • ZIP Service to create and extract archive files and directories

Database Support

  • IBM DB2 on IBM i (System i, iSeries, AS/400) servers
  • Microsoft SQL Server, MySQL, Oracle and Sybase on Windows servers
  • Oracle on Linux servers
  • Any ODBC or JDBC accessible database