Replication Server supports database replication from the SAP Business Suite
applications that use pool tables into an SAP HANA database.
SAP Business Suite defines logical tables in the application layer. Logical tables
are pooled and stored in physical tables in the database. A pool table is a physical
table that contains a number of logical tables. When performing materialization and
replication of databases containing pool tables, SAP Replication Server depools the
data before sending data manipulation languages (DMLs) to the SAP HANA database as
the SAP HANA database stores the logical tables in the database.
Pool table replication can only be enabled when cluster table replication is enabled. Pool
tables can be subscribed to at the table or the database level. If you are
replicating pool tables:
- Ensure that tables meet requirements for replicating cluster tables
described in Cluster Table Replication in the Replication Server
Heterogeneous Replication Guide.
- Enable cluster table replication.
- Materialize table DD06L.
In Replication Server 15.7.1 SP204, the
alter connection to syntax
is enhanced
with:
alter connection to <rds>.<rdb> set schemamap with decluster [with | without] depool from <pds>.<pdb>.<from_schema> to <to_schema>
Parameters
- rds.rdb
- Specifies the connection name for the SAP HANA database.
- with depool
- Enables depooling of pool tables for a schema.
- without depool
- Disables depooling of pool tables for a schema.
- pds.pdb
- Specifies the connection name used in the create
connection command for the primary database.
- from_schema
- Specifies the schema of the primary database.
- to_schema
- Specifies the schema in the SAP HANA database.
SAP Business Suite Database Materialization and Replication Scenarios
To materialize and replicate SAP Business Suite applications running on supported
databases that contain pool tables into the SAP HANA database, you must configure
the Replication Server.
Configuration to enable materialization and replication for cluster tables is described in
Scenario 1 and
Scenario 2 of
SAP Business Suite Database
Materialization and Replication Scenarios in the
Replication Server
Heterogeneous Replication Guide. The following additional steps are required
to enable materialization and replication for pool tables:
- Create a subscription for DD table DD06L.
- Enable pool table
replication:
alter connection to <rds>.<rdb> set schemamap with decluster with depool from <pds>.<pdb>.<from_schema> to <to_schema>
In scenario 1 and scenario 2, add the preceding steps after the materialization of the
UMGPOCNV table.