Data integration software that connects
applications and businesses
LANSA Integrator simplifies exchanging data between applications and transferring files and documents between
businesses. It enables bi-directional flows of data and/or files in almost any format including XML, text, image, email, PDF,Microsoft Excel, EDI X12 and EDIFACT.

What can Integrator do?
LANSA Integrator is strategic middleware that provides tools andservices to enable:• Application-to-application data exchanges.
• Business-to-business document transfer and data interchanges.
• Automating manual data integration processes.
• Simplified data integration solution design and reduceddevelopment effort.
Integrator provides the data transformation, transport services andinfrastructure that can assist developers to build integration solutions.
It simplifies integration design by providing the tools needed to receive,
extract, transform, and send data. Developers only need to define thedata, the transformation rules and choose a data transport. Integrator
takes care of the detailed work that ensures the data is in the desired
format and reaches its destination successfully.
Integrator supports multiple data formats, including XML, EDI, text,
video, SMS, email, Microsoft Excel workbooks, PDF files and relational
databases. It includes services for data transformation, communications,email, messaging and Web services, complemented by interface tools
and utilities.
Developers can use these services in their integration applications
to transform data from one format to another. It supports multiple
data transport methods to move the data including HTTP, FTP, SFTP,
Web services and message queue software. Any application can callIntegrator’s services using simple APIs.

A flexible solution
Some of your customers, suppliers or partners may mandate the use ofXML or EDI to exchange data; others may use more generic formats likespreadsheets or text files. Integrator’s flexibility allows you to choose
from an array of many formats to satisfy any data transformation andintegration requirements.

Integrator’s services for transforming and transporting data make it
the “Swiss Army Knife” of data integration. When developers confront
a situation requiring data exchange and/or transformation there is an
Integrator service that can simplify the task.
Examples of how you could use Integrator:• Send orders as XML, text, email and an EDI format to amanufacturer automatically.
• Transfer files securely from desktop or laptop computers to remoteservers.
• Send data from a mobile device to an application running on aserver.
• Generate SMS text messages to a mobile device describing thestatus of orders or deliveries in real-time.

Overcome the challenges• Connect a Java-based credit card application to an order entrysystem.

Integrating data and applications across diverse platforms typicallyrequires complex technologies like XML, Java, C# etc. LANSA Integrator
includes multiple services that simplify application-to-application andbusiness-to-business integration. In addition, integration is automatedfor Java programs that are required for business logic.

• Integrate back-office applications using data formatted as XML andsent via IBM WebSphere MQ messaging services.

LANSA Integrator eliminates the need for developers to learn thesetechnologies and provides a productive environment for integrating data
between diverse applications, computing platforms and businesses.

• Provide Web service interfaces to existing line-of-businessapplications.

How can you use Integrator?
LANSA Integrator provides a productive toolset for data integrationbetween applications and sending data to/from customers, suppliers
and partners. It includes services that developers can use to manage
integration interfaces, call upon communications protocols andtransform data from one format to another.

• Provide PDF documents, secured with digital certificates andpassword protected, sent via email for contract negotiations andagreements.

• Send procurement documents to suppliers and receiving
acknowledgements from suppliers.
• Receive a text file via FTP, converting it to a PDF and sending thePDF as an email attachment.

Email andTransportFile Transfers

Excel, PDF, ZIP,
File Management

SQL, RFI, LDAP.
File System Access

POP3, SMTP,
HTTP/HTTPS,FTP, FTPS, SFTP (SSH)

EDIINT, AS2/AS3,FTP, HTTP

Messaging

Web Services

Extensions

XML Services

Message Queues,
JMS Interface, SMS

JSON, REST,
SOAP, XML

Customer and/or
Custom Build
Services

Read/Write, Parse,
Validate, Stream,
XSL, XSLTINTERFACE
TOOLS

Data AccessInterface APIsUTILITIESSERVER COMPONENTS AND SERVICES

Documents
and Files

User Agent

Administration

Deployable File
Transfer Utility

Integrator Studio,
Tracing, Logging

Java Service Manager (JSM)

APIs, Built-inFuctions: RDML,RDMLX, RPGLANSA Integrator Server Components, Services, Interface Tools and Utilities

FeaturesDocument and file services

Summary• APIs and built-in functions for Visual LANSA and RPG developers• File management (move, copy, delete)• Ready-made services for application-to-application integration• PDF service to create text and graphical PDF documents• Services for enabling business-to-business integration• Multiple data transformations• Extensible service catalogue – extend supplied services withcustomer-built services• XML and EDI document parsing, generation and transformation• Real-time and batch data integration and document exchange• ZIP service to create and extract archive files and directories
Email services• Send and receive email messages (POP3 and SMTP)• Email attachments
Web services• Real-time and batch file transfer• REST, SOAP and XML Web services• Event monitoring and trigger capabilities• Supports JavaScript Object Notation (JSON)• Deployable file transfer utility (User Agent) for uploading files toremote servers
LANSA Integrator architecture• Integrator’s Java Service Manager manages interfaces andmarshals services

XML services• Automatically generates XSL style sheets for data transformation(XSLT)• Embedded XML parser with XML editor• Fast and scalable multi-threading in a single Java Virtual Machine• Visual XML Wizard maps XML schemas and XML documents toLANSA and 3GL program data structures• Integrator Studio (property editor and management tools)• Read, write and parse XML• Secure communications (e.g. HTTPS, SFTP, TLS and SSL)

• Supports streamed XML• Extensive tracing and logging for debug and audit• Validate XML documents using DTD and XML schema• LANSA Repository for metadata management
Data access services• Access data using SQL from ODBC or JDBC databases including
DB2 on IBM i, Microsoft SQL Server, Oracle, Sybase, and MySQLTransport services• Transport services include HTTP, HTTPS, FTP, SFTP, SMTP, POP3and messaging software• JSM Direct HTTP service extension for Web services• File formats include CSV, TSV and TXT• EDIINT AS2, AS3 and EDI• Microsoft Excel workbooks• Secure SMTP email• LANSA working list services• TCP/IP versions 4 and 6• Remote function invocation for Java developers• Supports ASC X12 and UN/EDIFACT EDI file formats and Standard
Exchange Format Editor• Handles data encoding Unicode, ASCII and EBCDIC• Manages multiple clients with different encoding and locale
information simultaneously
Message services• Messaging interfaces support ActiveMQ (Apache), SonicMQ(Progress Software), Rendezvous (Tibco), WebLogic JMS (Oracle)
and WebSphere MQ (IBM)

Database support• DB2 on IBM i servers• Microsoft SQL Server, MySQL, Oracle and Sybase on Windowsservers• Oracle on Linux servers• JDBC accessible databases
IBM i specific services• Native services support data queues, message queues and user
space communications• Read and write documents stored in the Integrated File System• Supports Java Message Services API• Send SMS text messages via SMTP or HTTP

Visit www.lansa.com for more information

THE AMERICAS
Headquarters – Chicago, USA
Tel:+1 630 874 7000
Email: info@lansa.com
A4-20.05.16

EUROPE
Headquarters – London, UK
Tel:+44 1727 790300
Email: info@lansa.co.uk© 2016 LANSA. All rights reserved. All marks are the property of their respective owners.

ASIA PACIFIC
Headquarters – Sydney, Australia
Tel:+61 2 8907 0200
Email: info@lansa.com.au