• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • LANSA Teaches BPI Tool New SQL, Web Services Tricks

    June 3, 2014 Alex Woodie

    IBM i is a wonder of automation. Many of the tasks that require manual effort on other systems are handled “autonomously,” to use a word from the last decade. The folks at LANSA have long been advocates for a higher state of automated being on the IBM i platform, and the company takes it to new heights with the latest release of Composer, its business process integration (BPI) tool for IBM i and Windows.

    LANSA Composer is a chimera that combines a drag-and-drop development interface with a data integration engine to help automate manual processes. Examples of these processes include navigating enterprise applications, searching for the right files, and distributing files via various protocols. For IBM i and Windows shops that are light on programming staff, or whose programmers are slammed with other projects, LANSA Composer provides an alternative path to get stuff done.

    With version 5, LANSA is adding a number of new features that will increase the power and productivity of Composer users. First and foremost is the capability to execute ad-hoc SQL statements against remote databases. Obviously, care must be taken when bypassing an application and accessing a database directly via SQL. But in some circumstances, it’s the best way to get results in the shortest amount of time.

    LANSA product architect Hugh Vaughan says the new SQL functions will give Composer customers another way to get to the data. “Typically in LANSA Composer, most database activity is accomplished through the use of Transformation Maps,” Vaughan tells IT Jungle via email. “However, these new activities provide another option for performing limited database query and update operations on a SQL database. In addition, they provide a means of invoking SQL stored procedures in the target database.”

    While these activities may not typically be used for bulk database query and extract, Vaughan believes they will often complete the last mile of integration–those small simple steps that otherwise might require the involvement of a developer to write program code. “That is to say, they provide the business analyst with more tools to complete all the aspects of a BPI task without programming,” he says.

    There are many places where Composer’s new SQL capability will come in handy, according to Vaughan. For example, consider the case of a company that needs to send an order acknowledgement via email after receiving an order. “In order to send an email order acknowledgement, it needs to query the customer file in the database to get the designated sales order contact email address,” he says. “The SQL database activities will permit this simple query to be quickly and efficiently performed and the order acknowledgement to be sent without the need to write program code.”

    In this scenario, the sales order process will use a traditional Transformation Map to write the in-coming sales order details to the received orders database. “But then, as the sales order progresses through various stages such as validation, inventory checking, credit checking, and so on,” Vaughan says, “there is a need to update a status flag in the received order database. The SQL database activities again provide the capability to perform this simple database update quickly and efficiently.”

    LANSA added a total of 12 new pre-built database activities in addition to direct database access, including the capability to create a text file from query results (CSV); the capability to set parameters on queries; new commit and rollback features; and the (previously mentioned) capability to execute stored procedures associated with a database.

    Version 5 also brings several new message-oriented activities that will help Composer users build long running processes where interactions are asynchronous. This includes new features that automatically monitor for the arrival of messages in message queues, or files or documents in a file system.

    This release also includes “design recommendations that will help optimize the behavior of long-running processes.” This will be particularly useful when designing applications that move data among mobile, desktop, and server applications, the company says.

    Composer also gets several new XML- and Web services-related functions with version 5. This includes a new SOAP Web service interface for invoking LANSA Composer BPI solutions from external sources (i.e. other Web services reaching into Composer). Previously, the product supported the capability to invoke SOAP Web services that were external to it (i.e. reaching out of Composer to other Web services).

    Composer was also enhanced to selectively interrogate values contained in XML documents using XML Path Language (XPath) expressions. “The activity is intended for selective interrogation of a limited number of particular values from the XML document,” LANSA says. A new XML_VALIDATE activity verifies that the XML document is well-formed and conforms to a DTD or an XML schema, the company adds.

    New options as part of its event notification service were also added. With this release, the system can be configured to kick off an email, send an SMS message, place a message on a data queue, run a processing sequence, or execute a function as a response to other events. Version 5 also brings new audit trail events to go along with persistent logging of export, import, and database housekeeping tasks. The user interface has also been spruced up and is more responsive, the company says.

    RELATED STORIES

    LANSA Bolsters BPI Tool with New Transaction Framework

    LANSA Adds Refinements to BPI Product

    Terminix Overcomes Hurdle to New B2B System, Thanks to LANSA

    LANSA to Deliver Code-Less Business Process Integration for SMBs



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Raz-Lee Security

    iSecurity Multi Factor Authentication (MFA) helps organizations meet compliance standards and improve the existing security environment on IBM i. It requires a user to verify his identity with two or more credentials.

    Key Features:

    • iSecurity provides Multi Factor Authentication as part of the user’s initial program
    • Works with every Authenticator App available in the Market.

    Contact us at https://www.razlee.com/isecurity-multi-factor-authentication/

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    BCD:  June 5 Webinar: RPG Open Access in Presto Gives You More Modernization Options
    CloudFax400:  Moving to an IBM PureSystems™? You need our cloud-based enterprise FAX service.
    Remain Software:  IBM i Application Lifecycle Management freedom and flexibility

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    IBM Gooses FlashSystem With Skinnier Flash, Faster Ports Thanks For The Cheaper, Faster Memories

    Leave a Reply Cancel reply

Volume 14, Number 12 -- June 3, 2014
THIS ISSUE SPONSORED BY:

SEQUEL Software
Maxava
Manta Technologies
Remain Software
Shield Advanced Solutions

Table of Contents

  • LaserVault Goes SCSI with New Backup Device
  • Italian Stock Exchange Protected by Maxava
  • Calling the Shots with Flash, Disk, and Tape
  • BCD Spruces Up Web and Doc Management Tools
  • IBM Helps Users Find i Needles in CMOD Haystack
  • Textile Manufacturer Gets EDI Help from Robot
  • Halcyon Fills the ‘Missing Link’ with Interactive Job Log Monitoring
  • Jinfonet Adds Geo Analysis to Reporting Software
  • LANSA Teaches BPI Tool New SQL, Web Services Tricks
  • DSI Targets IBM i Shops with VTL Solutions

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11
  • You Ought To Be Committed
  • Thoroughly Modern: What You Need to Know About IBM i Security
  • Spring Brings Events To IBM i Community, And More
  • As I See It: AI-AI-O
  • IBM i PTF Guide, Volume 25, Number 10

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle