IT Services
Triadss is a company with a solid background in custom application development. The team follows a collaborative approach, top benchmarking practices and a quality process to provide quality solutions with fast turnaround times on any required platform. They also offer application support services to ensure optimal service usage without any disruption.
Triadss has experienced technical and functional teams capable of implementing and supporting ERP applications across various industries. With a strategic partnership with Ramco Systems, a leading ERP solution provider for the Aviation industry, they offer solutions for Human Capital Management (HCM), Supply Chain Management(SCM), and Manufacturing.
Database migration is another area of expertise, and Triadss has successfully delivered several enterprise application migrations from SQL server to Oracle and vice versa.
Triadss has successfully delivered various EDI solutions for multiple business needs such as Request for Quote (RFQ) and Invoice interfacing with client systems. Furthermore, we have provided multiple Enterprise Application Integration (EAI) solutions, integrating various applications with ERP systems, interconnecting different application islands in an enterprise.
The Customer uses SAP for Finance Application and the Maintenance, Repair and overhaul functions have been implemented using Aviation solution. The MRO application must integrate with SAP for exchange and update of information. The offline integration requires conversion of MRO transaction data into SAP IDOC format.
As part of Maintenance repair and overhaul, Inventory management system, Order management system there are lot of data processed by Aviation solution.
The interfaces were identified for the data flow from MRO to SAP. All the Finance data to be converted into SAP IDOC compatible format at a pre-defined interval say once in a day and the flat file will be pushed into a intranet server for SAP to process the records. This addresses the secure and offline file transfer in intranet.
Our Solution was developed to integrate MRO application with SAP for exchange and update of information over real time. The online integration requires conversion of MRO transaction data into SAP IDOC format, SAP data need to be uploaded into Aviation application and a middleware for secured queuing of data for integration.
As part of Maintenance repair and overhaul, Inventory management system, Order management system there are lot of data processed by Aviation solutions. These transactions need to be sent to SAP and for some transactions taking place at SAP end like customer master, vendor master data creation and updation the data need to be updated in the MRO system.
The interfaces were identified for integration and classified as outbound MRO- SAP and inbound SAP- MRO. For all outgoing interfaces the MRO system data has been converted into SAP IDOC compatible format and all incoming data has been converted to MRO format. MQ has been used for secure and online transfer of data through various interfaces for each touch point. This addresses the secure and offline file transfer in intranet.
ERP product had been developed using Microsoft SQL server 2008. The product had a constraint that it cannot be deployed on other database platforms. The objective was to provide Database flexibility. This also enables an organization to standardize the IT platforms. Migrating the database involves analyzing the objects that need to be ported and code conversion and testing of objects to ensure the same functionality and response in the ported system.
Our Solution was to migrate the Objects from SQL to ORACLE, the objects that needed to bemigrated are identified and industry standard tools are used for converting TSQL to PLSQL. However, the automatic conversion was not 100 ready to use, as there are many instances of code conversion and functionality failures. After automatic conversion, manual debugging and testing of objects was performed for full functionality.