|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
SAP BODS - Beginners guide
By Alok Ranjan
The purpose of the tutorial is to give a novice a good hands experience on BODS
product to be able to create his/her own local repository , configure job
server, start his basic job
development and execute the job to extract data from source systems and load
data to target systems after performing transformations, look-ups and
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
to get started?:-
After getting BODS installed on the
machine, you can see the following on Start>All Programs
There are several components installed
as part of SAP BODS 3.2 installation.
In the recent release like SAP BODS4,
there has been improvements on the architecture , components and the enhancement
features in several transforms.
However, the BODS Designer looks
pretty same on both 3.2 and 4.0 versions.
The major enhancement is in the
Validation Transform in 4.0 which facilitates developers to switch on and off
the validations flags easily for one or several columns.
to launch next- Normally,
the developers would like to start BODS Designer to start developing jobs straightaway,
but it is always good to start creating own local repository first so that you
have full control on your own development environment without any dependency on
to create your own local repository, it is important to know the database where
you are allocated space quota to create the same.
depends on the database vendor like Oracle, SQL Server, Informix, DB2, etc which
you have currently access to.
BODS installation comes with default mySQL database, which you should have
installed on your system.
need of user/schema and database creation on my SQL which can be easily done by
/schema and database name information is assigned to you, you can create the
Screen shows the BODS Repository Manager
which administers you to create local repository.
As you need to create your own local
repository to do your own development activities, you need to select the
Repository type as ‘Local’.
Now you need to choose the Database
Type/vendor, where you want to create repository on.
Since as mentioned earlier, mySQL
database comes shipped with BODS product, it is convenient to create repository
on the same.
Hence, choose ‘MySQL’ in Database
MySQL Database type requires you to
choose ODBC data source.
Therefore, you just need to configure
ODBC with necessary parameters.
All you should know is your user name
and password and database schema name.
Next screen helps you how to configure
Launch ODBC from Control
Go to ‘System DSN’ tab.
You can find several default added DSN
If you want a dedicated DSN for
yourself, you should be able to add yours.
Click on Add button.
Select the driver ‘MySQL ODBC’.(
Please note that the version can be different, hence you need to ask admin team
if there is any discrepancy, but all what you want is mySQL driver).
Now, you need to supply information as
Source Name( it can be as per your
given by DBA)
–(as given by DBA)
–(as given by DBA)
After having provided all the
information , you would like to go for testing the connection.
So, click on Test button
You can see your newly created DSN
name in the screen below.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards