What is BODS:- It is an ETL tool currently acquired by SAP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems. It is tightly integrated with SAP systems and hence really a good tool to migrate data from legacy systems to SAP systems with ease and less development efforts with effective debugging and monitoring capabilities. How to get started? In the recent release like SAP BODS4, there has been improvements on the architecture , components and the enhancement features in several transforms. The major enhancement is in the Validation Transform in 4. In order to create your own local repository, it is important to know the database where you are allocated space quota to create the same.
|Published (Last):||12 September 2004|
|PDF File Size:||16.96 Mb|
|ePub File Size:||12.68 Mb|
|Price:||Free* [*Free Regsitration Required]|
To develop an ETL flow, you first need to create data stores for the source and the target system. A new window will open. You can select different database as source system as shown in the screenshot below. Enter user name and password and on the Advance tab, enter the system number and client number.
If you expand Datastore, it does not show any table. In this example, HANA is used as a target system. Once you click OK, this Datastore will be added to the local object library and there will be no table inside it. Enter the Project Name and click Create.
It will be added to the Project Area. You have to add Work flow and Data flow to this. Select a workflow and click the work area to add to the job. Enter the name of the workflow and double-click it to add to the Project area. Enter the name of the data flow and double-click to add it under the new project.
Now you can drag the target table with similar data-type to the work area or you can create a new template table. The Owner name represents the Schema name where the table has to be created. The table will be added to the work area with this table name.
Click the Save All option at the top. Now you can schedule the job using Data Service Management Console or you can manually execute it by right clicking on the Job name and Execute.
BusinessObjects Data Integrator
Data Quality Data Reports. Job server: The Job Server component helps you to starts the data movement engine. It allows you to integrate data from multiple sources. It helps you to perform complex data transformations and manages transactions and extractions from ERP systems and other sources. The Data integration Job server tool allows you to move in data in either batch or real-time mode. It delivers high data throughput and scalability. Moreover, while designing a job, you can also run it from the Designer which tells the Job Server to run the job.
SAP BODS - Overview
It allows you to integrate, transform trusted data-to-data warehouse system for analytical reporting. BO Data Services consists of a UI development interface, metadata repository, data connectivity to source and target system and management console for scheduling of jobs. Key Features You can apply various data transformations using Data Integrator language to apply complex data transformations and building customized functions. Data Integrator Designer is used to store real time and batch jobs and new projects in repository. DI Designer also provides an option for team based ETL development by providing a central repository with all basics functionality. Data Integrator job server is responsible to process jobs that are created using DI Designer.