sterling integrator map editor

Sterling Integrator Map Editor

Hello!I am Jeyhind MEDI Consultant

What is Sterling Integrator?

Sterling Integrator is the Sterling Commerce next generation end-to-end enterprise integration server. It is a Business process centric transaction engine for modeling and managing processes.

Sterling Integrator was built from the ground up to meet B2Bi needs, it provides:

#Simplified management#Consistent integration deployment methodology#Capability to model and deploy complex end-to-end Processes.#Retain or increase competitive position#Improve responsiveness


It addresses many Enterprise Integration problems such as :

#Slow response time, leaving customers dissatisfied.# Reliance on excessive manual processing, increasing costs and human error# Inability to adopt new standards, causing missed opportunities# Restrictive architecture of systems, limiting expansion.# While business managers struggle with these issues, IT Managers/Directors are also trying to streamline and improve business processes without incurring high expenses.


User Interfaces In GIS

The three main user interfaces used with Gentran Integration Suite are:

1. The Administration Interface/Dashboard Interface.2. The Gentran Integration Suite Map Editor.3. The Graphical Process Modeler


The Administration Interface shown below is a Web-based interface for System Administration


The Sterling integrator Map Editor is shown below. It is used represent the translation of one type of input data to a different type of output data.


The Graphical Process Modeler is shown below. It is used to represent a business process as a graphical model.


Map Editor

Sterling Integrator Map Editor:

# The Map Editor is a stand-alone Windows program that you download from Gentran Integration Suite.

# The Map Editor enables you to create maps (.mxl or .map) and compile them into either translation objects (.txo.) or XML encoder objects (.ltx).

#To translate data from one format to another, you must specify how the data in one format relates to data in another format.

#To relate one format to another for the translator, you must define a set of instructions in the Map Editor. These instructions indicate the relationship between the two formats.

What is Sterling Map Editor?

Installing the Map Editor from Sterling Integrator

1. Download the map editor from the suite. 2. Go to Deployment Menu select Maps.3. Down load of AI Mapper and Install.4. Next Download Map Editor (EN), click Go!

What is Sterling Map Editor?

Data Formats Supported by Sterling Integrator :

EDI Data format: EDI file as per the standard , agency and version

Positional Data format: A positional data format is also referred to as a fixed format or an application file

Variable –Length – Delimited Data format: Gentran Integration Suite enables you to map variable-length-delimited files, such as the comma-separated text file (.csv).

Data Formats in Sterling Integrator

CII data format: The CII data format provides the Japanese syntax definition for EDI messages.

XML data format: In the XML data format, the Gentran Integration Suite XML implementation confirms to the rules of the XML language .

SQL data Format: The Structured Query Language (SQL) data format enables you to create a map directly from a database schema

Data Formats in Sterling Integrator

The following table describes the map object icons in Sterling Integrator:

Components used in Map Editor

The following table lists the components that make up the positional layout in the Map Editor, the icons that represent the components, and descriptions of the components

Components used in Map Editor

The

Supported Data Types:

#Integer - A whole number with no decimal component #Real - A whole number with a decimal component #String - One or more printable characters#Date time - A date or time #Array - A table of multiple occurrences of a single data type #Objects - Implemented while invoking Java code or functionalities#Number

#Integer: Integer is referred as N and an N-formatted number has an implied decimal point. For example: 2.01 formatted as N2 is 201).

#Real: An R-formatted number has an explicit decimal point and truncates trailing zeros. For example: 2.123 formatted as R2 is 2.12 and 3.10 formatted as R2 is 3.1).

#Must also indicate the number of decimal places in the field.

Data Types in Map Editor

The

Integer: Integer is referred as N and an N-formatted number has an implied decimal point. For example: 2.01 formatted as N2 is 201).

Real: An R-formatted number has an explicit decimal point and truncates trailing zeros. For example: 2.123 formatted as R2 is 2.12 and 3.10 formatted as R2 is 3.1).Must also indicate the number of decimal places in the field.

Number Data Types

Overpunch : It is a signed numeric with implied decimal position. The Overpunch format specifies that the last digit represents the sign of the number and the number value. Overpunch signs are used in dollar fields to represent positive and negative dollar amounts without expanding the size of the field to hold a plus or minus character.

For example: The dollar field of $99.95 is represented as 999E with truncation. A negative dollar amount of $2.50 is represented as 25} with truncation.

Packed: Two digits are put ("packed") into each byte of storage, and thus each byte (except for the low-order byte) can contain two decimal numbers, thus halving the storage requirements. The low-order byte contains one digit in the leftmost position and the sign (positive or negative) in the rightmost position.

