1 / 17

Avantis ITK and Southern Union Company Implementation

Avantis ITK and Southern Union Company Implementation. Session ID #: PBAV122 Karim Kabiruddin. Invensys Enterprise Control Offerings. Corporate Systems. Industry Solutions Services: Consulting, Project Execution, Learning, Operational Improvement, Maintenance & Support

yehudi
Download Presentation

Avantis ITK and Southern Union Company Implementation

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. Avantis ITK andSouthern Union Company Implementation Session ID #: PBAV122 Karim Kabiruddin Invensys proprietary & confidential

  2. Invensys Enterprise Control Offerings Corporate Systems Industry Solutions Services: Consulting, Project Execution, Learning, Operational Improvement, Maintenance & Support Partner Ecosystem Corporate Software Applications Invensys and Third Party Manufacturing / Production Operations Automation Invensys and Third Party Enterprise Control System IT Platform Integration and Collaboration Platform

  3. Where The Offerings We Will Discuss Fit Within TheInFusion Enterprise Control System Execution Integration & Collaboration Platform Enterprise Asset Management Mobile Workforce Management Manufacturing Execution Systems Batch Performance Enterprise Manufacturing Intelligence Asset Performance Performance Measurement and Reporting Enterprise Integration Visualization Quality Optimization Workflow Advanced Process Control Simulation / Optimization Design Operator Training Third-Party Offerings Open Device Integration Web Portal Control Automation Software Applications DCS PAC SCADA HMI Application Toolkit Safety Turbomachinery Control Safety Instrumented Systems General Purpose Safety Historian Measurement & Instrumentation Recorders Instrumentation Controllers

  4. Southern Union Company • Southern Union Company (NYSE: SUG) is engaged primarily in the transportation, storage, gathering, processing and distribution of natural gas. Headquartered in Houston, Southern Union is one of the nation’s leading diversified natural gas companies. The company owns and operates one of the nation’s largest natural gas pipeline systems with more than 20,000 miles of gathering and transportation pipelines and one of North America’s largest liquefied natural gas import terminals. • Through Panhandle Energy, Southern Union’s interstate pipeline interests operate more than 15,000 miles of interstate pipelines that transport natural gas from the major producing areas to major markets in the Southeast, Midwest and Great Lakes region. Through CCE Holdings, LLC, Southern Union also owns an interest in and operates Florida Gas Transmission Company.

  5. Overview • What is the Avantis ITK? • How Panhandle makes use of ITK adapters? • What does the File Wrapper do? • Process – start to finish. • Additional Implemented Process Controls • Impact going forward with other systems. • Question/Comments.

  6. What is the Avantis ITK? • ITK – The Avantis Integration Tool Kit provides users the ability to integrate other applications to/from Avantis. • The ITK supplies extract and load adapters which can be configured to extract data from Avantis to feed to other systems and applications or load data from other systems and applications. • Load adapters include – stat, work order, add-ons, catalog request, and more. • Extract adapters include – work order, vendor, requisition, and more.

  7. Panhandle’s use of Adapters • At Panhandle we have an in-house application (Engine Reliability - ER) where technicians input engine stats (Daily Engine Hours (DEH), Starts, Stops, Oil Usage, Engine Blow Downs). • These stats are scanned by our ESB (Sonic ESB) and sent via an interface to the File Wrapper application (console application). The records from ER database are transformed into XML format which conforms to the Avantis Adapter(s).

  8. Panhandle’s use of Adapters Continued • When installing the ITK – you can choose the root path where the AvantisFileQueue folder is created. This folder will contain all the adapter folders that you installed. • Three folders are created for each adapter: Logs, Messages, and Return. • XML Messages are dropped in Messages folder using the following naming convention: ADAPTER_NAME.YYYY_MM_DD_HH_MM_SS_9999 where 9999 is a sequence number and it will start from 0001 to 9999. All XML files in the Messages folder will be processed.

  9. Panhandle’s use of Adapters Continued • Successful messages will be removed from the Messages folder. Stat records are sent to mc.opstat_trans table where it awaits the MTP for processing. • When there is a failure, the failed XML files go to a return folder, with a message of why it failed. Failed XML files are deleted every 30 days. • A log file is created which contains error messages.

  10. Using the File Wrapper • The Console/File System Queue application is an alternate method for exchanging data between Avantis and third-party applications. It is designed to work from a command line, it is an executable file that facilitates the interaction between the Avantis adapters and file system based XML message documents. • In FileWrap.exe Command line parameters are used to specify what adapter will be used, as well as passing properties and settings into the adapter. The application expects that ADPTDLL (Adapter DLL File) and ROOTPATH are always supplied. The ROOTPATH property should be set to the root folder location. • We created a FileWrapScheduler batch file which controls the execution of FileWrap.exe. FileWrap.exe processes one message at a time. FileWrapScheduler calls the FileWrap.exe in a loop as per the number of XML messages in the messages folder. We have set the FileWrapScheduler to run every 5 minutes as a Windows Scheduled Task.

  11. Process – Start to Finish • Engine Reliability (ER) user Mr. X inputs engine stats and click on process. • ER database is updated with new records for the engine ‘Y’ and the field for each record - ready for upload – is set to ‘1’. New records can be set to three values – ‘0’ – don’t upload, 1 – new record upload, 2 – modified record upload. • The Interface between ER and EAM starts and finds that there are records that need to be translated… • Records are picked up by the Interface and XML files are created.

  12. Process – Start to Finish Continued • The XML files created by the Interface are dropped in the messages queue for the Stat Load. • FileWrapScheduler starts and processes all the files in the queue. • Any failed or errors are sent to the return folder. • Process is complete and ready to be reviewed by system personnel. • Approximately 2,000 files are processed daily for engine stats. • Engine Stats are pertinent – they are needed for our Stat based PMs to trigger properly.

  13. Internal Process Controls • Users will input multiple days of records in ER to be processed. • ITK was at times skipping some records and processing some out of order and Stats were not calculating properly for PMs. • We can manage our interface to send files one day at a time, with a E09999 file at the end. • Our ESB will check the database and scan a second time for any errors for that particular day, and send them again – which is when it is successful. • If a stat is a user error – a record sent for a future date – the file is also not processed. • After customizing the process – less manual entry has been made in EAM for engine stats (1 for every 90,000 records) and the error rate has dropped significantly.

  14. Future Implementation • As need for integration grows – the use to the ITK becomes more relevant. • At Panhandle we have started testing WO Load from a custom extension application. This will help us track all deficient relief devices out in the field. • We will also integrate a Green House Gas system with EAM using the ITK which will provide our environmental group with gas emission data and they will send EAM data they gather from which we will create Work Orders and use the WO Extract adapter to send them work that needs to be done. • We will also test CM to automatically collect engine data – making it less manual work for the field users. • Version 5.x may also have additional features that we may able to utilize and take advantage of.

  15. Review • ITK – Powerful tool provided by Avantis if integration betweens EAM and other applications is desired/required. • Some adapters need tweaking and Avantis support can help. • Your process may also need some additional controls implemented if adapters don’t meet the specific organizational requirements. • Integration is the future – with the need for sharing of data across multiple applications – ITK makes it easy for data to flow from EAM to other systems.

  16. Questions? Comments? Your comments and questions help me improve what I am doing and may also help others. Thank You!!

More Related