You must map source tables to target tables for a replication configuration.
First connect to the source database from the
Source Database
tab and connect to the target database from the
Target Database
tab.
You can map source tables in a single schema to target tables in a single schema. Then repeat the mapping process to map tables for other pairs of schemas.
Depending on the target type, use one of the following apply modes to map tables:
SQL Apply
. You can use SQL Apply if you have
DB2,
MemSQL, Microsoft SQL Server,
MySQL,
PostgreSQL,
or Oracle targets. These mappings are highlighted in green.
Audit Apply
. You must use Audit Apply if you have
Apache Kafka,
Cloudera,
Flat File,
or
Hortonworks
targets. You can optionally use Audit Apply for relational target types. These mappings are highlighted in yellow.
Merge Apply
. You must use Merge Apply if you have Greenplum, Netezza, Teradata, or
Vertica
targets. You can optionally use Merge Apply for Oracle targets. These mappings are highlighted in orange.
To create a mapping, use any of the following methods:
Map tables individually.
Map multiple tables based on exact table-name matching.
Map tables based on wildcard expressions for table names.
The following image shows SQL Apply mappings on the
Map Tables
tab:
The list boxes on the
Map Tables
tab list the objects for which Data Replication supports replication. The following limitations apply:
For Microsoft SQL sources and targets, the
Map Tables
tab does not display views.
To display indexed views, you can set the
show_views
parameter to true in the
DataReplication_installation
/uiconf/default.cfg file.
If the default.cfg file does not exist, use a text editor to create the file in the uiconf directory and then add the
show_views
parameter in the file. For more information, see
Default.cfg File.