INTRODUCTION
What is
“SAP Business Objects Data Services”?
This is a software
tool designed by Business Object Some of the basic purpose of this tool is to perform jobs like –
§ ETL (Extraction Transformation and Loading) – Pulling out data from
any system/database/tables ,applying changes to modify the data or applying
programming logic to enhance the extracted data ,and loading data into any
other system/database or tables. E.g.: ETL of data from SQL server database to
Oracle.
§ Data Ware Housing – A database specifically
designed and developed in a particular format to enable easy data analysis or
reporting. This could be developed using data from various databases or any
other data sources.
§ Data Migration - Moving of data from
one place to another. This is a subset of ETL where data is relocated from one
software system or database to another .This also involves modification and
alteration of data.
§ Business Intelligence – A concept which
combines the data warehousing system and reporting. This is applied to analyze
data of organization to effectively perform functions like Business performance
improvement.
Why SAP
Business Objects Data Services?
There are many other software tools in the market which are capable of doing the same functions or activities as mentioned above or even more. They are the direct competitors for Business Objects. They are Informatica, Datastage, Cognos, and SSIS etc. The above mentioned activities can also be performed using programming tools like .Net or even Java and also directly within database end like SQL Server or Oracle.The tool BODS provides a very easy and efficient interface to perform these specialist tasks which involve data manipulation. The objects and functions within BODS are specifically designed to perform manipulations and transformation of huge and complex volume of data very efficiently. There are system provided objects and functions which can be dragged and dropped easily and jobs can be created. And, being a SAP tool has very god compatibility with SAP applications compared to any other similar tool.
There are many other software tools in the market which are capable of doing the same functions or activities as mentioned above or even more. They are the direct competitors for Business Objects. They are Informatica, Datastage, Cognos, and SSIS etc. The above mentioned activities can also be performed using programming tools like .Net or even Java and also directly within database end like SQL Server or Oracle.The tool BODS provides a very easy and efficient interface to perform these specialist tasks which involve data manipulation. The objects and functions within BODS are specifically designed to perform manipulations and transformation of huge and complex volume of data very efficiently. There are system provided objects and functions which can be dragged and dropped easily and jobs can be created. And, being a SAP tool has very god compatibility with SAP applications compared to any other similar tool.
Common
terms and terminologies
Designer
Designer is the graphical user interface that lets you create, test, execute and debug BODS Job. This is the space where the data transformations take place.
Designer is the graphical user interface that lets you create, test, execute and debug BODS Job. This is the space where the data transformations take place.
Repository
Repository is like a database that stores the objects in a designer. The job metadata, the transformation rules and the source and target metadata also. There are primarily three types of repositories Local, Central and Profiler. The designer cannot even be opened for any task without having a local repository. In other words local repository is a mandatory repository for BODS functioning. At this point we are not bothered about the other two repositories.
Repository is like a database that stores the objects in a designer. The job metadata, the transformation rules and the source and target metadata also. There are primarily three types of repositories Local, Central and Profiler. The designer cannot even be opened for any task without having a local repository. In other words local repository is a mandatory repository for BODS functioning. At this point we are not bothered about the other two repositories.
Engine
The BODS Engine executes the jobs created using the Designer. When the BODS application is started, there are enough Engines launched to effectively accomplish defined tasks.
The BODS Engine executes the jobs created using the Designer. When the BODS application is started, there are enough Engines launched to effectively accomplish defined tasks.
Job Serve
The Job Server is an application that launches the Data Services processing engine and serves as an interface to the engine and other components in the Data Services suite.
The Job Server is an application that launches the Data Services processing engine and serves as an interface to the engine and other components in the Data Services suite.
Access Server
The Access Server passes messages between web applications and the Data Services Job Server and engines.
The Access Server passes messages between web applications and the Data Services Job Server and engines.
Datastore
A datastore provides a connection to a data source such as a database. This is a linking interface between the actual backend database and Data services. Through the datastore connection, Data Services is able to import descriptions of the data source such as its metadata.
A datastore provides a connection to a data source such as a database. This is a linking interface between the actual backend database and Data services. Through the datastore connection, Data Services is able to import descriptions of the data source such as its metadata.
CMC (Central Management Console)
This is a web based administration tool for BODS which is used for some basic functions such as repository registration, User Management etc.
+VV Satyanarayana G
+Sairam Jalluru
This is a web based administration tool for BODS which is used for some basic functions such as repository registration, User Management etc.
+VV Satyanarayana G
+Sairam Jalluru
Print this post
No comments:
Post a Comment