Extend your Enterprise with SystemLink Denise Luther Senior

Extend your Enterprise with System-Link Denise Luther Senior IT Consultant denise. luther@cistech. net

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 i. Series/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 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 Web. Sphere 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 R 7

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 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 – PSVPSR 1 R 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 PSX 0122 – System-Link not started PSX 0130 – Response > 65 K 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 – SH 14873 • 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 USRLPI 1 R is written generically – Can be used for just about any object (use it for yours) – V 5 R 4 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_session. Handle='1 a 5 f 739: fc 75 bbe 92 b: _7 aef‘_work. Han <Query. List. Response_name='query. List_Purchase. Order. General‘_r <Domain. Entity_domain. Class='com. mapics. pm. Purchase. Order' Starts a new record <Key> <Property_path='order'> <Value><![CDATA[P 000349]]></Value> </Property> </Key> <Property_path_='order'> <Value><![CDATA[P 000349]]></Value> </Property> <Property_path='vendor'> Field values <Value><![CDATA[100]]></Value> </Property> <Property_path='vendor. Name'> <Value><![CDATA[Hi_Tech_Corp]]></Value> </Property> <Property_path='order. Status'> 2 -31 < 2 -31

Fetch Next • Don’t ask for too many records at once. – You set the limit with Max. Returned • LPI tells you if there are more. • ‘Fetch. Next’ 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 Power. Link attachment via System-Link request

Power Link transactions • Events on the web page are used to construct a System. Link 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 Power. Link, System-Link or Net. Link • Ability to update Purchase orders directly 2 -36

Power Link transactions 2 -37

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 • Webservice. X. 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 XP Web Services Toolkit 2. 0 2 -43

Web Services – Price Book • Price. Book. Example. 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 – Price. Book. Base. Price. Svc – System. Operations • Import sample code (File => Import File) – Examples. Code. bas – MAPICSLogon. Prompt. frm

Web Services – Price Book

Web Services – Price Book

Web Services – Price Book Host edits, subscriptions…everything works

Thank You! Technical Information Denise. Luther denise. luther@cistech. net 704 -814 -0017 Sales Information Ben Mc. Cormick ben. mccormick@cistech. net 704 -814 -0016