810 likes | 824 Views
Improve system security, integrate multiple systems into a single user interface, proactive system monitoring, integrate with Microsoft Desktop applications, web communication with customers/partners/employees.
E N D
R7 Development Tools 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 • 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
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
Example: Item Warehouse We want to restrict this user to warehouse 1 only.
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
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
Object list • Content • Object list • Content • Navigation • Object list • Content • Navigation • Maintenance • Object list • Content • Navigation • Maintenance • Fields • Object list Deployment Profiles
Enhanced Security for XA • Security Modeling and Planning • Advanced Analysis and testing • Routine Auditing and reporting
PO P012345 for $11,283.19 needs approval Alerts – Integrator Subscriptions • Via e-mail, phone or system message • Can also run a program ERP
Define the event • Choose the object • Define the type of maintenance
Define the event • Like a subset • Some new features • Before • After • Difference • %Difference
Flexible notification • Notify users • Email or Cell phone • Notify a program • RPG, XML
Notify via e-mail Substitute Email from vendor object as To address
Data Sources • Other Platforms • Files from another iseries • Files in another XA environment
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
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
Data Sources [dsh]:[port] Database Database owner [user ID] [Password]
Views, subsets, sorts Full navigation Navigation history Workbenches Code files Graph cards Compound cards Attachments Column functions Display SQL Server
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
See outside data from within an object • Show data in context • Cards can be external data sources • Drill-down capability across platforms
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)
Deliver Easy-to-use Applications Mass Program Actions • Downloadable sample code and instructions are provided • Pass parameters including dynamic token • Program will process all selected records or records within the current subset • Use when standard mass change will not handle your requirements
Improved management for environments Import/Export individual objects • Use subsets or selected records to limit export
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
Object transactions • Better way to do Program actions • Requires EI • Transactions Card in Integrator • Parameters defined as attributes • Edits • Default generation • User Exits
Object Transactions • Attribute (Number of copies) is required entry • User Exit calls the print program
What is System-Link? • Program to program interface between XA and other systems. • Inquiry/Maintenance • Replacement for offline load • XML • Other ERP systems • Other platforms • Part of Power Architecture • CSM, PM, OBPM, EPDM, MM… • CO’s, PO’s, MO’s, Engineering…
Why use System-Link • Any object available in Power-Link can be loaded • Only certain files are available for offline load • System-Link has a standard interface • Every application is a different flavor of offline load • Secondary objects can be loaded • Extra fields defined by user • Non-XA Primary objects can be loaded • Add, Change and Delete are supported • Power-Link edits are enforced • Including user defined edits
Why use System-Link • System-Link handles: • Database files and fields • Logical fields • Business rules • Editing • Security • You also get Release Transparency • No worries about release upgrades
System-Link References • System-Link User Guide – Release 7.7 • Download from Infor website • Documentation • Product Manuals • Miscellaneous • SYSL • System-Link Installation Instructions R7 • Configuring WAS 5.0 Express on W2K for System-Link R7 (SH14777) Servlet information
Managing System-Link • Use Link Manager to manage System-Link processes By environment By machine Distribute server load across resources
Managing System-Link • System-Link processes must be started • Autostart System-Link • Options at environment level
Methods to connect • System-Link Simulator • Use for testing/troubleshooting • To web server via XML • Web pages – Java/HTML • Directly to System-Link via LPI • RPG/CL programs • Web Services • Anything Microsoft-enabled • Requires Enterprise Integrator • IBM’s WebSphere MQ • Global enterprises • Requires IBM products
System-Link Simulator URL points to your host server
Using System-Link Simulator • Navigation/System-Link request • Not required to create System-Link requests but it makes the job easy • Display PO’s for vendor 100 – Restricted List, navigate from Vendor object