How to create source systems using the BW Modeling Tools
This video shows how to create source systems using the BW Modeling Tools in SAP BW/4HANA.
Using SAP HANA as Source System
After completing this lesson, you will be able to describe how to use SAP HANA as Source System
SAP HANA Source System
Getting started.
One of the key areas for innovation in SAP BW/4HANA is the extended and simplified integration of external non-SAP data. To enable this, SAP BW/4HANA includes the technologies explained in the previous lesson, SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SDI) which play a significant role in the provisioning of data from non-SAP data sources.
Create Source System of type HANA_SDA
Watch the following demo where a Source System of type HANA_SDA is created.
Create Open ODS View on source system of type HANA_SDA
Watch the following demo to understand how an Open ODS View on a source system of type HANA_SDA is created.
Create DataSource of source system type HANA_SDA and implement Remote Subscription
Watch the following demo where a DataSource of source system type HANA_SDA is created and Remote Subscription implemented.
For some SAP HANA SDI data provisioning adapters, real-time replication is supported. You can use remote subscriptions to replicate the data to the target table of the replication in real time, via the HANA_SDA source system. The data is available for updating to an ADSO based on process chains in streaming mode.
There are two types of remote subscription. They are as follows:
Type UPSERT means that all types of data changes (inserts, updates, and deletions) are written to the target table with an UPSERT SQL command. For keys that have been deleted from the remote source object, the statement writes the value "D" to column SDI_CHANGE_TYPE in the target table. In other cases, the statement writes the value "A" to column SDI_CHANGE_TYPE to represent new and updated data records.
The commit time stamp of the transaction is written to column SDI_CHANGE_TIME .
This type of real-time replication allows delta extraction and data streaming from an SAP HANA DataSource based on the time stamps in column SDI_CHANGE_TIME .
Type INSERT means that all types of data changes (inserts, updates, and deletions) are written to the target table with an INSERT SQL command. The statement writes the original change type to the SDI_CHANGE_TYPE column. For each data change, a commit time stamp is written to the SDI_CHANGE_TIME column and a unique sequence number is written to the SDI_CHANGE_SEQUENCE column.
Compared to the UPSERT type, not only after images ( SDI_CHANGE_TYPE "U") but before images ("B") as well are recorded for each data change. This makes it possible to transfer the data changes to an InfoCube-like INSERT-only target (Data Mart ADSO).
There are three technical fields, which provide important metadata about the kind of change that is replicated. They are as follows:
CHANGE_TYPE
Displays the type of row change in the source
| I | INSERT |
| B | UPDATE (Before image) |
| U | UPDATE (After image) |
| D | DELETE |
| A | UPSERT |
| R | REPLACE |
| T | TRUNCATE |
| X | EXTERMINATE_ROW |
CHANGE_TIME:
Displays the time stamp of when the row was committed. All changes committed within the same transaction will have the same CHANGE_TIME .
CHANGE_SEQUENCE:
Displays a value that indicates the order of operations for changes that were committed in the same transaction.
If the DataSource uses a data provisioning adapter that supports real-time replication, you can define which type or types of remote subscription should be used for real-time replication. You do this in DataSource maintenance on the Extraction tab. The selection depends on the required scenario.
Create Data Flow on HANA_SDA DataSource
In the following demo, a Data Flow on a HANA_SDA DataSource will be built.
Create Streaming Process Chain
In order to realize realtime replication, a Process Chain in Streaming Mode is created in the following demo.
Stream Data Changes
In the following demo, data changes in the source table are streamed into SAP BW/4HANA.
Log in to track your progress & complete quizzes
/support/notes/service/sap_logo.png "source system assignment in sap bw"){kind=logo}
1581846 - How To Restore a BW Source System - Netweaver/BW
- "The BW IDoc type QWERTY is not the same as the source system"
- "Source system ABCDEF is marked as inactive in BW - RSAR 5".
Environment
- Business Warehouse BW
- SAP release independent
RESTORE, SOURCE SYSTEM, PARTNER PROFILE, RFC , KBA , BW-WHM-DST-SRC , Source Systems , How To
About this page
Search for additional results.
Visit SAP Support Portal's SAP Notes and KBA Search .
Privacy | Terms of use | Legal Disclosure | Copyright | Trademark
IMAGES
VIDEO
COMMENTS
Exception Scenario: Data Mart. Data transfers from one BW system (Source BW) into another BW system (Source BW) are cases where this 1:1 assignment does not apply. The system ID of the source BW cannot be used here because the various objects (that were differentiated in the source BW by compounding to the source system IDs) would otherwise overlap.
Data transfers from one BW system (source BW) into another BW system (target BW) are cases where this 1:1 assignment does not apply. The system ID for the source BI cannot be used here, since various objects that have been differentiated between in the source BI by compounding with the source system ID would otherwise collapse.
Procedure. You are in the BW Modeling tools. Here you can create a new source system using the function New Source System: from the File menu. from the context menu of your BW project. via the context menu for the Data Sources node of your project. Via the context menu for the folder of the required source system type in the Data Sources tree.
Chat now. How to create source systems using the BW Modeling Tools. This video shows how to create source systems using the BW Modeling Tools in SAP BW/4HANA. Quick Links.
SAP Datasphere, SAP BW bridge all versions Keywords. SAP Cloud Connector, Communication System, ODP Source System, Communication Assignment, Cloud to On-Premise, Datasphere , KBA , DS-BWB-DM-SRC , Soure Systems , BC-EIM-ODP , Operational Data Provisioning (ODP) in Search&Analytics , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta ...
You can review and check the source systems using transaction RSA1. Choose Administration and expand the source systems folder Source Systems. Choose the Manage Source Systems link. In the Check Source Systems screen, you can see all of your systems, what type they are, and also if they are replicated or not.
In SAP HANA: Set up the Remote Source connection either on an SDA driver or SDI adapter. In SAP BW/4HANA: Create a New Source System of Connection Type: SAP HANA Smart Data Access referring to the Remote Source of step (1). In SAP BW/4HANA: Consume this remote source in either an Open ODS View for direct virtual access or define a BW DataSource ...
CHECK. In RSA1 --> context menue you have the possiblity to check a source system connection. Limitation of the check, it cannot garantuee if the RFC connection pointing to the correct server. Link How to check BW SAPI source system connections provides a description of a manual check of the source system. SAP SAPI BW Source Systems connection.
And the BW source system is traditional SAPI type, or ODP_SAP(ODP - SAP (Extractors)) type source system. SAP Knowledge Base Article - Preview. 3237778-How to transport the BW source system application component hierarchy to another BW system. Symptom.
When creating the appropriate SAP Source System connection in transaction RSA1 you receive the error: RFC destination BW could not be created in the source system (R3073) Subsequently, the manually created RFC connection in the source system does not work anymore as the instance number has been changed automatically to a non existing number (e ...
You use source systems in SAP BW∕4HANA to set up the connection to a source for the data transfer. Source systems are displayed in the BW Modeling tools in the Project Explorer view in the Data Sources tree. You can create source systems here and call source system functions.
Accessibility and Sustainability. System Status. Ask a question about the SAP Help Portal. Find us on. Share. . To connect a source for data access and data transfer with SAP Datasphere, SAP BW bridge, you create a source system.
restore, source system, partner profile, rfc , kba , bw-whm-dst-src , source systems , how to About this page This is a preview of a SAP Knowledge Base Article.