Steps to upgrade from BODI 11.7 to BODS 12.2

First step is to check if installed OS and your DB  are compatible with BODS.

(Refer to BODS 3.2 Supported Platforms. PDF)

If using old OS, then uninstall BODI and install BODS.

If new OS has been installed, then directly install BODS.

Steps to setup BODS on existing server

1. Install BODS
2. Upgrade/configure all the repositories after taking sufficient backups.
3. Modify  the datastore connections (applicable only if new database server has been installed).
4. Add job servers.
5. Add repositories to the Management Console.
6. Add Users
7. Create ODBC connections (applicable only if new OS has been installed).
8. Create folder structure (applicable only if new OS has been installed).
9. Sybase Client installation and configuration (applicable only if new OS has been installed).
10. Oracle Client installation and configuration (applicable only if new OS has been installed).

Step 1: Installation of BODS

Refer to Installation Guide Data Services 3.2.pdf

Use Skip Configuration setting for following options:

Directory Selection

Local Repository Selection

Configure Job Server

Configure Access Sever

Configure Metadata Integrator

Use Tomcat server with default settings as Web Application Server.

Step 2: Upgrade/configure Repository

Go to Start–> All Programs — >SAP BusinessObjects XI 3.2–>SAP BusinessObjects Data Services–>Data Services Repository Manager

Follow below steps:

i)                    Select Local Repository.

ii)                  Database server name

iii)                Give Repository name.

iv)                Give credentials

v)                  Get Version

vi)                Upgrade Repository.

NOTE:  Take repository DB backup first and for worst case take backup of JOBs also in atl file.

Step 3: Modify the Datastores settings.

Step 4: Add Job servers

1. Go to Start–> All Programs — >SAP BusinessObjects XI 3.2–>SAP BusinessObjects Data Services–> Data Services Server Management
2. Specify Cache as existing path i.e. D:\Log\Cache
3. Select “Edit Job server config -> Add”. Check default repository option for all.
4. Restart after adding all the job servers.

(Note: Keep the screen shot of details of existing job servers)

Step 5: Add Repositories to Management Console

1. Go to Start–> All Programs — >SAP BusinessObjects XI 3.2–>SAP BusinessObjects Data Services–> Data Services Management Console

1. Use default login credentials.

User Id – admin

Password – admin

1. Go to Management-> Repositories -> Add.

(Note: Keep a screen shot of existing repositories from console.)

Step 6: Add Users

1. Go to Start–> All Programs — >SAP BusinessObjects XI 3.2–>SAP BusinessObjects Data Services–> Data Services Management Console

1. Go to Management-> Users-> Add.

(Note: Keep the screen shot of details of existing users)

Step 7: Create ODBC connections

This step is applicable only if new OS has been installed.

Go to C:\Windows\SysWOW64\odbcad32.exe.

(Note: Keep the screen shot of details of existing ODBC connections)

Step 8: Create folder structure for input files

This step is applicable only if new OS has been installed.

Step 9: Sybase Client installation and configuration

This step is applicable only if new OS has been installed.

Install Sybase Client. After installation check if it configured. If not, then follow below steps.

1. Go to Start-> All Programs -> Sybase ->Connectivity->Open Client Directory Service Editor.
2. Server Objects -> Add.

Step 10: Oracle Client installation and configuration

This step is applicable only if new OS has been installed.

Install Oracle Client.

And configure it.