Java Development in the SAP HANA/Oracle Golden Gate Environment

How we developed custom Java adapters for data replication

Task

Our challenge

Development of data replicators between SAP HANA and Oracle GoldenGate

In detail

Our success story

An end customer in the gaming environment implemented Oracle GoldenGate as a high-performance application for real-time transactional data capture and transformation. The Oracle GoldenGate Application Adapters for Java and Flat File, Oracle GoldenGate for BigData extend the capabilities of Oracle GoldenGate to include mechanisms for real-time integration of various tools other than relational databases. This mechanism is called Custom Java Adapter, which was developed by the customer development team to perform the transactions. We had to develop custom Java adapters for this data replication to take advantage of Oracle GoldenGate with SAP HANA.

The wescaleIT team developed an application to replicate Oracle GoldenGate with SAP HANA (DB), the Java adapter code for HANA replication was created. The Application Adapter delivers the source change data to SAP HANA Database via JDBC configuration and Custom Java Adapter code. Change data capture tests were performed from Oracle DB to SAP HANA. The capture process reads the change data from Oracle and processes it into trail files. The pump process distributes this trail data to the target system, from where HANA adapters replicate the changed data to the SAP HANA database using the application adapter.

About wescaleIT

wescaleIT AG is an IT full service provider specializing in the planning and implementation of demanding IT and technology projects. We focus on the wishes, needs and hardships of our customers, with an additional focus on optimizing their economic success.

The digitalization of global resources, in combination with our PaPCore system and our unique wealth of experience in the global IT environment, make us an unbeatable partner for your business.
This novel concept enables us to offer you the possibility to master the challenges of digital transformation in a transparent, scalable and high-margin way. Whether it’s employee leasing, ensuring delivery capability, a shortage of skilled workers or demographic change – we have solutions.

More success stories

Process management and optimization in infrastructure management

How we were able to sustainably reduce orders in hardware management

zum Case

Performance analysis of the entire SAP database infrastructure

How we could reduce the resource requirements of databases with increased performance

zum Case

Design and development of a SAP workflow application

How we developed a SAP workflow application

zum Case