Source System

All source systems that provide data for access from the SAP BW system or transfer it to SAP BW are referred to as source systems. These can be:

  • SAP systems, to provide DataSources via the Service API
  • BW systems, to provide InfoProvider data from the source BW system via the data mart interface
  • Mock source systems for SAP systems, to develop scenarios for multiple source systems in a single BW system, even if only one source system is connected
  • ODP source systems, to provide data via the ODP data replication API
  • SAP HANA source system
  • SAP Data Services, to use its tight integration when providing data via staging BAPIs
  • Flat files that metadata is maintained for manually and is provided using a file interface
  • Database management systems that data is loaded into from a database supported by SAP using DB Connect, without using an external extraction program
  • Relational sources that are connected to BW using UD Connect
  • Web Services that transfer data to BW by push
  • Third-party systems with data and metadata transfer by staging BAPIs that can be implemented by SAP Data Services or another certified third-party provider

You define source systems in the BW Modeling tools in the Project Explorer view in the DataSource tree.

If creation is not possible for a source sytem type using the BW Modeling tools, create the source system in the Data Warehousing Workbench.