full
image
#666666
https://www.triadss.in/wp-content/themes/smartbox-installable/
https://www.triadss.in/
#26ade4
style2
+91 44 42021757

CASE STUDIES

IT SERVICES

  1. APPLICATION DEVELOPMENT
  2. ERP APPLICATION DEPLOYMENT AND MAINTENANCE
  3. ENTERPRISE APPLICATION INTEGRATION
  4. ELECTRONIC DATA INTERCHANGE

 

APPLICATION DEVELOPMENT

Triadss has been a established player in Custom Application Development. The quality process , benchmarking practices and collaborative development approach will result in quality solutions at lowest turnaround time in any required platform. Application support services ensure optimum usage of the services without any hindrance.

 

ERP APPLICATION DEPLOYMENT AND MAINTENANCE

Triadss has strong technical and functional teams for implementing and supporting ERP application across industries. Our strategic partnership with Ramco systems, a leading ERP solutions provider for Aviation industry, helps us to offer solution for HCM ( Human Capital Management ), SCM ( Supply Chain Management) and Manufacturing.

EDI (Electronic data Interface) / EAI (Enterprise Application Integration)

EDI allows reliable and secured data transfer from your database to client data base. Triadss has delivered several EDI solutions for various business needs like RFQ, Invoice interfacing with client system.

Enterprise Application Integration allows interconnecting islands of application in an enterprise through interfacing the data from one application to other , either on real-time or batch mode process. Triadss has delivered several EAI solution integrating applications with ERP systems

 

DATABASE MIGRATION

Migrating applications from one Platform/Technology to another, to higher version etc is essential to keep the application efficient and up to date with the current technology. Triadss has delivered several Enterprise application migrations from SQL server to Oracle and vice versa.

CASE STUDY – INTEGRATION OF MRO SYSTEM WITH SAP – Offline

For a low cost Airline operator

Overview

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. 

 

Business challenges

As part of Maintenance repair and overhaul, Inventory management system, Order management system there are lot of data processed by Aviation solution. These transactions need to be sent to SAP. All the master data like customer master and vendor master will be updated in both the systems.

  1. The process is tedious and redundant in nature and lots of precious efforts are involved.
  2. Huge amount of file movements and tracking is required.
  3. The mailing option has restrictions like file size limitation and security issues.
  4. The network interruption is also another factor which affects timely updation.

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.

  1. This addresses the secure and offline file transfer in intranet.
  2. Automatic file transfer at predetermined intervals.
  3. No middleware is used.

 

Business benefits

  1. FTP over intranet.
  2. Eliminate the need for middleware administration.
  3. Automated data flow.
  4. FTP logs are maintained.
  5. Secured and only authorised access to data

CASE STUDY- INTEGRATION OF MRO SYSTEM WITH SAP –ONLINE

For an ERP solution provider

Overview

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.

 

Business challenges

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.

  1. The process is tedious and redundant in nature and lots of precious efforts are involved.
  2. Huge amount of file movements and tracking is required.
  3. The mailing option has restrictions like file size limitation and security issues.
  4. The network interruption is also another factor which affects timely updation.

Solution

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

  1. This addresses the secure and online transfer of data.
  2. Asynchronous nature of MQ allows uninterrupted transfer of data.
  3. This has been built on IBM WEBSPHERE MQ technology.

 

Business benefits

  1. Web based data transfer interface.
  2. Automated data flow and validation at transaction level and interface level.
  3. Administration of error log.
  4. Secured and only authorised access to data.

CASE STUDY – Migration of database platform from Microsoft SQL to Oracle

For a leading Airline operator

Overview

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 same functionality and response in the ported system.

 

Business challenges

The application uses database platform specific objects like tables, views, indexes, triggers, functions & stored procedures. All these objects are to be analyzed and the number of lines code that need to be migrated and tested has to be estimated.

Solution

Our Solution was to migrant the Objects from SQL to ORACLE, The objects that needed to be migrated 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.

 

Business benefits

  1. Independent database platform
  2. Using the latest features of the platform
  3. Increase in application performance
  4. Able to standardize the database platform as the application can be deployed on multiple platforms
default
Loading posts...
link_magnifier
#6E787E
on
fadeInUp
loading
#6E787E
off