SAP Data Services 4.x Upgrade steps

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
Overview:
Environment Details:
Operating system: Windows Server 2008 64 Bit
Database: Microsoft SQL Server 2008 R2
Web Application: Tomcat
SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.1 SP2; SAP Data Services 4.1 SP2
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:
 
Pre Installation Check List:
 
○ Backup of repositories, configuration files & Data Cleanse files:
○ Backup of Local, Profile & Central Repository
○ Backup of Following Configuration Files:
○ admin.xml
○ sapconnections.xml
○ as.xml
○ dsconfig.txt
○ Backup of 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
 
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
○ Installation & Configuration of Address Cleansing Package 4.2
○ Best Practices says use the same Data base that you have use in SAP BODS 4.1 make a cloned copy and Use in SAP BODS 4.2 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
○ Configuration of Adapters in Data Services Management Console 4.2
○ Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console
○ Now Login in SAP BODS Designer 4.2 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.1 SP2 Installation & Configuration Documents:
Prerequisite:
SAP BusinessObjects Business Intelligence (BI) 4.1 SP2 or its higher compatible patches*
OR
SAP BusinessObjects Information Platform Services (IPS) 4.1 SP2 or its higher compatible patches*
Up gradation & Configuration Documents:

When the prerequisite system check completes successfully, click Next.

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
Overview:
Environment Details:
Operating system: Windows Server 2008 64 Bit
Database: Microsoft SQL Server 2008 R2
Web Application: Tomcat
SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.1 SP2; SAP Data Services 4.1 SP2
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:
 
Pre Installation Check List:
 
○ Backup of repositories, configuration files & Data Cleanse files:
○ Backup of Local, Profile & Central Repository
○ Backup of Following Configuration Files:
○ admin.xml
○ sapconnections.xml
○ as.xml
○ dsconfig.txt
○ Backup of 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
 
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
○ Installation & Configuration of Address Cleansing Package 4.2
○ Best Practices says use the same Data base that you have use in SAP BODS 4.1 make a cloned copy and Use in SAP BODS 4.2 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
○ Configuration of Adapters in Data Services Management Console 4.2
○ Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console
○ Now Login in SAP BODS Designer 4.2 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.1 SP2 Installation & Configuration Documents:
Prerequisite:
SAP BusinessObjects Business Intelligence (BI) 4.1 SP2 or its higher compatible patches*
OR
SAP BusinessObjects Information Platform Services (IPS) 4.1 SP2 or its higher compatible patches*
Up gradation & Configuration Documents:
When the prerequisite system check completes successfully, click Next

On the "SAP BusinessObjects Information platform services 4.1 SP2 setup" page, click Next.

Accept the License Agreement, and click Next.

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

To start the installation, click Next.

Installation is in progress

Finish

Up gradation & Configuration Documents of Data Services:
 

When the prerequisite system check completes successfully, click Next

On the "SAP BusinessObjects Data Services 4.2 SP1 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 BO IPS services.

To start the installation, click Next.

Installation is in progress

Finish

SAP Business Objects Data Services 4.X 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:

Upgrade of Secure Central Repository:

After Installation & Up-gradation of SAP business Objects BOE/IPS Server, SAP Business Objects Data Services 4.2SP1 below are the status that i upgraded in VMWare.

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

Then Click on Data Services and update the repository details of SAP Business Objects Data Services repository.

Now try to login in SAP Business Objects Data Services Designer.

Click on Logon

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":
 
Object Promotion:

○ Import Configuration

○ Export Configuration

Export Configuration using two way:
○ FTP
○ Shared Directory
 
 
Substitution Parameter : Now we can change the "Substitution Parameter" settings through SAP Business Objects Data Services Mananegment 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
 

Changes in "Architecture" of SAP Business Objects Data Services please refer below upgrade guide for more details.

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
 
Relevant Systems
 
These enhancements were successfully implemented in the following systems:
 
○ SAP Business Objects Information Platform Services 4.1 SP2/SAP Business Objects Enterprise Information Management 4.1 SP2
○ SAP Business Objects Data Services 4.1 SP2
 
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
 
SNotes:
 
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
 
Pasted from <http://scn.sap.com/community/data-services/blog/2013/12/12/sap-business-objects-data-services-migration-steps>