1 / 47

Denise Luther Senior IT Consultant denise.luther@cistech.net

Connect MAPICS to Anything with System Link (CISTECH R7.8 series). Denise Luther Senior IT Consultant denise.luther@cistech.net. Agenda. What is System-Link Methods to connect Managing System-Link Simulator LPI Web portal Web services. What is System-Link.

hanley
Download Presentation

Denise Luther Senior IT Consultant denise.luther@cistech.net

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. Connect MAPICS to Anything with System Link (CISTECH R7.8 series) Denise Luther Senior IT Consultant denise.luther@cistech.net

  2. Agenda • What is System-Link • Methods to connect • Managing System-Link • Simulator • LPI • Web portal • Web services

  3. What is System-Link • Bridge between XA and other systems • Inquiry • Maintenance • XML – Standard interface • Other ERP systems and other platforms • Request/Response • Part of IDF • CSM, PM, OBPM, EPDM, MM… • CO’s, PO’s, MO’s, Engineering…

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

  5. Why use System-Link • System-Link handles: • Database files and fields (objects, attributes) • Logical fields • Business rules • Editing • Default generation • User Exits • Security • Attachments • Host jobs and reports • Logical and object transactions

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

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

  8. Managing System-Link • Use Link Manager to manage System-Link processes By environment By machine Distribute server load across resources

  9. Managing System-Link Link Manager 7.8

  10. Managing System-Link • System-Link processes must be started on auxiliary • Autostart System-Link with environment • Right click or toolbar to start/stop/restart/Move • View Logs and diagnostics

  11. System-Link Simulator URL points to your host server

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

  13. System-Link Request

  14. System-Link Request Paste from clipboard

  15. System-Link Request Variables

  16. System-Link Response Check the response

  17. System-Link Response

  18. System-Link Response - Error Request has errors – Check the response

  19. System-Link Request

  20. System-Link Request Requesting System-Link from Card File

  21. System-Link Sessions WRKODBCJOB command will allow you to manage System-Link jobs.

  22. System-Link Sessions • IP address of auxiliary server will be System-Link sessions • View job log (Option 10) for troubleshooting • Link Manager 7.8 • Errors from associated Integrator user exits will be in QSYSOPR message queue

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

  24. LPI Parameters

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

  26. Constructing a Request • Write a service program with functions • for sections, tags and actions • XML header • Login • Request • Property path wrapper based on type: • alpha, numeric • Common actions

  27. Parsing Response • 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

  28. <Response_sessionHandle='1a5f739:fc75bbe92b:_7aef‘_workHan <QueryListResponse_name='queryList_PurchaseOrderGeneral‘_r <DomainEntity_domainClass='com.mapics.pm.PurchaseOrder' <Key> <Property_path='order'> <Value><![CDATA[P000349]]></Value> </Property> </Key> <Property_path_='order'> <Value><![CDATA[P000349]]></Value> </Property> <Property_path='vendor'> <Value><![CDATA[100]]></Value> </Property> <Property_path='vendorName'> <Value><![CDATA[Hi_Tech_Corp]]></Value> </Property> <Property_path='orderStatus'> <Value><![CDATA[20]]></Value> Starts a new record Field values

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

  30. Transaction Group StartTransactionGroup tag A StartTransactionGroup tag is used to group all subsequent maintenance actions in a request document as a single transaction. Normally, most maintenance actions are “auto-commit”: each maintenance action commits prior to the next action being run.

  31. Transaction Group <Request sessionHandle='*current' workHandle='*new' broker='EJB' maxIdle='1000'> <Update name='updateObject_Vendor1' domainClass='com.mapics.pm.Vendor'> ... </Update> <StartTransactionGroup /> <Create name='createObject_PurchaseOrder' domainClass='com.mapics.pm.PurchaseOrder'>…….. </Create> <Create name='createObject_PurchaseOrderItem1' domainClass='com.mapics.pm.PoItem'> ……… </Create> <Create name='createObject_PurchaseOrderItem2' domainClass='com.mapics.pm.PoItem'> ……… <Create name='createObject_PurchaseOrderItem3' domainClass='com.mapics.pm.PoItem'> ………. </Create> <Update name='updateObject_Vendor2' domainClass='com.mapics.pm.Vendor'> ............. </Update> </Request>

  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”

  33. Supplier Portal – Web application Style sheet used to present the XML data

  34. Supplier Portal – Web application Upload shipping documents to host server Create PowerLink attachment via System-Link request

  35. 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 PowerLink, System-Link or NetLink • Ability to update Purchase orders directly

  36. Power Link transactions

  37. Custom objects Custom objects can be used with System-Link (EI)

  38. Web Services Use RPG, HTML, Java, PHP, MS Office, anything that can communicate with a web server

  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

  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

  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

  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

  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

  44. Web Services – Price Book

  45. Web Services – Price Book

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

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

More Related