SAP BODS - Beginners guide

By Alok Ranjan

AIM:- 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 validations.

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?:-

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.

What 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 others.

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.

It depends on the database vendor like Oracle, SQL Server, Informix, DB2, etc which you have currently access to.

However, BODS installation comes with default mySQL database, which you should have installed on your system.

There is need of user/schema and database creation on my SQL which can be easily done by DBA.

Once user /schema and database name information is assigned to you, you can create the local repository.

Next 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 type.

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 ODBC datastore:-

Launch ODBC from Control Panel>Administration tools>ODBC

Go to ‘System DSN’ tab.

You can find several default added DSN names.

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 below:

Data Source Name( it can be as per your desired name).

Server name- local

User-(as given by DBA)

Password –(as given by DBA)

Database –(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.

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image