Depending on the source systems and the type of data basis, the process of loading data into the SAP BW is technically supported in different ways. In the conception phase, the system firstly needs to detect the different data sources in order to be able to transform the data with the suitable tool afterwards.
Data Basis
Additional heterogeneous data can be loaded alongside the original mySAP.com components that provide data via extractors:
- Flat files: A flat file in ASCII or CSV format can automatically be read by the SAP BW standard.
- Data providers: Providers such as Dun & Bradstreet and AC Nielsen US provide data which already has an import-friendly format.
- XML: XML data can also be processed in SAP BW.
Data Staging Tools
- DB Connect: Allows relational databases to be accessed directly. Here, SAP DB MultiConnect is used to create a connection to the database management system (DBMS) in the external database. By importing metadata and original data, the necessary structures can be generated in SAP BW, and the data can be loaded without problem.
- ETL tools (for example, DataStage): In heterogeneous system landscapes, an important requirement is that the different data structures and content are consolidated before being loaded into SAP BW. You can use an ETL tool such as Ascential DataStage to load data from heterogeneous systems, such as Siebel and PeopleSoft, transform this data into a single format and then load it via a Business Programming Interface into SAP BW.
- UD Connect: Using UD Connect, you can access just about all relational and multi-dimensional data sources. UD Connect transfers the data as flat data.
Multi-dimensional data is converted to a flat format when UD Connect is used.
Interfaces
- BW Service Application Programming Interface (SAPI): A SAPI is an SAP-internal component that is delivered as of Basis release 3.1i. Communication between mySAP Business Suite components and SAP BW takes place via this SAPI.
- BAPI: Like the SAPI, a BAPI is also used for the structured communication between SAP BW and external systems. Both data providers and ETL tools use this interface.
- FILE: SAP automatically supports automatic import of files in CSV or ASCII format for flat files as standard.
- Simple Object Access Protocol (SOAP): The SOAP RFC Service is used to read XML data and to store it in a delta queue in SAP BW. The data can then be processed further with a corresponding DataSource and SAPI.
- UD Connect (Universal Data Connect): For the connection to data sources, UD Connect can use the JCA-capable (J2EE Connector Architecture) BI Java Connectors that are available for various drivers, protocols and providers as resource adapters.
Using Technology to Improve Industry Performance Metrics in Transportation & Logistics
For transportation & logistics executives, it's important to recognize the potential of new technologies in driving key performance metrics to new heights. In this article, learn ways that these cutting-edge technologies can help enhance many crucial metrics.
Revolutionizing Healthcare Insurance with AI: Top 5 Areas AI Can Create Maximum Value
The next phase of artificial intelligence (AI) means there's a brand new era of possibilities for the healthcare insurance industry. In this article, learn five key areas where AI can generate the most value for healthcare insurance companies.
Using Neuroscience to Enhance Data Visualization and Maximize Speed-to-Insight
Now more than ever, we rely on data to understand our businesses and make decisions in rapidly changing environments, but simply looking at numbers isn't the most efficient way to interpret data. Especially if there's a lot of it! In this article, Senior Database Consultant Paula Worley shares why neuroscience points to visualizations as a better way of conceptualizing large amounts of data.
5 Life Insurance Technology Priorities: Empowering the Future of the Industry
The life insurance industry is constantly evolving, presenting both challenges and opportunities for companies across the board. It's crucial to understand the technology priorities that can drive growth, no matter if you're an established player or a new entrant. In this article, learn five life insurance technology priorities from Delivery Executive John Suminski.