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:
Post Installation Check List:
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.
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:
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.
| 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
* 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:
Count of Access Server:
Count of Batch Job:
Count of Real Time Job:
*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
On the "SAP BusinessObjects Data Services 4.2 SP05 setup" page, click Next.
Accept the License Agreement, and click Next.
Click Next to accept the default path to the folder where the program will be installed.
Click Next to accept the default language (English).
Type a password for the CMS Administrator account, and click Next.
Click Yes to restart the BOIPS services
To start the installation, click Next.
Installation is in progress
Finish
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
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
And after validating click on upgrade tab
Upgrade of Secure Central Repository:
Do the same validation for Secure central repository
And after validating click on upgrade tab
Then Login to Central Management Console -> Go to Data Services
Then Click on Data Services and check the repository version details.
Now try to login in SAP Business Objects Data Services Designer with SAP Business Objects Credential
Click on Logon and Click on “ok”
Now login in SAP Business Objects Data Services management console
Click on "Administrator" tab
New features are added in “SAP Business Objects Data Services management console 4.2":
After Installation & Up-gradation SAP Business Objects Data Services 4.2SP05 below are the status that i upgraded in VM Ware
Then again upgrade from 3.x to 4.x
Relevant Systems
These enhancements were successfully implemented in the following systems:
This document is relevant for:
This blog does not cover:
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |