lilymia79

Operational Data Provisioning (ODP) is the central infrastructure for data extraction and replication from SAP (ABAP) applications to an SAP BW/4HANA Data Warehouse. In this post, we will explore the various facets of SAP ODP and how this technical infrastructure can be used. There are two ways that the technical infrastructure of SAP ODP can be used to support specific scenarios. ·         Operational Analytics for decision making in operative business processes. ·         Data extraction and replication. Operational data provisioning supports extraction and replication scenarios for various target applications and supports delta mechanisms in these scenarios. In the case of a delta procedure, the data from a source is automatically written to a delta queue using an update process or passed to the delta queue using an extractor interface. Apart from SAP BW/4HANA and SAP BW, Operational Data Provisioning p...

The SQL Server Change Data Capture feature was first launched by Microsoft in 2005 and had advanced “after update”, “after insert”, and “after delete” capabilities. However, due to its invasive and complex nature, it did not find much favor with the DBAs. Consequently, another version was launched in 2008 that enabled DBAs to directly capture changes made to historical data. This technology is still in use today. The Functioning of the SQL Server Change Data Capture SQL Server CDC captures insert, update, and delete changes made to the SQL Server. The details are then stored in an easy-to-understand relational format. All information about changes made to a target database like columns and metadata are available in the CDC. These changes are stored in tables that replicate the structure of the columns of the tracked tables at the source. Access to the changed data in tables is strictly controlled.  The ETL (Extract, Transform, and Load) application is the best example of the...

Migrating data from Oracle to Amazon S3 can significantly improve data storage scalability and accessibility, leveraging the benefits of cloud infrastructure.   Assessing Your Oracle Data   Begin by assessing your Oracle database to determine the size and complexity of the data you need to migrate. Identify critical data, including tables, schemas, and large objects, and plan the migration accordingly.   Choosing the Right Tools   Several tools and services can facilitate the migration from Oracle to S3 . AWS offers services like AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT) that can automate much of the process. These tools help convert your Oracle schema to a format compatible with S3 and migrate the data efficiently.   Data Extraction   Start by extracting data from your Oracle database. Use SQL queries or Oracle’s export utilities (such as Data Pump) to export data into flat files. Ensure that these files are form...