R7 Development Tools - Enterprise Integrator - Cistech

musicincurableΔιαχείριση Δεδομένων

31 Ιαν 2013 (πριν από 5 χρόνια και 5 μήνες)

159 εμφανίσεις

Denise Luther

Senior IT Consultant


Practical Technology Enablement

with Enterprise Integrator

Denise Luther

Professional Experience

30+ Years in Information Technology

5 Years XA Experience

Software Design and Development

MAPICS Expertise

Enterprise Integrator Trainer

Technical Strategies for working with XA

Recent Customer Success


Implemented custom supplier
web portal using Enterprise Integrator and

My technical background in the
iSeries/XA environment allows

me to help IT professionals
implement new technologies for
continued business success .


Data Sources

Transaction Broker

Transaction Objects

Host Jobs and Reports

Header/Detail Relationships

Managing Environments

Add polish to your applications

Data Sources

Other Platforms

Files on another iseries

Files in another XA environment

Acquire drivers from the database provider

Place them in /MAPICS/driverlib

IFS directory where MAPICS is installed

They will work for all environments

Drivers are no
charge and can be

downloaded from the web

Data Sources



already installed


already installed

SQL Server

SQL Server Driver for JDBC


need 9i driver


need driver for JDBC3


Data Sources


Data Sources

SQL Drivers

Data Sources




[user ID]

Database owner

Data Sources

Display SQL Server

Views, subsets,

Full navigation

Navigation history


Code files

Graph cards

Compound cards


Column functions

Navigate to SQL Server table

SQL table from within an object

Show data in

Cards can be
external data


Transaction Broker

User Exit Code Generation

No source downloads

More control

More Exits


Exported with object

Enterprise Integrator extends these
advantages to your custom objects
(no more triggers)

Generate program

Compile program

Display Compile listing

User Exit Source

Transaction Objects

Transaction vs. object maintenance

Think IM transaction vs. Item Warehouse

Action on a menu

Like IM transaction…

Has own attributes separate from object

Has own logic separate from object

Can update multiple objects

Transaction Objects

Item Warehouse

Create, update or delete
an item warehouse

Logic applies to
database fields

RM Inventory Transaction

Data is not part of MO or

Warehouse objects

Where is


Logic is not part of an order

IM transactions have unique

Doesn’t make sense to include
logic in MO or Item Warehouse

Update applies to many

Transaction Objects

Need to be able to transfer inventory from
one location to another.

Allow user to select Item Location records by
subset or individual selection, enter the To
location, create TRDATA TW transaction
record and kick off the PMC process.

Secure this function and authorize selectively

Transaction Objects

Transaction Objects

Transactions card in object card file

Don’t select a maintenance ID, just click Create

Transaction Objects

Name entered will be default menu text

Transaction Objects

Card file like Business objects but is independent of

Standard actions


Used to send information to user exits


Edit to require entry for To Location


Provides search for location entry

User Exits

User exits structured like standard exits

User exit source to process the transfer

User Exits


code to create TW TRDATA record

User Exits


Send dataq to process transfer

User Exits

Select row(s) for transfer

Click the toolbar button to execute the transfer

Run Time

Popup will ask for Transfer To Location

Search provided to lookup valid location

Run Time

Enter or select location and click continue

User exits will process the TW transfer

Process from buffer runs from client

Run Time

Secure the action

To lock down this action independently of the standard
maintenance, Lock and authorize the Task/Subtask

Client Extension Object Security Area

Replacement for Program actions

Allows creating attributes

date sub

forces valid date entry

Discrete domain/Code files

Standard edits

Custom edits for error reporting

Default data generation

Search functionality (relationships)

Process from buffer user exit

code that would
normally in the program action host program

Object transactions

Host Jobs and Reports

Host Reports and Host Jobs are processes that are
invoked from the client to run on the host

Host Reports typically read data from the server and
print a report based on that data

PO Print

Host Jobs typically perform work that alters data on
the server

PO purge

Add custom Host Reports and Jobs to Business

Adding Host Reports

Select the Host Processes card and the Reports

Enter the name of the host report on the Create

Business Object Host Report prompt

This is the name that appears on the Host Reports tab

Adding Host Reports

Adding Host Reports

General card contains information about the
Host Report


Create “attributes” using the Attributes card

Appear as options when the user runs the Host Report


Standard Integrator

define simple edits on single


define Custom edits that will be processed by the
server using the Validate user exit


Enable the users to lookup values instead of
directly keying them

User exit programs can be generated and compiled like
user exit programs for other types of Business Objects

User Exits

Host Reports are executed from the Host Print
option on that object’s File menu

List of the available reports for that object

positioned alphabetically in the list of available

Attributes that were created in Integrator for the
report will show as options (currently in
alphabetic order) for the report

Name attributes to control order in run
time list

Host Reports

Host Reports

Host Reports


Same confirmation and email notification available

Adding a custom Integrator Host Job to a
Business Object is done in the same way
as a Host Report

Use the Jobs tab on the Host Process
tabbed card.

Attributes, relationships, and edits are
added in the same way as a Host Report

User exit programs are the same

Host Jobs

Host Jobs

Host Jobs

Host Job are executed using the Host Job option
on that object’s File menu

Host job will show up as one of the available
jobs for that object in alphabetic order

Attributes that were created in Integrator for the
report will show up as options, currently in
alphabetic order, for the job

Using Host Jobs

Using Host Jobs

Using Host Jobs

Business Object Host Reports/Jobs require some CAS
host records in order to correctly process transactions

Created and maintained automatically during a save to

Security authorization record to limit who has access to
run the custom Host function

Security class = ‘REPORT’ or ‘JOB’

Security category = EXTxxxxRPT (Host Report)

or EXTxxxxJOB (Host Job)

xxxx=extension for host process

Client Extension Object Security area of CAS Area

and task authorizations

Host Records

“Process buffer” user exit

Host process runs in batch

Transaction object runs in client

Process multiple records

Host process presents attributes (options) once

Transaction object presents attributes for each
selected records (like quick change)

time execution

Host process run from File menu option

Transaction runs from toolbar button

Host Process

Transaction Differences

Header/Detail Relationships

Special 1 to Many relationship

Create custom detail type relationships between user
defined header and detail objects

Copy transaction copies both header and details

Delete transaction deletes both header and

Locking header locks corresponding details

Allows detail objects to be created and validated
at the same time as the header

Transactions for changed detail objects include
changed header fields in TRNDTA for use with
user exits

Available for overview cards

Header/Detail Relationships

Primary object type

Transaction Broker/None Maintenance

Detail business object must have the same
keys in same order as the header, plus
any extra key fields

Header can have multiple detail business
object relationships


Project Tracking

Start project tracking from Enterprise Object

Maintenance Card

Maintenance History

Project Tracking

Create a project for each application or series of object

Project Tracking

Select a project each time you save to host

Maintenance history records tells what changed

Project tied to the maintenance

Project Tracking

Improved management for environments

Import/Export individual objects

Use subsets or selected records to limit export

Presentation Schemes, Attributes

Colors, Bold Fonts

Lower Case

Compound Cards

Combine multiple cards, views onto one card

Only contains what user needs to see

Customize Titles and Banners

Use appropriate icon and toolbar buttons

Thank You!

Technical Information




Sales Information

Ben McCormick