Success Stories

We’ll help you get optimised for success with tailored advice, expert knowledge and consultative services.

Data Management

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.

Job Management

Sector

Finance & Banking

Background

The Bank performed a revamp to migrate the batch jobs to Control-M as the operation job control engine.

Our solution

Migrate, re-architect and customize the batch jobs, currently managed by crontab, to Control-M for the payment exchange gateway application.

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. Upon upgrading and migrating the ASE to the Linux Platform, a custom-built job management engine was implemented.

Our solution

In order to delegate the database operation tasks to operator, a custom built job management engine was implemented. The engine came with a GUI that allows the operator to perform and schedule necessary database operations.

Sector

Public

Background

The organization was using Control-M to manage their batch jobs.

Our solution

Performed a pilot upgrade of Control-M from version 6.x to 8.x. The upgrade included Control-M/Enterprise Manager, Control-M/Server, Control-M/Agents.

Application

Sector

Public

Background

The Company has its core applications running on a number of SAP ASE instances handling Terabytes of data. The Company was looking for ways to automate and co- ordinate the backend jobs running on different ASEs, and to provide alerts to operator.

Our solution

A web operator control console built on PHP supports full automation and co-ordination of backend jobs on all machines, with email alerts.

Sector

Insurance

Background

The Company has been supporting its customers to pay premium through traditional methods such as credit card, direct debit, cheque, PPS, etc.

Our solution

Enhanced the application to support payment of premium end to end with FPS.

Sector

Telecommunication

Background

The Company has started a new business lines for its customers to enrol telco plan online on web and Mobile Apps.

Our solution

Built a web portal with responsive capability for customers to enrol new telco plans through browsers on the desktop and mobile devices. The portal integrated with the backend business systems.

Sector

Telecommunication

Background

Engineers of the Company have to go on-site to perform installation and defect fixing based on the assigned work orders. The Company planned to streamline the update of service status by the engineers and their communication with the operator in the office.

Our solution

A mobile application was developed to integrate with the backend work order system for order assignment and status update.

Sector

Transportation

Background

The company has over 30 mission critical applications developed in PowerBuilder 12.5 or earlier. These applications mainly connected to the SAP ASE database, hosting Terabytes of data.

Our solution

ISFactory assisted the company to upgrade these PowerBuilder to Appeon PowerBuilder 2019 to ensure compatibility with the latest database technology and OS platform. Some of these old PowerBuilder Applications were migrated to Web with PHP Laravel Technology.