Sector
Transportation
Background
The company hosted multi-terabytes of data in SAP ASE (Windows) as its core database supporting all of the mission critical applications. Most of the applications were developed in PowerBuilder (ver 9.x, 12.x). These applications support thousands of users.
Our solution
Performed platform migration to Linux Cluster, with ASE upgraded to latest version. Cut-over time minimized to 1 hour with SAP Replication Server. TPCC Benchmark indicated an improvement of over 5 times after migration.The PowerBuilder applications were upgraded to latest version of Appeon PowerBuilder, with some migrated to Web Application on PHP.
Sector
Finance & Banking
Background
The Investment Bank is using multiple ASE instances to host the databases for a number of mission critical trading applications. The ASE instances, version 15.x, were on Sun Solaris under an HA Environment. These instances also integrate other non-ASE databases with ECDA.
Our solution
Performed platform migration to Linux Cluster, with ASE upgraded to latest version. Both old and new version of ASE instances co-existed for several months to support phased migration of data. Common databases were syncrhonized with SAP Replication Server until all the databases were successfully migrated.Stringent application compatibility tests, failover and failback tests were carried out throughout the course of migration.
Sector
Public
Background
The department provides facility and program bookings by the general public through different channels, including counter, internet and Kiosk. The application runs on ASE Clustered Edition supporting thousands of users, handling hundreds of thousands of enquiries and bookings on a daily basis.
Our solution
Performed an upgrade of ASE to the AIX platform, with a high availability setup. Front-end PowerBuilder application was also upgraded to later PowerBuilder version.
Sector
Telecommunication
Background
The company has its core infrastructure built on SAP Sybase’s technology, including ASE, Replication Server and IQ on AIX platform. There are multiple ASE instances supporting their core business, with thousands of users.
Our solution
Performed platform migration to Linux Cluster, with ASE upgraded to latest version. Cut-over time minimized to 1 hour with SAP Replication Server. Significant performance was achieved after migration.
Sector
Finance & Banking
Background
The Bank is using Kondor Application to support its Currency Trading business. The application is mission critical with its core database engine running on SAP ASE 16.0.
Our solution
Implemented SAP Replication Server to the resilience of the ASE, by continuously replicating real time information to a standby ASE database server.
Sector
Finance & Banking
Background
The Bank has custodian system running on Sybase’s ASE, physically located in Hong Kong. The system supports operation for 12 countries including Singapore, Hong Kong and Japan. Each country has separate ASE instances.
Our solution
Performed a Replication implementation with SAP Replication Server to separate the OLTP transactions with online enquiry by replicating the information in real time to an enquiry ASE database for each country.