Use cases

Database replication tools

Database replication tools, like Oracle GoldenGate and HVR allows you to synchronize database at catalog, schema, table and column level. They support inclusion and exclusion rules, like “all but these tables in this schema”. The rules can use wildcards and regular expressions. They can use conditions, like “where a>1”.

Database file import/export, like Oracle bulk loader

To use a database bulk loader, you need a control file, which specifies how data should be loaded into the database; and a data file, which specifies what data should be loaded.

Apache Sqoop

Apache Sqoop efficiently transfers bulk data between Apache Hadoop (HDFS/Hive) and structured datastores such as relational databases. Sqoop can also be used to extract data from Hadoop and export it into external structured datastores.

MM Mapping Specification

When users cannot import replication mapping metadata they would like to specify it manually in Talend Data Catalog .