1 / 26

TIPQA™ Interface Configuration

TIPQA™ Interface Configuration. i.t. Robert Neill. TIP QA ™ Interfaces. TIP QA ™ Interface Summary Definition Preparation to Install the Interface Access Control Settings Generating SQL Scripts TIP QA ™ Manager / Console Settings Interface Specifications / Datasets.

breck
Download Presentation

TIPQA™ Interface Configuration

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. TIPQA™ Interface Configuration i.t. Robert Neill

  2. TIPQA™ Interfaces • TIPQA™ Interface Summary Definition • Preparation to Install the Interface • Access Control Settings • Generating SQL Scripts • TIPQA™ Manager / Console Settings • Interface Specifications / Datasets

  3. TIPQA™ InterfaceSummary Definition

  4. TIPQA™ Interface Summary Definition • TIPQA™ Controlled Pull Interfaces • (Oracle or SQL Server Clients) using Interface Views • Deltek Costpoint • Oracle Manufacturing

  5. TIPQA™ Interface Summary Definition • ERP Controlled Push Interfaces • SAP ECC 4.7 to 6.0 – iDOC Transactional or Queue Processing • Manugistics/MTO • TIPQA™ Generic Interface • Multiple Connection Types with Inserts into Interim TIPQA™ Tables

  6. Preparation to Install the Interface

  7. Preparation to Install The Interface • Datasets Will Be Determined During Training/Setup of TIPQA Modules with Project Plan • Thoroughly Review Interface Documentation • Review All Functional Settings with Key Experts (i.e. Quality, Procurement, IT, TIP Technologies, etc.) • Review Database Size Requirements based on Interface Data • Always Start in a Test Environment

  8. Access Control Settings

  9. Access Control Settings • Access Control Setup in Business Unit • Interface Type and Version • Interface Options Specific to your Business Unit and Interface Type • Review Interface Behavior Options

  10. Generating SQL Scripts

  11. Generating SQL Scripts • SQLView Utility • View Options • Re-Run (if required) When Upgrading • Running Scripts on ERP System Schema

  12. TIPQA™ Manager / Console Settings

  13. TIPQA™ Manager/Console Settings • TIPQA™ Manager Set-up • Setup Profile Connection to Host • TIPQA™ Console Configuration • Cron Frequency • Agent Object Options • Error Notification Login ID • Activate Interface Services

  14. Interface Specifications / Datasets

  15. Deltek Costpoint Interface • Agent Objects - Inbound • Contract • Item Master • Commodity • Department • Vendor • Work Order • Agent Objects - Outbound • Receiving Inspection Outbound • Vendor Status Outbound • SN Assign • PO Line • Receiver • Customer • Personnel Interface Specifications / Datasets

  16. Oracle Interface • Agent Objects Current • Contract • Item Master • Commodity • Vendor • Work Order • Receiver • Customer • Purchase Order Detail • Receiving Inspection Outbound Interface Specifications / Datasets

  17. Oracle Interface (continued) • Added Agent Objects New or Near Future • PO Attachments / Quality Clauses • Bill of Materials • Routings and Operations • In Process Outbound with Subinventory Mgmt • Receiving Inspection Outbound with Subinventory Mgmt • Vendor Status Outbound • Sales Order / Contract • Work Order Pick List • Receiver / Work Order SN Assign Interface Specifications / Datasets

  18. SAP Interface • Agent Objects Inbound • Item Master • Vendor • Receiver • Customer • Nonconformance • Vendor Status Outbound Interface Specifications / Datasets

  19. SAP Interface • Added Agent Objects Near Future • Receiving Inspection Outbound • Receiver Stock • Bill of Material • Routing/Operations • Projects • Purchase Order Detail • Commodity • Departments • Personnel Data Interface Specifications / Datasets

  20. Manugistics/MTO Interface Agent Objects Inbound • AAT_IN • Project • Item Master • Vendor • Work Order • Receiver w Delivery • Receiver Stock Acknowledgement Agent Objects Outbound • AAT_OUT • Receiver Accept/Reject Quantities • Vendor Status/Overall 3 Month Rating via FTP Interface Specifications / Datasets

  21. Manugistics/MTO Interface • Oracle SQL Net Database Links and Stored Procedures are Used to Link to the TIPQA™ Database to “Push/Pull” the Data to and from the AAT_IN and AAT_OUT TIPQA™ tables • Fixed Length Record into TIPQA™ Tables • FTP is Also Utilized to Send Vendor Data Back to MTO Interface Specifications / Datasets

  22. TIPQA™ Generic Interface Agent Objects Inbound • Contract • Item Master • Commodity • Department • Vendor • Work Order • POLine • Receiver • Receiver Stock • BOM • SN Config • Routing Interface Specifications / Datasets

  23. TIPQA™ Generic Interface Agent Objects Inbound(continued) • Customer • Nonconformance • Gage • GT Calibration • Personnel • Future – RI / IP Specific Criteria • Receiving Inspection Outbound Table • Vendor Status Outbound Table Interface Specifications / Datasets

  24. TIPQA™ Generic Interface • TIPQA™ Provides Interim Interface Tables that can be Populated with Data From Many Sources • Scripts and Procedures can be Written to Extract Data from Any ERP/MRP System to Insert into the TIPQA™ Generic Interface • Data from MS Excel, MS Access, Flat Files, Fixed Length (etc.) can be Imported Interface Specifications / Datasets

  25. TIPQA™ Generic Interface • TIPQA™ External Launch Interface • TIPQA™ Provides an XML Based Interface Methodology that can be Called or Invoked in Many Ways • Corrective Action View / Create • In Process Inspection View / Create • Nonconformance View / Create • Serialized Test/Inspection Create • Confirmation Return of Created Records • Work Order Close Verification Interface Specifications / Datasets

  26. QUESTIONS

More Related