For example: Decimal 92 would be encoded as the eight-bit sequence 1001 0010). Normal character representation only stores one character (digit) per byte, so packed data only requires half the storage of character (unpacked) data.

Number Data Types

String: Represents text and If you specify that a field is a string field, you must also specify the format of the string.

Syntax token: It is data sub-type that applies only to string fields and can contain of one or more character ranges and single characters. You can also create special syntax tokens to meet your specific needs like to specify any special character occurrences in the text data

For Example: If a field with syntax token A assigned to it (character range A through Z and a through z) contains a number, the translator generates a compliance error. You specify that a field is a string and assign a syntax token in the Field, Element, or TFD Properties dialog box, on the Validation tab, in the data format field.

Number Data Types

Date: Contains a date and format should be specified.

For Example: YMMDD - Four-digit year, two-digit month, two-digit day (like: 20091015) MMDDYY - Two-digit month, two-digit day, last two digits of year (Like:

101509)

Time: Time field contains time value. you must also specify how the time value is formatted.

For Example: HH:MM:SS - Two-digit hour, separator, two-digit minutes, separator, and two-

digit seconds (Like: 03:30:45) HH:MM - Two-digit hour, separator, two-digit minutes (Like: 03:30)

Date & Time

Objects: Java objects use the data type object. Objects provide properties (data values that can

be retrieved or updated) and methods (functions that can be invoked to return a result). The object must be declared and then created using the new command, passing the full class name of the object and any constructor parameters.

Invoke an object's methods using the syntax: object.method(parameters)

Invoke an object's properties using the syntax: object.property

Objects

If then else :Can use the if/then keywords to run one or more statements conditionally.Conditions can be nested to any level.

if condition is true, runs all the statements that follow the then keyword. If the condition is false, none of the statements following then are run.

You can use the else keyword with if/then to define several blocks of statements, one of which is run.

Syntax:if condition then

begin statement1;

statement2; endelse begin

statement3;statement4;

end

Functions

While...do

#Function runs a statement repeatedly until specified termination condition evaluates to Zero.

#Gentran Integration Suite tests the terminating condition before each iteration of the loop, so a while loop runs zero or more times depending on the value of the termination expression.

#The begin function encloses a group of statements that form the body of a while...do loop.

#Can use the begin...end keywords to run one or more statements conditionally.

#If you include more than one statement in the body of a while...do loop, you must surround the statements with the begin...end keywords.

#If you use only a single statement, you can omit the begin and end

Functions

ntoa : The ntoa function is a numeric function that converts real numbers into strings. The numeric functions enable you to convert one data type to another.

Syntax :ntoa(real, string);where: real = real number variablestring = string variable

An example of this function follows:real b;string[20] s;b = 5.5;ntoa (b, s);

// "s" contains "5.5“

Functions

aton: The aton function is a numeric function that converts strings into real numbers. The numeric functions enable you to convert one data type to another.

Syntax: real = aton(string);

where: real = real number variablestring = string variable

An example of this function follows: real b; string[20] s; s = "5.5"; b = aton(s); // "b" contains the value 5.5

Functions

atoi: The atoi function is a numeric function that converts strings into integers. The numeric functions enable you to convert one data type to another.

Syntax:int = atoi(string);where: int = integer variablestring = string variable

An example of this function follows:integer a;string[20] s;s = "5";a = atoi(s);// "a" contains the value 5

Functions

Len : The len function is a numeric function that counts and returns the number of characters in a string. The numeric functions enable you to convert one data type to another.

Syntax: number_char=len(string);

where: num_char = integer variable An example of this function follows:

integer a; a = len("hello"); // "a" contains the value 5

Functions

Mid: The mid function extracts from a specified position in a string, either to the end of the string or for a specified number of characters, and returns the resultant string. This function is zero-based.

Syntax : string _variable = mid(string_variable,start_pos,num_char)

where: start_pos = integer variable num_char = integer variable

Example: string [25]name;

string [10]temp_ variable; name = "Acme Shipping Company" temp_variable = mid(name,5,8);

//The map will read 8 characters in the string, starting with the character 6. // "temp_variable" will contain "Shipping"

Functions

Various Kinds of maps in Sterling Integrator

# Standard (X12) to Application

# Application to Standard (X12)

# Database to Database

# Standard to Database

# XML to Application

# Application to XML

Various Kinds of maps in SI

Session Rules: Used to declare the variables and initializing the variables.There are two types of Session Rules:

