XOG GEL Scripting

Generic Execution Language (GEL) is a tool that you can use to turn XML into executable code. GEL has been extended and embedded into cappm to enable custom logic to solve complex business problems not already addressed by the out-of-the-box product.
ccppmop153
Generic Execution Language (GEL) is a tool that you can use to turn XML into executable code. GEL has been extended and embedded into 
Clarity PPM
 to enable custom logic to solve complex business problems not already addressed by the
out-of-the-box
product.
As an enterprise application integration framework within 
Clarity PPM
, GEL provides a collection of standard integration libraries that provide connectors to enterprise applications including Finance, HR, and General Ledger. Popular integrations have included BMC Remedy Help Desk, CA Service Desk, ServiceNow, SAP, Oracle, and Workday. GEL scripts are used in many additional third-party integrations.
With GEL, you can invoke and process various data sources:
  • Web services:
     Read or write to any SOAP-based web service, including the XOG web services.
  • File system:
     Read or write to any delimited file including those on local disks, network disks, or disk arrays.
  • FTP:
     Upload or download to FTP servers.
  • JDBC:
     Leverage JDBC to access relational database systems to read or write data.
: GEL is based on Jelly, a jakarta.apache.org Commons project.
: Until you upgrade to 15.5.1, avoid creating GEL scripts that attempt to read, run, or append records in very large CSV files. Out-of-memory errors and application outages can occur. 
Video: GEL Webinar
The following third-party video is provided by IT-ROI. This video is provided by CA Technologies “AS IS” and without warranty.

To play this video in full screen mode, click the YouTube logo. 
Before you use GEL, read the
Customization, Modification, and Configuration Policy
that is available in this documentation. For more information, search for
Customization
. Also, contact your CA account representative.
Video: How to Update a Field Through a GEL Script
The following third-party video is provided by Rego Consulting. This video is provided by CA Technologies “AS IS” and without warranty.

To play this video in full screen mode, click the YouTube logo.
GEL Setup
The GEL run-time is packaged with XOG in the XOG client. Once the client is installed, you can use the GEL command in the 
bin 
directory of the XOG client to validate and execute GEL scripts. Make sure that the JRE is installed on your computer.
GEL Script Validation and Execution
The GEL validator reads scripts, confirms that the scripts are well-formed XML, and determines that all referenced tags and tag libraries are valid and are available in the runtime environment. The validator does not execute scripts. In this example, the hello.xml script is first validated, and then the hello.xml script, which is located in the XOG client home directory, is executed.
E:\XOG>bin\gel -script hello.xml -validate File geltest.xml validated. E:\XOG>bin\gel -script hello.xml Hello World 1! Hello World 2! Hello World 3!