DataCurrents  
Contact Us DataCurrents on Twitter DataCurrents on YouTube
Frequently Asked Questions (FAQ)
 
The following are common questions we are asked. If you cannot find the question/answer you're looking for, or if a proposed solution is no longer valid, please let us know.

What are typical scenarios for the implementation of DataCurrents replication?

DataCurrents can be effectively utilized in the following scenarios:

  • Data migrations, duplications -
    Data migration, data duplication : DataCurrents’ real-time data replication can significantly minimize or even eliminate downtime for data migration projects between RDBMS systems.
  • Data Warehousing -
    DataCurrents replication provides cost-effective solution when there is a need to replicate one or more tables from standalone databases to a centralized database repository.
  • Reporting -
    DataCurrents replication can simplify your reporting solution by replicating data from multiple database sources into a single reporting database.
  • Custom configurations -
    DataCurrents implementation can help in specific configurations by replacing more expensive data transfer solutions. An example is data consolidation from several source Oracle databases into one non-Oracle target.

Does DataCurrents replication require any changes to source tables?

No, there are absolutely no changes (to database triggers or any other database objects) required for DataCurrents during installation or run-time in the source application tables or schemas.

Does DataCurrents replicate internal database objects?

No, DataCurrents replicates data from applications and/or users tables only; it does not replicate internal RDBMS objects, since internal database structures are not compatible between RDBMS databases from different vendors.

What happens if a target database is stopped or a network connection becomes unavailable?

DataCurrents replication will continue collecting data in the source database; it will keep collected data in temporary tables within DCRepository. Once the target database (or network connection) becomes available, DataCurrents replication will resume its operation; it will transfer and apply collected data to the target database.

Can DataCurrents replication be used for "one source - multiple target databases" configurations?

Yes, the internal design and functionality of DataCurrents allows such configurations. These multiple target databases can be from the same or different RDBMS vendors. Upcoming releases will include this functionality built-in.

Why do you use java and jdbc for connections to source and target databases?

DataCurrents can work with RDBMS systems running on different OS platforms , including, Windows, Linux, Solaris, AIX andHP-UX. Java and jdbc have been chosen for the ability to work transparently on all these platforms without code modification, making the product transparent to different platform implementations.

Does DataCurrents require Oracle Streams?

No, Oracle Streams is not required for DataCurrents replication. Oracle Streams is only available for Oracle Enterprise editions, and DataCurrents can be implemented for all Oracle editions, including, Express, Personal 1, Personal and Enterprise.

Does DataCurrents support non-Oracle database sources?

The current version of DataCurrents supports Oracle as a source database; upcoming releases will include non-Oracle database sources.

Can DataCurrents perform data conversion while replicating data from source to target databases?

Yes, the internal structure of DataCurrents allows data conversion during data replication.

Does DataCurrents generate any alerts if it encounters errors?

Yes, if DataCurrents runs into problems preventing it from working properly, it generates error messages that appear in the log file of the source database and log files of DataCurrents components.
You can implement or enhance existing database monitoring solutions by monitoring DataCurrents alerts, which will help to identify issues early and take timely correction actions.

Can DataCurrents Server (DCServer) run on a separate server?

Yes, DCServer processes can run on a separate server provided that this standalone server has network connectivity to connect to both source and target databases. There are three possible configurations to run DCServer: it can run either on (1) source database server, (2) target database server, (3) standalone server. For more information, download our white paper.

Can DataCurrents provide active-active replication between two databases?

DataCurrents supports active-active data replication functionality between two databases where each table can be a data source and data target.
Additional DataCurrents configuration is required to support this functionality.

Does DataCurrents replication support Oracle Real Application Cluster (RAC) databases ?

Yes, Oracle RAC databases are supported. Oracle RAC database can be used as a source or target for DataCurrents data replication.

Can Oracle DataGuard be used with DataCurrents replication ?

Yes, Oracle DataGuard can be configured for source Oracle database without any impact to DataCurrents replication.
In addition to that, Oracle DataGuard can be used for initial data-loading for DataCurrents replication.

Does DataCurrents replication use Oracle’s Advanced Queuing (AQ)?

No, DataCurrents replication does not use Oracle’s Advanced Queuing

Is Oracle partitioning supported by DataCurrents replication ?

1.
DML commands (INSERT, DELETE,UPDATE SQL statements) executed against Oracle partitioned tables in a source database can be replicated to target Oracle or non-Oracle databases.
2.
Oracle partitioning DDL commands (for example - commands to create partitions, split partitions etc ) are supported for Oracle-to-Oracle replications with matching source and target configurations.

Does DataCurrents support Automatic Storage Management (ASM) in Oracle databases?

Yes, DataCurrents can use Oracle databases as source or destinations with either datafiles or ASM storage systems.

Can I replicate partial data from my source tables ?

Yes, you can setup filtering rules to extract and replicate data matching configured filters.

In addition to that, you can use datafiltering to apply data matching your rules.
This is very useful if your need to replicate one source table to several target tables with different filtering rules for each of your target tables.

 
Whitepapers
'Real time data replication from Oracle to other databases'
Overview of replication technologies for Oracle databases. The paper shows benefits of DataCurrents replication.
Download
DataCurrents Datasheet
The paper provides technical description for DataCurrents data replication software.
Download
 

Copyright © 2011-2013 DataCurrents. All Rights Reserved. Terms of Use

Home | Products | Support | About Us | Contact Us