Pre-Session Rules: The rules that are executed before the translation session. The rules which are used only when we want to declare any variables.

Click on the Edit Session Rule on the rule bar

Post-Session Rules: The rules that are executed after the translation session. The rules which are used only when we want to declare any comments.

Mapping Instructions and Rules in SI

Standard Rules: Standard Rules give you access to mapping operation functions that are more complex than simple linking but less complex than extended rules.#Use System Variable#Use Constant#Use Accumulator #Loop Count#Use Code #Select#Update - In that Goto Standard Rule Tab and Select the Standard rule

Standard Rules in SI

Use System Variable: The System Variable standard rule enables you to set a variable that map the current date and time to the selected field. The selected map component must have a data type of Date/Time.

Use Constant : Constants are used in maps to hold information that is needed later in the map, either for an output field or a conditional statement. Typically, constants move a constant value to the specified field or generate qualifiers (to indicate a qualifying relationship with another field). Typically, constants are used to load common data into each positional record on a map. You create the constant and name it. You can hard code (type) a value that is loaded into the field that uses the constant.

Use Accumulator :The Use Accumulator standard rule gives you access to a set of numeric variables that you can manipulate using numeric operations, and then transfer to and from fields. This rule enables you to add, change, or delete calculations for the field, including hash totals (used to accumulate numeric field values such as quantity and price).


Select : The Select standard rule enables you to associate a field with a trading partner code list, a section in process data, a document envelope, the Gentran Server for UNIX synonym table by in and out values, and use the transaction register function.

Update: The Update standard rule enables you to move data from a field in the map into process data, to update process data so that the data can be used elsewhere in the business process, to record document-specific parameters during translation, and to check for duplicate data.


Extended Rules: Extended Rules will be written for handling specified code, more functionalities and to handle temporary segment rules and data.

Use of Extended Rules:#Populate temporary storage records#Add Conditional logic in a map#Perform Arithmetic Calculations#Assign and retrieve values to and from variables

Indexing: An index is a number that is used within an extended rule only when referencing a field contained by a repeating record or group. This number is used to specify the exact occurrence (iteration) of the repeating group or record that you want the translator to access

Format: $Group Name[index1][index2].#Fieldname.

Extended Rules in SI

Right Click on the Group or required filed to implement Extended Rule

Extended Rules in SI

When to Use Temporary Records and Fields:You create Temporary storage records so that a one-to-one relationship can be made

between the elements contained in segments and fields located on the opposite side of the map. Creating temporary storage records is similar to adding map components to the map. The difference is that the tag you provide will contain a character combination that will never appear in the data.

The Input data is looping and the expected data occurs only once. A repeating map component is mapped only to a single map component. The hierarchical level in the document does not match the output hierarchical level

Temporary Rules in SI

X12 Mapping in Sterling Integrator

Right Click on

ANSI X12 Maps:

1. Create a inbound map

2. Source side as X12 format of 835 transaction and Version 4010

3. Target structure is the Flat File structure ( Positional Structure)

4. Demonstrated Session rules, Standard rules and Extended rules

5. Creating Temporary segments

6. Compile and Run the map

7. Create a Inbound map to translate a 835 message in X12 format to Application format

X12 Mapping in SI

1. Source side specifies the data format and standard as EDI X12.2. Click on message type and select the required 835 version

X12 Mapping in SI

1. Go to AI Mapper → Click file → New Map → Go 2. Specify the map name and your company name

X12 Mapping in SI

1. Select the appropriate version and the Transaction set

X12 Mapping in SI

1. It opens to a map window with both source and target side. We have to create a target positional DDF.

X12 Mapping in SI

1. Create a Target Group by right click on root node 2. Name the group and go to next tab →

X12 Mapping in SI

EDIT the fields 1. Right Click on the group → Goto and click EDIT FILED 2. Specify the Name, Description, Data type of the elements

X12 Mapping in SI

Finally map with both source and target ddf's

X12 Mapping in SI

How to Compile a Map :#Save the map with “.map” as preferred #Compile the map #Check the translation report #Recompile #Run the map

For Compiling the Map Click on the compile button

Map Compilation in SI

Give the following details like user name ,password , Translation Object and Data file

How to Run the Map

If the mapping report has no errors then it will show like this

How to Run the Map

Thanks!Jeyhind M EDI ConsultantYou can find me at:

◇ https://in.linkedin.com/in/jeyhindm

https://in.linkedin.com/in/jeyhindm

https://in.linkedin.com/in/jeyhindm

sterling integrator map editor

Documents