Transcript Presentation Title
Practical Technology Enablement with Enterprise Integrator
Denise Luther Senior Consultant, Technical Services [email protected]
Auto Content Security • Special attribute classes are assigned • One time security subsets based on values assigned to a user – Global across all objects • User can be setup to view specific or all warehouse data but only allowed to maintain data in certain warehouses
Auto Content Security
Auto Content Security Turn Maintenance on or off by warehouse Assign warehouse values for this user
Using a security subset
They can still subset from here.
i.e., all the records this user is authorized to. Only warehouse 1 records appear in the list
Deployment Profiles • Object/field assumes
everything
authorized • Deployment Profile assumes
nothing
authorized
UI Deployment Profile Object security Database What the user chooses to see What is presented to the user What user is authorized to All objects and attributes
Deployment Profiles
Deployment Profiles
Deployment Profiles
Deployment Profiles
Deployment Profiles
Deployment Profiles
• Fields
Security for: Powerlink
…and Security for: Netlink
… and Security for: System-Link
Alerts – Integrator Subscriptions • Via e-mail, cell phone text or system message • Can also run a program
PO P012345 for $11,283.19 needs approval
ERP
Alerts – Integrator Subscriptions
Alerts – Integrator Subscriptions
Alerts – Integrator Subscriptions
Alerts – Integrator Subscriptions • NMS must be started
Data Sources • • • • Other Platforms Files on another iseries Files in another XA environment Install Drivers in IFS
Data Sources • Create the Data Source – server location, login • Build objects the normal way
Display SQL Server • • • • • • • • • Views, subsets, sorts Full navigation Navigation history Workbenches Code files Graph cards Compound cards Attachments Column functions
Transaction Broker • Create custom applications in Power-Link • Modernize existing or 3 rd party applications • • Common interface for user Write your business rules • Users can perform host processes • • Email, lists, on the fly analysis information, System-link requests
Transaction Broker • Create Custom Applications
Transaction Broker
Display Compile listing Compile program Generate program
Transaction Broker • Want to do embedded SQL in user exits?
• Change the Call Program type (may need to add to the card)
Object Transactions
• Processes outside normal business object flow • Better way to do Program actions – Requires EI – Transactions Card in Integrator – Parameters defined as attributes • Edits • Default generation • User Exits
Object Transactions
• Toolbar button to execute • Unique set of user exits
Object transactions
• Attribute (Number of copies) is required entry • Update User Exit calls the host print program • Edit User Exit – Required value for Number of copies
Logical Transactions
• Subset of Standard Transaction – Create, Change, Copy, Delete, Mass • Allows for one click update or prompt user • Use template to supply data
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… • The other client – NetLink, PowerLink 2-37
Why use System-Link
Off Line Load
• 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 2-38
Why use System-Link
System-Link handles: Database files and fields Logical fields Business rules User Exits Editing Security You also get
Release Transparency
No worries about release upgrades 2-39
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 2-40
Local Program Interface
• RPG program you call from anywhere – PSVPSR1R in AMALIBx • Parameters for the XML to send and receive – Inquiry – Request rows (view) or details (cards) – Receive the results – Maintenance – Create records, Update an attribute – Receive confirmation – Send is the Request - Receive is the Response 2-41
Web Services
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
Prerequisites
On the server… •Enterprise Integrator •Deployment Profile generated WS catalog •System-Link •Interface to data – Creates price book data On the client… •Microsoft Office •Microsoft Office XP Web Services Toolkit 2.0
Price book version after
Host edits, subscriptions…everything works