Denise Luther Senior IT Consultant denise.luther@cistech

1. Practical Technology Enablementwith Enterprise Integrator Denise Luther Senior IT Consultant denise.luther@cistech.net

2. 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 • Saia-Burgess – Implemented custom supplier web portal using Enterprise Integrator and System-Link My technical background in the iSeries/XA environment allows me to help IT professionals implement new technologies for continued business success .

3. Agenda • Data Sources • Transaction Broker • Transaction Objects • Host Jobs and Reports • Header/Detail Relationships • Managing Environments • Add polish to your applications

4. Data Sources • Other Platforms • Files on another iseries • Files in another XA environment

5. Data Sources - Drivers • 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

6. Data Sources - Drivers • iSeries – already installed • Access – already installed • SQL Server – SQL Server Driver for JDBC • Oracle – need 9i driver • PostgreSQL – need driver for JDBC3 Platform

7. Data Sources – SQL Drivers

8. Data Sources [dsh]:[port] Database Database owner [user ID] [Password]

9. Data Sources

10. Views, subsets, sorts Full navigation Navigation history Workbenches Code files Graph cards Compound cards Attachments Column functions Display SQL Server

11. Navigate to SQL Server table

12. SQL table from within an object • Show data in context • Cards can be external data sources • Drill-down capability across platforms

13. Generate program Compile program Display Compile listing Transaction Broker User Exit Code Generation • No source downloads • More control • More Exits • Consistency • Exported with object • Enterprise Integrator extends these advantages to your custom objects (no more triggers)

14. User Exit Source

15. Transaction Objects • Transaction vs. object maintenance • Think IM transaction vs. Item Warehouse maintenance • Action on a menu • Like IM transaction… • Has own attributes separate from object • Has own logic separate from object • Can update multiple objects

16. Item Warehouse Maintenance Create, update or delete an item warehouse record Logic applies to database fields RM Inventory Transaction Data is not part of MO or ItemWarehouse objects Where is Quantity stored? Logic is not part of an order object IM transactions have unique edits Doesn’t make sense to include logic in MO or Item Warehouse maintenance Update applies to many objects Transaction Objects

17. 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

18. Transaction Objects

19. Transaction Objects • Transactions card in object card file • Don’t select a maintenance ID, just click Create

20. Transaction Objects Name entered will be default menu text

21. Transaction Objects Card file like Business objects but is independent of Standard actions

22. Attributes Used to send information to user exits

23. Edits Edit to require entry for To Location

24. Relationships Provides search for location entry

25. User Exits User exits structured like standard exits

26. User Exits User exit source to process the transfer

27. User Exits AftEXT0043TXN – code to create TW TRDATA record

28. User Exits CLOFIL – Send dataq to process transfer

29. Run Time Select row(s) for transfer Click the toolbar button to execute the transfer

30. Run Time • Popup will ask for Transfer To Location • Search provided to lookup valid location

31. Run Time • Enter or select location and click continue • User exits will process the TW transfer • Process from buffer runs from client

32. Secure the action To lock down this action independently of the standard maintenance, Lock and authorize the Task/Subtask Client Extension Object Security Area

33. Object transactions • Replacement for Program actions • Allows creating attributes • date sub-type – 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

34. 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 Objects

35. Adding Host Reports Select the Host Processes card and the Reports sub-card

36. Adding Host 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

37. Adding Host Reports General card contains information about the Host Report

38. Attributes • Create “attributes” using the Attributes card • Appear as options when the user runs the Host Report

39. Edits • Standard Integrator - define simple edits on single attributes • EI - define Custom edits that will be processed by the server using the Validate user exit

40. Relationships Enable the users to lookup values instead of directly keying them

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

42. Host Reports • 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 reports • 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

43. Host Reports

44. Host Reports

45. Email Same confirmation and email notification available

46. Host Jobs • 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

47. Host Jobs

48. Host Jobs

49. Using 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

50. Using Host Jobs