✒️SAP BI / BW BO Fuentes de Datos
SAP BI / BW BO Fuentes de Datos
-Sistemas Fuentes(Diferentes sistemas que dan datos para SAP BI).
-Extracciones de datos en tiempo real.
Las fuentes de datos servicio web y las fuentes de datos desde un sistema fuente SAP, pueden soportar la adquisiion de datos en tiempo real.
-Extracciones de datos con el servicio API.
DATAMART: Es una version especial de almacen de datos. y son subconjuntos de datos con el proposito de ayudar o proveer de datos a una area especifica.
-Extracciones de datos de ficheros planos. Es el metodo mas comun para integrar datos de sistemas externos.
-Extracciones de datos con DB Connect. Extrae datos desde Base de datos relacionales.
-Extracciones de datos con integracion de datos universal.
VirtualProvider Based on the Data Transfer Process DefinitionVirtualProvider whose transaction data is read directly from an SAP system using a DataSource or an InfoProvider for analysis and reporting purposes.
UseUse this VirtualProvider if:
%u25CF You require up-to-date data from an SAP source system.
%u25CF You only access a small amount of data from time to time.
%u25CF Only a few users execute queries simultaneously on the dataset.
Do not use this VirtualProvider if:
%u25CF You request a large amount of data in the first query navigation step, and no appropriate aggregates are available in the source system.
%u25CF Multiple users execute queries simultaneously.
%u25CF You frequently access the same data.
StructureThis type of VirtualProvider is defined based on a DataSource or an InfoProvider and copies its characteristics and key figures. Unlike other VirtualProviders, you do not need to program interfaces in the source system. To select data in the source system, you use the same extractors that you use to replicate data into the BI system. When you execute a query, every navigation step sends a request to the extractors in the assigned source systems. The selection of characteristics including the selection criteria for these characteristics is transformed, according to the transformation rules for the fields of the transfer structure. They are passed to the extractor in this form. The delivered data records pass through the transfer rules in the BI system and are filtered again in the query.
Since hierarchies are not read directly by the source system, they need to be available in the BI system before you execute a query. You can access attributes and texts directly.
Currently, the transformation only supports inverse transformations for direct assignment (without conversion routine) and the expert routine. Inverse transformations for other routine types and other rule types are also not yet implemented.
With more complex transformations such as routines or formulas, the selections cannot be transferred. It takes longer to read the data in the source system because the amount of data is not restricted. To prevent this, you can create an inversion routine for every transfer routine. Inversion is not possible with formulas, which is why we recommend that you use routines instead of formulas.
IntegrationTo be assigned to this type of VirtualProvider, a source system must meet the following requirements:
%u25CF For a connection using a 3.x InfoSource, the BI Service API (included in Plug-In Basis) has to be installed. DataSources from the source system that are released for direct access are assigned to the InfoSource. There are active transfer rules for these combinations.
%u25CF The source system is Release 4.0B or higher.
- Extracciones de datos basadas en XML.
Mecanismo push
-Extracciones de datos con Herramientas ETL Externas
Sobre el autor
Publicación académica de Jonathan Abimael Orozco Martinez, en su ámbito de estudios para la Carrera Consultor en SAP BI / BW BO.
SAP Senior
Jonathan Abimael Orozco Martinez
Profesión: Consultor Especialista Tibco, Microsoft - Mexico - Legajo: DW44G
✒️Autor de: 28 Publicaciones Académicas
🎓Cursando Actualmente: Consultor BI / BW BO Nivel Avanzado
🎓Egresado del módulo:
Certificación Académica de Jonathan Orozco
