Enhance System Security & Integration with R7 Integrator and EI

1. R7 Integrator and Enterprise Integrator:You won’t believe this is XA… Deborah Vermillion, VP Consulting Services, CPIM, CIRM Belinda Daub, Senior Consultant Technical Services

2. You might be interested in R7 and Integrator/Enterprise Integrator if: • You would like to (or have to-SOX) improve the security of your system • You would like to integrate multiple systems on multiple platforms into a single user interface • You want a more proactive system- tell me what I need to know! • Your users like Microsoft Desktop applications, and you would like to integrate with them • You would like to use the web to communicate with customers, partners, and employees • You need the ability to enhance your system as your business needs change-and maintain an upgrade path

3. In other words… You need: • XA Release 7 • Integrator or.. Enterprise Integrator You need a: • Nimble • Flexible • Proactive • Open • Upgradeable System

4. Enterprise Integrator Features • Objects in Net-Link & System-Link • Security features • More databases • Advanced features • Web services • Publish & Subscribe

5. Agenda • New Security Features • Integrate data from non-XA and non-iSeries systems • System Link: Web Services to integrate MS Desktop applications • Proactive System Alerts • Demo

6. Agenda • Technical Advantages • User Exit Code Generation • Mass Program Actions • Import/Export individual objects • User Preference Administration • Integrator Projects and Maintenance History – manage and track your Integrator activities

7. 1. New security features • Auto content security • What records? • Deployment profiles • What objects? • Only takes a few seconds per user • Works for… • Net-Link • Power-Link • System-Link • Both internal and external users

8. Windows – List window

9. HTML – List window

10. Enterprise Integrator-Security layers • Object/field assumes everything authorized • Deployment Profile assumes nothing authorized UI What the user chooses to see Deployment Profile What is presented to the user Object security What user is authorized to Database All objects and attributes

11. Object list • Content • Object list • Content • Navigation • Object list • Content • Navigation • Maintenance • Object list • Content • Navigation • Maintenance • Fields • Object list Deployment Profiles

12. 2. Integrate data from other databases to XA • Make niche systems part of XA • Can see in Net-Link • Make Microsoft Office part of XA • Standard interface for other applications • Two-way communication with Excel • Access databases available to XA • All systems act like one • Internet is worldwide UI iSeries ERP Infor XA Office W S Quality System (SQL Server) Niche

13. Example: Quality System • SQL Server tables • Two quality tests for an item • Stress test • Heat test • Two files • Detail file • Trial date, time, user, result • Summary file • Test, # trials, minimum, max, avg

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

15. Navigate to SQL Server table

16. Navigate from iSeries objects to external objects • Native menus automatically reflect new choices • Consistent UI across platforms • Acts like one system to the user Navigate to SQL Server table

17. 3. With System Link You get web services…

19. Host edits, subscriptions…everything works

20. PO P012345 for $11,283.19 needs approval 4. Alerts • Via e-mail, phone or system message • Can also run a program ERP

21. Publish & Subscribe • Let the system notify you • You say when • You say how • Let’s show an example • Notify me when a PO amount exceeds $10,000 • Via e-mail and cell phone

22. Define the event • Choose the object • Define the type of maintenance

23. Define the event • Like a subset • Some new features • Before • After • Difference • % Difference

24. Flexible notification • Notify users • E-mail or cell phone • ‘Notify’ a program • RPG, XML or transaction

25. Notify via e-mail • Put in user and text message • Can include a hot link

26. Notify via cell phone • Call this cell phone • Display this message

27. Result • When a PO is entered or changed… • And the result is $10,000 or more... • Then send me an e-mail… • And send my boss a message to his cell phone

28. Integrator Demonstration

29. R7 Integrator – Technical Benefits • User Exit Code Generation - reduces development costs and schedules • Mass Program Actions – deliver easy-to-use applications to your users • Import/Export individual objects - Manage customizations across environments • User Preference Administration – provide and manage a consistent interface for your users • Integrator Projects and Maintenance History – manage and track your Integrator activities

30. R7 Integrator enhancements • Web URL user action • Multi-key code files • Auto logoff by user • No signoff for programmer • Unlimited objects

31. Generate program Compile program Display Compile listing 6-1. Reduce Development Costs and Schedules User Exit Code Generation • No downloads • More control • Consistency • Exported with object • Enterprise Integrator extends these advantages to your custom objects (no more triggers)

32. 6-2. Deliver Easy-to-use Applications Mass Program Actions • Call a program • Pass parameters • For all records selected • No more ‘one record at a time’ processing Your users will thank you • Example -

33. 6-3. Improved management for environments Import/Export individual objects • Use subsets to limit export

34. 6-4. Improved management for environments Manage user preferences • Initial cards, card files and tab styles • Open actions (what happens when you double-click) • View details • Change • Quick change

35. 6-5. Improved management for environments Integrator Projects and object maintenance history • Create Projects to track development activity • Each change is logged to a project • View history of project changes

36. Integrator Education:

37. Additional questions or comments? Thank you!!