Skip to Content

Purpose:


The purpose of this document is to up-grade SAP Business Objects Data Services from 11.7/3.X/4.X to SAP Data Services 4.2 SP05


Overview:

Environment Details:


Operating system: Windows Server 2008 64 Bit

Database: Microsoft SQL Server 2012 R2

Web Application: Tomcat

SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.1 SP02; SAP Data Services 4.2 SP05

Migration Tools: Data Services Repository Manager

Repository version: BODI 11.7 or BODS 3.X or BODS 4.X


Installation & Configuration steps to upgrade SAP BODS 3.X/4.X to SAP BODS 4.2 SP05:

Pre Installation Check List:

  • Backup of repositories, configuration files & Data Cleanse files:
  • Create a Check list of Number of Batch Jobs/Real Time Jobs, Number of Access Server, Number of Job Server & Configuration Path (Datastore) of Source & Target Systems
  • Create a Check list of Jobs Scheduling in SAP Business Objects Data Services Management Console
  • Create a Check list of Groups & Users Available in SAP Business Objects Data Services Management Console
  • Backup of Local, Profile & Central Repository
  • Backup of Following Configuration Files:
    • admin.xml
    • sapconnections.xml
    • as.xml
    • dsconfig.txt
  • Backup of Data Cleanse Files

Post Installation Check List:

  • Installation of EIM(Enterprise Information Management) or IPS(Information Platform Services) Package in New Landscape
  • Installation of SAP BODS 4.2 SP05
  • Installation & Configuration of Address Cleansing Package 4.2
  • Best Practices says use the same Data base that you have use in SAP BODS 4.x make a cloned copy and Use in SAP BODS 4.2 SP05 environment
  • Up-gradation of Local /Central repository Using Data Services Repository Manager
  • Configuration of Repository in EIM or IPS (Package Name) Central management Console.
  • Configuration of SAP RFC in Data Services Management Console 4.2 SP05
  • Configuration of Adapters in Data Services Management Console 4.2 SP05
  • Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console
  • Now Login in SAP BODS Designer 4.2 SP05 and configure Jobs (Real Time/Batch Jobs)
  • Configuration of Datastore (SAPR3,SAP BW, RDBMS), Substitution Parameters, Job Server, Access Server, Format Data Type (Flat Files, CSV)
  • Now validate the Jobs at Top Level and if error comes fix those errors
  • Now Execute the Jobs using Scheduler or other BI Tools


SAP Business Objects Information Platform Services 4.x SPxx Installation & Configuration Documents:

Product Infrastructure Dependency:

Data Services (DS) requires SAP BusinessObjects Business Intelligence (BI) or Information Platform Services (IPS) for security capability. The table below shows the BI/IPS version and the corresponding compatible version of Data Services.


SCN.png

For more information on the compatibility of Data Services with BI platform or IPS versions, and compatible patch information, please see SAP Note


1740516 – SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP Business Intelligence platform and Information Platform Services for active releases

https://service.sap.com/sap/support/notes/1740516

1842698 – SAP Data Services 4.2 Upgrade Scenarios

https://service.sap.com/sap/support/notes/1842698


Supported Platform Link:

http://service.sap.com/PAM


Validation of Current Environment before and after application upgrade:


For Validation of Jobs, Access Server, Adapter & Web Services I am using script to populate the data in text file, Please refer the o/p for your reference.


  1. S.No

Validation Activity

Count

1

Count of Local Repository

1

2

Count of Secure Central Repository

1

3

Count of Job Server

1

4

Count of Access Server

1

5

Count of Batch Job

18

6

Count of Real Time Job

18

7

Count of Adapter

1

8

Count of Web Services

18


Count of Repository: Currently I have 1 “Local & 1 “Secure Central repository” highlighted in Yellow color


Untitled.png



* For validation you can also use “Local repository” metadata for above details. Here I used BATCH script to check all above parameter in my current systems, Please refer the below screenshot for your reference.


Count of Job Server:

Untitled.png

Count of Access Server:

Untitled.png

Count of Batch Job:

Capture.JPG

Count of Real Time Job:

Capture.JPG


*Same details you can get from batch script for Adapter & Web Services.


Up gradation & Configuration Documents of Data Services 4.2 SP:


When the prerequisite system check completes successfully, click Next


Capture.JPG


On the “SAP BusinessObjects Data Services 4.2 SP05 setup” page, click Next.

Capture.JPG

Accept the License Agreement, and click Next.

Capture.JPG

Click Next to accept the default path to the folder where the program will be installed.

Capture.JPG

Click Next to accept the default language (English).

Capture.JPG

Type a password for the CMS Administrator account, and click Next.

Capture.JPG

Click Yes to restart the BOIPS services

Capture.JPG


To start the installation, click Next.

Capture.JPG

Installation is in progress

Capture.JPG

Finish

Capture.JPG



SAP Business Objects Data Services 4.2 SP5 Configuration Documents:


Before upgrade of local repository below are the error in SAP Business Objects Data Services Designer


Capture.JPG

So before login upgrade the repository using SAP Business Objects Repository manager below are the steps for upgrade of  local repository details:

Below are the steps for upgrade of local repository & upgrade of secure central repository


Upgrade of Local Repository using SAP Data Services Repository manager:


Open SAP Data Services repository manager and check the version before migrating, You can also check in repository metadata through SQL

Capture.JPG


And after validating click on upgrade tab


Untitled.png


Upgrade of Secure Central Repository:


Do the same validation for Secure central repository

