Integrate

Any Source and Target System

oracle data migration tools

Integration with any system

Hopp software has well-defined interfaces that can easily be applied to any system source and target system, making your data migration successful with less effort and better quality.

The application of these interfaces forms one part of the extension that will ensure that Hopp fits your system context.

Our pre-built integrations

  • Hopp's pre-built extensions contain not only the technical interface between the systems involved, but also the mapping, rules and validation that ensure that data is migrated correctly.
  • Should you be migrating to a standard system, chances are you could benefit from an already established extension saving you time and money.
  • We have already developed a number of these preconfigured integrations to be delivered ready to go, out of the box.

Microsoft Dynamics

If you plan to use multiple Dynamics modules across your organisation, chances are that the data migration effort will be significant. Getting a head start with a preconfigured enterprise-level data migration software from us will make sure your time can be spent focusing on getting the business process right.

Oracle Fusion

Migrating onto Oracle Fusion typically include migrating into several EBS modules like HR, Finance and Purchase, etc. The overall complexity and hence the need for consistent high-quality data is greatly helped by using our solution and already established extension.

Auto-generating code

Generic Integration

Hopp is a generic tool to manage complex data migrations.

As a generic tool, it must be applied to the specific situation, namely the legacy source system (to be migrated from) and the target system (to be migrated to).

We have prepared Hopp for such applications by building standards around all the key elements needed.

This makes it straightforward to apply Hopp to any source and target system.

Different Components

There are two main types of integration components for a Target or Source system:

  • Target and Source Maps 
  • Value Set and Connectors

The maps describe the inputs, processing and outputs for either the Source data to Interface Business Objects or Interface Business Objects to the Target data. 

These are defined entirely within the Studio component of Hopp in a standardized structure provided by that component. 

Integration Explained

There are several components that together make up Hopp Integration, and there are several ways to apply them.

A Detailed View

The flexibility of this architecture ensures that Hopp Integration can work with any system on any platform using CSV files delivered to a staging area, database, or multiple technologies. Hopp seamlessly invokes the Valueset Provider through a well-defined interface.

As illustrated above, let’s examine the different components and their positions in Hopp Integration. Fold out the various sections below and work from the Target System on the right to the Legacy Source System on the left.

The Valueset Provider hooks up to a well-defined Hopp interface, allowing migFx to seamlessly invoke the Valueset Provider. The job of the Valueset Provider is to extract data from the Target System to populate the Valuesets defined in the Target Map. These Valuesets are in turn used by migFx to validate and complete the data flowing through the data migration.

Examples of Valuesets could be:

  • A list of Product Codes known in the Target System. migFx can use the Valueset to validate the ProductCodes produced by the migration
  • A list of required Interest Steps for Account products in a Bank. Hopp can use the Valueset to inject missing Interest Steps for an Account product if these steps are not present in the Source System.

Also, the Metadata Provider links to a well-defined interface. This allows Hopp to seamlessly invoke the Metadata Provider to import the metadata describing the Target System. This is very useful not just as a one-off to get started, but also during the project to capture any changes made to the target system.

The migrated data produced by Hopp for any given Business Object is an Xml document containing all migrated data for the Business Object and its entire child Business Object hierarchy.

The task of the Data Delivery is to receive these Xml documents and place the data correctly in the Target System. The placement of data must take place using the method prescribed by the Target System (through an authorized API, direct insert etc)

The Data Delivery must handle all aspects of redelivery:

  • Only process redelivered Business Objects that have not already been placed successfully in the Target System
  • Clean out selected or all Business Objects in order to place corrected versions of the same Business Objects in the target System

Finally, the Data Delivery interface of Hopp allows the Data Delivery mechanism to return any informational or error messages to Hopp, so these can be flagged and be dealt with in a structured and supported way before another attempt is made.

The Data Delivery mechanism can take the form of files, databases etc and reside on any platform. The Data Delivery component reformats and restructure the target object data stored in xml by Hopp into the format required by the target system.

The Data Delivery places the migrated data received from the Source System in the Target System using the method prescribed by the Target System (through an authorized API, direct insert etc). This coherent execution flow will improve the quality of the end to end flow by resolving dependencies and identify any issues before or when insertion into the Target System is attempted. Any issues found are returned to migFx, flagged and can be dealt with in a structured and supported way before another attempt is made.

The migrated data produced by Hopp for any given Business Object is an Xml document containing all migrated data for the Business Object and its entire child Business Object hierarchy.

The task of the Data Delivery is to receive these Xml documents and place the data correctly in the Target System. The placement of data must take place using the method prescribed by the Target System (through an authorized API, direct insert etc).

The Data Delivery must handle all aspects of redelivery:

  • Only process redelivered Business Objects that have not already been placed successfully in the Target System
  • Clean out selected or all Business Objects in order to place corrected versions of the same Business Objects in the target System

Finally, the Data Delivery interface of Hopp allows the Data Delivery mechanism to return any informational or error messages to Hopp, so these can be flagged and be dealt with in a structured and supported way before another attempt is made.

The Data Delivery mechanism can take the form of files, databases etc and reside on any platform. The Data Delivery component reformats and restructure the target object data stores in xml by Hopp into the format required by the target system.

The Data Delivery places the migrated data in the Target System using the method prescribed by the Target System (through an authorized API, direct insert etc). This coherent execution flow will improve the quality of the end-to-end flow by resolving dependencies and identify any issues before or when insertion into the Target System is attempted. Any issues found are returned to Hopp, flagged and can be dealt with in a structured and supported way before another attempt is made.

When creating the Legacy Source Map, you are specifying exactly which data you are requesting from the legacy source system. Often you take what you can get – too much or too little – hard to know until you have mapped it with the data required by the Target Map. 

The Legacy Source Map match the source data descriptions (metadata) with the data requirements exposed by the Target Map (through the Target Interface). As shown any Hopp migration need maps completed and extensions established to facilitate mapping and data flow from source to target system. Out of the box the Hopp Interface need to be configured and setup for the systems to be migrated from and to.

If we do not have the required Hopp Interface already we will help or establish this as a part of any project using Hopp.

Book a demo!
Name
Email
Contact
Message
Hidden Fields

By clicking on “Submit” button you accept the Privacy Policy and Processing of personal data.