Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
DayaJha
Active Contributor
20,764

Purpose:


The purpose of this document is to up-grade SAP Data Services from 4.X to SAP Data Services 4.3

Overview:


Environment Details:


Operating system: Windows Server 2016 Data Centre

Database: Microsoft SQL Server 2016 R2

Web Application: Tomcat

SAP Business Objects Tools: Information Platform Services 4.1 SP2; SAP Data Services 4.1 SP2

Migration Tools: SAP Data Services Repository Manager

Repository version: BODS 4.X

Installation & Configuration steps to upgrade SAP BODS 4.X to SAP BODS 4.3:


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 (Data store) of Source & Target Systems

  • Create a Check list of Jobs Scheduling in SAP Data Services Management Console

  • Create a Check list of Groups & Users Available in SAP 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.3

  • Installation & Configuration of Address Cleansing Package 4.3

  • 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.3 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.3

  • Configuration of Adapters in Data Services Management Console 4.3

  • Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console

  • Now Login in SAP BODS Designer 4.3 and configure Jobs (Real Time/Batch Jobs)

  • Configuration of Data store (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


Matrix of Compatibility: Please refer below SAP KBA regarding matrix compatibility

3197694 - SAP Data Services 4.3 and SAP Information Steward 4.3 compatibility with SAP Business Inte...


Information Platform Services 4.3 SP2 Patch 1 Up-grade & Configuration steps: When the prerequisite system check completes successfully, click on next


On the “Information platform services 4.3 SP2 Patch 1 update” page. Click on next


Accept the License Agreement, and click on next

On new license key requirement page, select the check box for new license key and click on next

On Announcement of deprecated product and features page, select the check box and click on next


By Default Language pack (English), click on next

Type a password for the CMS Administrator account, and click on next

Choose Installation mode, by default standard installation check box is selected


To start the installation, click on next

Installation is in progress

In Post Installation check, click on next

Installation completed successfully, click on finish

 

Up-grade & Configuration steps of SAP Data Services: When the prerequisite system check completes successfully, click on next

On the “SAP Data Services 4.3 setup” page, click on next

Accept the License Agreement, and click on next

Enter License Key and click on next

Click on next to accept the default path to the folder where the program will be installed

Configure data services common directory setup, click on next

Click on next to accept the default language (English)

Type a password for the CMS Administrator account, and click on next

Click Yes to restart the SIA services

To start the installation, click on next

Installation is in progress

SAP Data Services 4.3 installation completed successfully, click on finish

SAP Data Services 4.3 Configuration Documents: Before upgrade of local repository below are the error in SAP Data Services Designer

So before login upgrade the repository using 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: Before upgrade check the local repository version status

Then proceed for upgrade, after updating all details click on Upgrade

Upgrade of Secure Central Repository: Before upgrade check the local repository version status

Then proceed for upgrade, after updating all details click on Upgrade

After Installation & Up-gradation of SAP business Objects BOE/IPS Server, SAP Data Services 4.3 below are the status that i upgraded in VM Ware

Login to Central Management Console -> Go to Data Services and activate the repository


Now try to login in SAP Data Services Designer



Click on Logon



Click on “ok”


Now login in SAP Data Services management console



Click on “Administrator” tab



Reference Material:

Information platform services Installation Guide for Unix and Windows:

https://help.sap.com/docs/SAP_INFORMATION_PLATFORM_SERVICES?locale=en-US

SAP Data Services Guide

https://help.sap.com/docs/SAP_DATA_SERVICES?locale=en-US

Data Services Tutorials

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

https://wiki.scn.sap.com/wiki/display/EIM/EIM+Tutorials

What's New in Data Services

Critical document: 

Upgrade Guide

Sizing Guide

SAP Note 3197694 Compatibility(Information published on SAP site)

SAP KBA's:

1740516 - SAP Data Services 4.x and SAP Information Steward 4.x compatibility with SAP Business Inte...

2861185 - SAP Data Services 4.2 and 4.3 (Central Note)

3136005 - Release Notes for SAP Data Services 4.3 Support Pack 00 (Version 14.3.00.113)

3129934 - Log4j vulnerabilities - SAP Data Services and SAP Cloud Integration for data services

3159003 - Unable to sync a batch job that is published as a Web Services operation - SAP Data Servic...


3208938 - SAP Data Services 4.3 and SAP Information Steward 4.3 compatibility with SAP HANA

3165803 - Ability to filter on Datetimeoffset data type on OData V4 is not supported - SAP Data Serv...

1741042 - JDBC driver compatibility to connect to Oracle for Data Services and Information Steward

3191257 - Unable to read/load data from a datastore that connects to an Azure SQL Database on Linux

Related Blog Post: –

SAP Data Services 4.2 SP12 Upgrade steps

SAP Data Services 4.2 SP8 Upgrade steps

SAP Data Services 4.2 SP7 Upgrade steps

SAP Data Services 4.2 SP05 Upgrade steps
14 Comments
Labels in this area