7 Data Access Schema Configuration

The Data Access Schema (DAS) is a way for certain tables in the production database for the Merchandising suite, including Pricing, to be replicated to an on-premise or hosted environment to provide you with more direct access to your production data in order to build extensions, integration, custom reporting, and so on. The DAS uses Oracle GoldenGate, which is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. If you purchased the subscriber license for using GoldenGate as part of your subscription, then once you have installed and configured your target environment, you can configure which of the tables available for replication you want replicated to your target database. All tables in DAS are accessed via database views. Views are used to ensure that, even if a column it dropped from a base table or no longer used, the view continues to include all columns, so that any integrations or other extensions built using the data will not fail. Although they may need to be altered to remain functionally correct.

The list of tables that are available to be replicated are found in the DAS data model, which can be downloaded from My Oracle Support by accessing note 2200398.1. For details on configuring your target environment and adding tables to DAS, see the My Oracle Support note 2283998.1.