Transforming between Different Database Types

Products > Realtime Data Integration > Transforming between Different Database

Data Transformations

Data Integration between Different DBMSs

HVR can replicate between different DBMSs, for example between Oracle, SQL Server and Ingres. It can also replicate between different versions of the same DBMS, for example between Oracle 8 and Oracle 10g. Replication can be in one direction or "bi-directional". Conversion between corresponding datatypes is done automatically.

Extra, Missing or Renamed Columns

HVR replication can be configured to know that a table or column in one replicated database has a different name in another database. HVR can also replicate between tables where one table has extra columns or some columns are missing.

Restrictive Replication

HVR has an option to replicate only some changes on a given table or to ignore changes to other rows. This can be used, for example, to allow old rows to be purged from the production database but to be kept in a reporting database or a data warehouse.

Performance is Unchanged

Maximum performance is maintained regardless of whether HVR is used in a homogeneous environment (databases from one vendor) or a heterogeneous environment (databases from different vendors).