1 / 56

R7 Integrator and Enterprise Integrator : Look at everything you can do with XA!!!

R7 Integrator and Enterprise Integrator : Look at everything you can do with XA!!!. Denise Luther, Senior Consultant Technical Services. 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

ianthe
Télécharger la présentation

R7 Integrator and Enterprise Integrator : Look at everything you can do with XA!!!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. R7 Integrator and Enterprise Integrator:Look at everything you can do with XA!!! Denise Luther, 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. 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

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

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

  7. Auto Content Security-What Rows • Special attribute classes are assigned • On-the-fly security subsets based on values assigned to a user • Global across all objects • User can be setup to view all warehouse data but only allowed to maintain data in certain warehouses

  8. Example: Item Warehouse We want to restrict this user to warehouse 1 only.

  9. User Profile Object

  10. The subset is still (all records) i.e., all the records this user is authorized to. They can still subset from here. Using a security subset Only warehouse 1 records appear in the list

  11. Deployment Profiles • 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

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

  13. Security for: Powerlink

  14. …and Security for: Netlink (External, too)

  15. Enhanced Security for XA • Security Modeling and Planning • Advanced Analysis and testing • Routine Auditing and reporting

  16. Integrate data from other systems 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 • Integrate systems to act like one • All can be deployed to Internet XA R7 Office W S Quality System (SQL Server) Niche

  17. Data Sources

  18. Data Sources - Drivers You must acquire drivers from the database providerPlace them in /MAPICS/driverlib IFS directory where MAPICS is installed They will work for all environmentsDrivers are no-charge and can be downloaded from the web

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

  20. Data Sources - Drivers

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

  22. Data Sources

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

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

  25. Navigate to SQL Server table

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

  27. See outside data from within an object • Show data in context • Cards can be external data sources • Drill-down capability across platforms Now that’s integration!

  28. System-Link • Security • Accessibility • Web Application HTTP • WebSphere MQ • Local Program Interface (LPI) • The new offline load • Infor ESB • Web Services

  29. Web Services Example • MS Excel Worksheet containing pricing data • A button on the worksheet sends data to an XA Pricebook • XA edits the data • Accepts some • Rejects some • Error messages are returned

  30. Prerequisites • On the server… • Enterprise Integrator • System-Link • On the client… • Microsoft Office • Microsoft Office XP Web Services Toolkit 2.0

  31. Deployment Profile Generate Web service Catalog

  32. Deployment Profile Setup

  33. Steps in Excel • Search for web services • Tools => Macros => Visual Basic Editor => Web Service References • Enter the URL from the deployment profile • Add two services • PriceBookBasePriceSvc • SystemOperations • Import sample code (File => Import File) • ExamplesCode.bas • MAPICSLogonPrompt.frm

  34. Price Book version before

  35. Price book version after Host edits, subscriptions…everything works

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

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

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

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

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

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

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

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

  44. 5. 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

  45. R7 Integrator enhancements • Web URL user action • Multi-key code files • Auto logoff by user • Unlimited objects • Host jobs and reports

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

  47. User Exit Source

More Related