Local DD Tables for System Views

Syniti Migrate generates the Pass-Thru views used in readiness reporting via Stored Procedures in Migration's base database. These procedures are heavily dependent on the SAP Metadata Tables.

In the situation where the Working database resides on a remote Database server, the target snapshot datasources are stored on the remote server. These are examples of this type of situation:

• The Working database is remote on HANA DB or ORACLE DB with Migration using SQL Server.

• The Working database is remote on an SQL Server that is different from the Migration SQL Server.

These projects have additional steps within the process to build the System Views that are used for Check Table Reports. System Views are built to support these check table reports as views of the target datasource check tables. They are generally stored within the same database, so they can be accessed easily during this process.

However, when the Working database is remote to the Syniti Migrate database, these Data Dictionary tables are not available to the Syniti Migrate Stored Procedures. In this circumstance, the DBA creates a duplicate, local datasource on the Working Database Server to hold the SAP Metadata snapshots. This datasource stores only the DD (Data Dictionary) tables that are used to build the System Views as well as assist in any check table validations.

These six DD tables are:  DD02L, DD02T, DD03L, DD04L, DD05P, and DD08L.

This local version of Snapshot for tgtECC is designed for connection to the Migration Datasource Server, and it is stored within the Syniti Migration Application within Datasources.

Within the SQL Server DB, the ECC Snapshot Datasource contains these tables as shown below.

The user generates Build XML to create the tables physically within the Migration SQL Server as well as building the XML file for import to the ETL to use in the process of Importing the data from the remote database to this local database.

Within the ETL, the user imports an XML file to build the Import project that refreshes data in these DD tables.

Note

Make sure to first set up the Datastores for each of these Datasources within the ETL (Data Services for SAP as example). This way the import joins properly and does not show errors.

Just as the Datasource for tgtECC within the remote database is refreshed through the ETL, this local database for tgtECC_SQL is also refreshed.