ISM Manual
  • Overview
  • Features
  • Components
  • Directory Structure
  • Startup/Shutdown
  • ISM Admin UI
    • Dashboard
    • Flow
    • Job
      • Schedule
    • Channel
      • AMQP
      • Mqtt
      • sFTP
    • Interface
      • System
      • Data Structure
      • Field Group
      • Field
    • Web Service
    • Utility
    • Admin
    • Result
  • Tasks
    • Control Task
      • Route
      • Split/Join
      • Mapping
    • FTP
      • FTP Input
      • FTP Output
      • FTP Transfer
    • DB
      • SQL Executor
      • SQL Batch Executor
    • File
      • File Input
      • File Output
      • File Validator
      • Record Extractor
    • Excel
      • Excel Reader
      • Excel Writer
    • Flow
      • Flow Execution
      • Wait Sub
    • Web Service
      • REST Client
      • Web service Client
    • PGP
      • Encrypt
      • Decrypt
    • Cloud
      • SharePoint
      • Amazon S3
      • Google Cloud Storage
    • Others
      • Email Sender
      • LDAP Client
      • Function
      • Script
      • Java Class
  • REST Service
  • Trouble Shooting
  • Logging Configuration
  • Implementing a Task
  • Custom Class
  • Frequently Asked Questions (FAQ)
    • What is XNARUM Integration Service Mastery (ISM)?
    • What is the purpose of XNARUM?
    • Can XNARUM be customized to specific integration requirements?
    • Is XNARUM scalable?
    • Does XNARUM provide support and maintenance?
Powered by GitBook
On this page
  • SQL Executor
  • File parser
  • JavaScript
  1. ISM Admin UI

Utility

PreviousWeb ServiceNextAdmin

Last updated 1 year ago

SQL Executor

This utility is useful when you cannot access the target database directly through RDBMS GUI tools. This tool does not provide many functions. Only queries can be executed.

You can execute multiple queries and can commit the C/U/D operations.

Queries are delimited by semi colon (;).

Desc(ribe) query is available. The query below displays the layout and column information of the table.

desc(ribe) table_name;

The results are displayed in separate tabs.

If any C/U/D query is included and commit is checked, then the queries are committed.

The first database listed is ISM repository database.

File parser

File parser is used to parse a file and download a file from (s)FTP server and parse the file data with data structure.

1. Connect to the (s)FTP server.

2. Double click the target file.

3. Download the file. Downloaded file is displayed in the text area.

4. Choose data structure.

5. Click parse button.

The parsed contents are displayed at the bottom.

No error message means this file is successfully parsed.

JavaScript

Write functions and click execute button, then the last function(until JDK 1.8) is executed.

The JavaScript menu allows users to write and execute custom JavaScript functions that can be used in pipeline designs or tasks. The detailed information how JavaScript menu works is .

here