Capture.JPG

And after validating click on upgrade tab


Untitled.png


Then Login to Central Management Console -> Go to Data Services

Untitled.png

Then Click on Data Services and check the repository version details.

Capture.JPG

Now try to login in SAP Business Objects Data Services Designer with SAP Business Objects Credential

Capture.JPG

Click on Logon and Click on “ok”

Capture.JPG

Now login in SAP Business Objects Data Services management console

Capture.JPG


Click on “Administrator” tab

Capture.JPG


New features are added in “SAP Business Objects Data Services management console 4.2″:

  • Object Promotion:
    • Import Configuration
    • Export Configuration
  • Export Configuration using two ways:
    • FTP
    • Shared Directory
  • Substitution Parameter: Now we can change the “Substitution Parameter” settings through SAP Business Objects Data Services Management console also.
  • New Features added in Adapter like “Hive Adapter & VCF Adapter”
  • Changes in “Query and Validation” transform in SAP Business Objects Data Services Designer 4.2
  • New Features added like “REST web services”: Representational State Transfer (REST or RESTful) web service is a design pattern for the World Wide Web. Data Services now allows you to call the REST server and then browse through and use the data the server returns
  • Changes in “Architecture” of SAP Business Objects Data Services please refer below upgrade guide for more details.

Untitled.png



After Installation & Up-gradation SAP Business Objects Data Services 4.2SP05 below are the status that i upgraded in VM Ware


Capture.JPG


Then again upgrade from 3.x to 4.x

Capture.JPG

Relevant Systems

These enhancements were successfully implemented in the following systems:

  • SAP Business Objects Information Platform Services 4.1 SP02/SAP Business Objects Enterprise Information Management 4.1 SP02
  • SAP Business Objects Data Services 4.1 SP05

This document is relevant for:

  • SAP Business Objects Data Services Administrator

This blog does not cover:

  • SAP Business Objects Data Quality Management Up-Gradation


Reference Material:

Upgrade Guide:

https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_upgrade_en.pdf

Installation Guide Windows:

https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_install_win_en.pdf

Installation Guide UNIX:

https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_install_unix_en.pdf

SAP Data Services 4.2:

https://help.sap.com/bods

SAP Data Services 4.2 Product Availability Matrix:

https://websmp208.sap-ag.de/~sapidb/011000358700000441762013E

SAP Data Services Blueprints (Sample ATL Files of BODS 4.x)

Links

http://scn.sap.com/docs/DOC-8820

Data Services Product Tutorials:

Links

http://wiki.scn.sap.com/wiki/display/EIM/Data+Services+Product+Tutorials
http://wiki.scn.sap.com/wiki/display/EIM/Data+Services

Video Tutorials:

Links

http://wiki.scn.sap.com/wiki/display/EIM/Video+Tutorials

SNotes:

1388363 – Where can I download Data Services software, support packages, and patches?

https://service.sap.com/sap/support/notes/1388363


1263925 – Are Data Quality blueprints available? – Data Services

https://service.sap.com/sap/support/notes/1263925

1530081 – Troubleshooting tips for SAP Data Services 4.x

https://service.sap.com/sap/support/notes/1530081

1723342 – Data Services 4.1 Upgrade Scenarios

https://service.sap.com/sap/support/notes/1723342

1725915 – Release Notes for SAP Data Services 4.1 (14.1.0) Ramp-Up

https://service.sap.com/sap/support/notes/1725915

1740516 – SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP Business Intelligence platform and Information Version

https://service.sap.com/sap/support/notes/1740516

1900051 – SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP BusinessObjects Business Intelligence platform and Information platform services for inactive releases.

https://service.sap.com/sap/support/notes/1900051

1694041 – BI 4.0 Consulting:- How to size the Adaptive Processing Server

https://service.sap.com/sap/support/notes/1694041


1881527 – BODS adapter issues

https://service.sap.com/sap/support/notes/1881527

1769406 – Best Practices on taking a Hot Backup for a SAP BI 4.0 deployment

https://service.sap.com/sap/support/notes/1769406

746938 – How to backup or restore a Data Services 4.0 cleansing package.

https://service.sap.com/sap/support/notes/746938


DS4.1 – Address Cleansing using Global Address Cleanse transform

http://scn.sap.com/thread/3316670


1645932 – How to setup SSL certificates in a Distributed Environment – Data Services XI 4.0

https://service.sap.com/sap/support/notes/1645932


1416303 – Can’t reach Job Server from DS Designer

https://service.sap.com/sap/support/notes/1416303

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Marven Amomonpon

    HI Daya,

    you didnot use the dsconfig file during the installation of BODS.

    in the upgrade guide I see that during the installation we need to specify the location of the dsconfig file. Could you please clarify

    marven

    (0) 
    1. Daya Jha Post author

      Hi Marven,

      You can take the backup because while doing installation by default that path is selected because after upgrade it will not create new DSCONFIG.txt file, better to take a backup and then start upgrade.

      Once upgrade is done you can validate with backup and updated one as well.

      Thanks,

      Daya

      (0) 
      1. Marven Amomonpon

        Hi,

        We have BO4.1Sp2 &DS4.2Sp1 in the existing prod server.

        we now want to do a fresh install of IPS 4.1Sp6 & BODS4.2SP5 on a new server. Just took the clone of the existing DS repo.

        So can i just ignore this dsconfig file and do the BODS installation?

        Then upgrade & assign repositories?

        Regards,

        Marven

        (0) 

Leave a Reply