Show TOC

Pool Tables ReplicationLocate this document in the navigation structure

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:
  1. Create a subscription for DD table DD06L.
  2. 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.