This overview of the various interfaces in BW shows the main properties and can therefore help you with decision-making.
Interface |
Service: Read Write Display * |
Programming Language |
Mass Data Support |
Background/ Dialog |
Type |
Prerequisites |
DB Connect |
W |
ABAP |
X |
D/B |
Tool |
DataSource/InfoProvider |
UD Connect |
W |
Java |
- |
D/B |
Programming |
DataSource/InfoProvider |
API Service |
W |
ABAP |
X |
D/B |
Programming |
DataSource/InfoProvider |
File Interface |
W |
ABAP |
X |
D/B |
Tool |
DataSource/InfoProvider |
Web Service for Staging |
W |
ABAP/Java |
X |
H |
API |
InfoProvider |
XI Integration |
R/W |
ABAP |
X |
H |
Tool |
InfoProvider |
Staging BAPIs |
W |
ABAP |
X |
D/B |
Programming |
InfoProvider |
DataStore Object APIs |
W |
ABAP |
X |
D |
API |
DataStore Object |
Interface for Real-Time InfoCubes |
W |
ABAP |
X |
D |
API |
InfoCube |
Export DataSource |
R |
ABAP |
X |
H |
Tool |
InfoProvider |
APIs for Master Data |
R/W |
ABAP |
- |
H |
API |
Master Data |
APIs for Hierarchies |
R/W |
ABAP |
- |
H |
Programming |
Master Data |
VirtualProviders with Function Modules |
R |
ABAP |
- |
D |
Programming |
InfoProvider |
Open Hub Destination |
R |
- |
X |
H |
Tool |
InfoProvider |
Open Hub Destination APIs |
R |
ABAP |
X |
H |
Programming |
InfoProvider |
Data Mart Interface |
R |
ABAP |
X |
D |
API |
InfoProvider |
OLE DB for OLAP |
R |
Various |
- |
D |
Programming |
Query/InfoProvider |
MDX OLAP BAPIs |
R |
ABAP |
- |
D |
Programming |
Query/InfoProvider |
XML for Analysis |
R |
Java |
- |
D |
Programming/API |
Query/InfoProvider |
Data Federator |
R |
x |
D/B |
Tool |
InfoProvider |
|
Web Design API |
D |
- |
- |
D |
Tool |
Web Template |
Visual Composer |
D |
Java |
- |
D |
Tool |
Query/View |
BEx Application as an iView in the Portal |
D |
- |
- |
D |
Tool |
Query/Web Template |
BEx Application as Callable Object in Guided Procedures |
D |
- |
- |
D |
Tool |
Query/Web Template |
BI Java SDK |
R |
Java |
- |
D |
Programming/API |
Query/InfoProvider |
Analysis Process Designer |
R |
ABAP |
X |
H |
Tool |
Query/InfoProvider Master Data |
* READ returns data that can be processed further. DISPLAY returns data that is for display only.
You can find a detailed description of the interfaces in the following section.
If you extract data from your BW system into non-SAP systems, you need to have this scenario certified. This is required irrespective of the tool you are using for the extraction.