Transcript Presentation Title - CISTECH

Extend your Enterprise with
System-Link
Denise Luther
Senior IT Consultant
[email protected]
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
My technical background in the
iSeries/XA environment allows
me to help IT professionals
implement new technologies for
continued business success .
Recent Customer Success
• Saia-Burgess – Implemented custom supplier
web portal using Enterprise Integrator and
System-Link
Agenda
•
•
•
•
•
•
•
What is System-Link
Methods to connect
Managing System-Link
Simulator
LPI
Web portal
Web services
What is System-Link
• Bridge between XA and other systems
– Inquiry
– Maintenance
• XML – Standard interface
– 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
• Universal Off-Line Load
• Build websites for customers, vendors and
partners that links directly to the XA
database
• Web Services – industry standard way to
run programs over the web
Why use System-Link
System-Link handles:
Database files and fields (objects, attributes)
Logical fields
Business rules
Editing
User Exits
Security
You also get Release Transparency
No worries about release upgrades
Methods to Connect
• System-Link Simulator
– Use for testing/troubleshooting
• Directly to System-Link via LPI
– Call an RPG program with parameters
• To web server via XML
– Web pages – Java/HTML
• Web Services
– Anything Microsoft-enabled
– Requires Enterprise Integrator
• IBM’s WebSphere MQ
– Global enterprises
– Requires IBM products
Methods to Connect
•RPG can call LPI, Web Server, MQI, MQ LPI
•HTML can call Web Server
•Java can call Web Server and MQ JMS
System-Link References
• System-Link User Guide – Release 7.7
– Download from Infor support website
- Documentation
- Product Manuals
- Miscellaneous
- SYSL
• System-Link Installation Instructions R7
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
Managing System-Link
• Link Manager
– Green circle means started
– Right click to start/stop/restart/Move
– Run System-Link on auxilliary machine
Managing System-Link
Logs provide troubleshooting information
System-Link Simulator
URL points to your host server
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 or subset
System-Link Request
System-Link Request
Paste from clipboard
2-17
System-Link Request
Variables
2-18
System-Link Response
Check the response
2-19
System-Link Response
2-20
System-Link Response - Error
Request has errors – Check the response
2-21
System-Link Request
System-Link Request
Requesting System-Link from Card File
System-Link Request
System-Link Sessions
WRKODBCJOB command will allow you to
manage System-Link jobs.
2-25
System-Link Sessions
• IP address of auxiliary server will be System-Link
sessions
• View job log (Option 10) for troubleshooting
• Errors from associated Integrator user exits will
be in QSYSOPR message queue
2-26
Local Program Interface
• RPG program you call from anywhere
– PSVPSR1R in AMALIBx
• Parameters for the XML to send and receive
– Send an inquiry
• Receive the results
– Send an update
• Receive confirmation
2-27
LPI Parmeters
Parm
Description
P#XREQ
XML Request
I
65,535
A
P#XRSP
XML Response
O
65,535
A
P#MRQR
More records?
O
8
A
P#ERFD
Internal Errors
O
8
A
P#MSID
External Errors
PSX0122 – System-Link not
started
PSX0130 – Response > 65K
O
7
A
*YES if more records to
return
*YES if response contains
errors
Use
Size
Type
2-28
LPI Sample
• Available as a download
– SH14873
• Illustrate one way of using System-Link with your
RPG programs
– Send a request - Send XML request to LPI
– Parse the response - Receive and parse XML
response from LPI
• Create a report of PO’s for a vendor
• Only change required – Supply data for login
substitutions
2-29
Writing your programs
• Sample parsing program USRLPI1R is written generically
– Can be used for just about any object (use it for
yours)
– V5R4 New XML functions for parsing
%XML, XML-INTO, %HANDLER, XML-SAX
• Sample print program calls the parser field-by-field
– You can use this technique in your programs
– There are other techniques
2-30
Response_sessionHandle='1a5f739:fc75bbe92b:_7aef‘_workHan
<QueryListResponse_name='queryList_PurchaseOrderGeneral‘_r
<DomainEntity_domainClass='com.mapics.pm.PurchaseOrder'
Starts a new record
<Key>
<Property_path='order'>
<Value><![CDATA[P000349]]></Value>
</Property>
</Key>
<Property_path_='order'>
<Value><![CDATA[P000349]]></Value>
</Property>
<Property_path='vendor'>
Field values
<Value><![CDATA[100]]></Value>
</Property>
<Property_path='vendorName'>
<Value><![CDATA[Hi_Tech_Corp]]></Value>
</Property>
<Property_path='orderStatus'>
2-31
<
Fetch Next
• Don’t ask for too many records at once.
– You set the limit with MaxReturned
• LPI tells you if there are more.
• ‘FetchNext’ is the way to get more.
– Our sample programs shows you how.
– Create loop that processes until P#MRQR
= *NO
2-32
Supplier Portal – Web application
•HTTP Post interfaces with System-Link servlet
•Login information used to construct Login tag
•System-Link request to retrieve P.O. lines
•Auto content security determines what rows to return
•Deployment profile provides “firewall”
2-33
Supplier Portal – Web application
Style sheet used to present the XML data
2-34
Supplier Portal – Web application
Upload shipping documents to host server
Create PowerLink attachment via System-Link request
Power Link transactions
• Events on the web page are used to construct a SystemLink request to create records in a custom transaction
file. Transactions can be viewed in Power Link
• Custom transaction file is a business object with
Integrator user exits.
• User exits are used to perform work on the host (update
flags, dates, perform edits, default data generation)
• Integrator user exits execute if object is being
maintained via PowerLink, System-Link or NetLink
• Ability to update Purchase orders directly
2-36
Power Link transactions
2-37
Custom objects
Custom objects can be used with System-Link (EI)
2-38
Web Services
Use RPG, HTML, Java, PHP, MS Office, anything
that can communicate with a web server
2-39
Web Services
•Create a deployment profile
Include the object(s) you want
Specify the attributes
Specify the actions
•Generate the web service (URL)
WSDL – Web services description language
Identifies information required for Request
Type of Response that will be received
2-40
Web Services
•Web service provider WSDL information
•Tools for analyzing WSDL
• WDSc's Web Services Explorer
• SQLData System's Generic SOAP Client
• WebserviceX.NET's WSDL Analyzer
2-41
Web Services – Price Book
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
2-42
Web Services – Price Book
On the server…
•Enterprise Integrator
•System-Link
On the client…
•Microsoft Office
•Microsoft Office XP Web Services Toolkit 2.0
2-43
Web Services – Price Book
• PriceBookExample.xls provided
– Enable macros, if necessary
– Change price book, etc. to match your environment
• 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
Web Services – Price Book
Web Services – Price Book
Web Services – Price Book
Host edits, subscriptions…everything works
Thank You!
Technical Information
Denise.Luther
[email protected]
704-814-0017
Sales Information
Ben McCormick
[email protected]
704-814-0016