Business Objects's Data Integrator is a data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (BusinessObjects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data marts, ODS systems and data warehouses, etc.
Additional transformations can be performed by using the DI scripting language to use any of the already-provided data-handling functions to define inline complex transforms or building custom functions.
Data Integrator Designer stores the created jobs and projects in a Repository. However, Data Integrator Designer also facilitates team-based ETL development by including a Central Repository version control system. Although this version control system is not as robust as standalone VCSs, it does provide the basic check-in/check-out, get latest, version labeling and undo checkout functionality. The DI Job Server executes monitors and schedules jobs that have been created by using the Designer.
Introduction What is a data warehouse? Data Warehouse Functions & Implementation Data Warehouse Products & Vendors About SAP & Their Products SAP's Data Warehouse product-SAP BW SAP BW functions, benefits & limitations About Business Objects & their Products SAP BO Product Portfolio- BI, EIM SAP BO Data Service Overview About Data Services-Introduction Functions-Data Integration & Data Management Data Services Product Evolution (ATL, DI & DQ) Architecture-by Components BO Data Services Tools & its Functions BO Data Services Objects & Object Hierarchy BODS Objects Naming Standards BODS Objects Comparison with SAP BW Objects SAP BO Data Services-Basic Level Resiportary Manager-BODS Resiportary Resiportary Types-Local, Central, Profile, Data Package Resiportary Creation & Up gradation Server Manager Job Server-Resipository Assignment Management Console- Introduction & Components Data Service Designer-Introduction & GUI Getting Start with Designer to develop First ETL Flow Data store & Formats Data store-Overview & Types Data store creation - DB, SAP, Adaptor, and Web service Formats - Flat file, DTD, XSD, COBOL, copybooks Data Extraction from Database Tables Data Extraction from Excl Workbook- Multiple Sheets Data Extraction from flat files (CSV, Notepad, and SAP Transport) Data Extraction from XML FILE (DTD, XSD) Data Extraction from COBOL Copybooks Data Distribution to flat file & XML Dynamic Extraction-File Selection & Sheet Selection SAP BO Data Services-Transforms Transforms & Category (DI, DQ, PF) Data Integrator-Data Transfer, Date Generation Data Integrator- Effective_Data, Hierarchy_Flatterning Data-Integrator-History _Preserving, Key _Generation Data Integrator-Pivot, Reserve_Pivot, XML_Pipeline Platform-Case, Map_Operation, Merge, query Platform-SQL, Validation, Custom ABAP Transform Data Quality-Introduction, standard content directions Data Quality-Dictionaries Configuration Data-Country_ID, Geocoder, Global_Adress_Cleanse SAP BO Data Services-Advance Level BODS Admin Console-Administration, Auto Reporting Real time Jobs, Embedded Data Flows Variables, Parameters, Substitution Parameters, System Config Debugging, Recovery Mechanism Data Assessment-Data Profiling BODS Performance Tuning Techniques Multi-User Development Environment-Into &Advantages Multi -User Environment-Implementation & Migration BODS Objects Migration Techniques Data Services-SAP Systems Handing SAP systems into, SAP Systems allowed, Terminology SAP BODS and sap ERP/SAP BI Integration SAP BODS User & Role Creation in SAP SAP ERP -Data Flow, Interfaces, and Objects allowed to BODS CREATING sap Application Data store-Properties SAP ERP-Tables & Hierarchies Data Extraction SAP ERP-Getting RFC enabled Functions Modules SAP ERP-IDOC Data Extraction & IDOC Data Loading SAP ERP- Extracting Flat files data from SAP APP Server SAP BW-Data Flow, Interfaces Objects allowed to BODS Creating SAP BW Source & SAP BW Target Data stores SAP BW-Extracting Data from SAP BW info Providers-OHD SAP BW -Extracting Data from SAP BW bases tables-/BIC/ SAP BW -Loading data to SAP BW info Providers (MD & TD) SAP BW -BW Jobs Execution