Mapping Source and Target Tables Based on Exact Name Matching
Mapping Source and Target Tables Based on Exact Name Matching
You can map source and target tables based on exact table name matching.
For the Merge Apply and SQL Apply modes, this method maps the source tables to target tables that have identical names. For the Audit Apply mode, this method maps the source tables to the audit log tables that have matching table names followed by the audit log table suffix.
You can map all of the source tables for which target tables with the same names exist, or use the Shift or Ctrl keys to select a subset of source tables to map to target tables with the same names.
Click the
Map Tables
tab.
In the
Source Schema
list, select a source schema.
For Microsoft SQL Server targets, this list displays SQL Server databases, which are similar to schemas of other source types.
A list of source tables that use the specified schema appears in the left list box. To filter the list, enter the first few letters of a table name in the
Filter
field. For case-sensitive filtering, enclose the filter value in double quotation marks.
Select the target schema in one of the following ways:
In the
Target Schema
list, select the target schema.
For Microsoft SQL Server targets, this list displays SQL Server databases.
Click
Match Schema
to use the source schema for the target.
A list of target tables that use the schema appears in the right list box. To filter the list, enter the first few letters of a table name in the
Filter
field. For case-sensitive filtering, enclose the filter value in double quotation marks.
For
Apache Kafka,
Cloudera,
Flat File
, or Hortonworks
targets, you do not need to perform this step. The Data Replication Console automatically displays the source schema in the
Target Schema
field and lists the source table names on the target side.
At any time, you can click
Refresh
to refresh the schemas for the source and target databases. If you cancel the refresh operation while it is in progress, Data Replication marks the configuration as not valid. Also, you cannot save the configuration unless you click
Refresh
again and do not cancel the refresh operation.
To map all source tables for which target tables with the same names exist, perform the following steps:
Click
Map All
.
In the
Map All
dialog box, select one of the following apply modes to use for the table mappings:
SQL Apply
Audit Apply
Merge Apply
If you select
Audit Apply
, the Data Replication Console looks for audit log tables that have matching table names followed by the suffix that is specified on the
Runtime settings
tab >
Calculated Columns
view. The default suffix is _LOG.
To exit the
Map All
dialog box without mapping the tables, click
Cancel
.
Click
Map
.
To clear all mappings, click
Unmap All
.
To map a subset of the source tables to target tables with the same names, use the Shift or Ctrl key to select the source tables and click
Match Table
. Then click the
SQL Apply
,
Audit Apply
, or
Merge Apply
button.
Repeat steps 1 through 5 for each pair of source and target schema for which you want to define table mappings based on exact name matching.
From the
Map Tables
tab, you can also enable the replication of Create Table and Drop Table DDL operations at the schema level, customize the types of DDL and DML changes to apply by target table, configure start points for the Extractor and Applier tasks, add Tcl and SQL expressions, and configure conflict resolution.