Skip to Content

Purpose:

The purpose of this document is to up-grade SAP Business Objects Data Services from 4.2 SP7 to SAP Data Services 4.2 SP8

Overview:

Environment Details:

Operating system: Windows Server 2008 64 Bit

Database: Microsoft SQL Server 2012 R2

Web Application: Tomcat 8

SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.2 SP3, SAP Data Services 4.2 SP8

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 SP8:

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 SP08
  • 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 SP08 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 SP08
  • Configuration of Adapters in Data Services Management Console 4.2 SP08
  • Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console
  • Now Login in SAP BODS Designer 4.2 SP08 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.

SAP Data Services 4.2 PAM – Data Services for SAP BusinessObjects Edge Products [2/2]:-

SAP BusinessObjects Edge BI with Data Integrator (SBOP Edge BI with DI) and SAP BusinessObjects Edge BI with Data Management (SBOP Edge BI with DM) are products comprised of installers from two products: SAP BusinessObjects Business Intelligence Platform Suite (BI) and SAP Data Services (DS). As such, the product information published for the SAP BusinessObjects Business Intelligence Platform 4.1 suite and SAP Data Services 4.2 and their corresponding support packages are applicable to the combined solution. Edge BI with DI/DM versions are shown in the table below, see the orange column. The underlying BI version and Data Services versions are reflected within the same row in blue.

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

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

1789731 – What version is compatible with Data Services 4.X? – Data Quality Management for SAP

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

Supported Platform Link:

http://service.sap.com/PAM

SAP Help Portal Link:-

https://help.sap.com/viewer/product/SAP_DATA_SERVICES/4.2.8/en-US

Up gradation & Configuration Documents of Data Services 4.2 SP8:

When the prerequisite system check completes successfully, click Next

On the “SAP BusinessObjects Data Services 4.2 SP08 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.

Select DS_COMMON_DIR directory as per your environment and click on Next

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 SP8 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

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 SP8″:-

  • New support for Hadoop Hive:- With this release, SAP Data Services supports edge nodes (also known as “gateway” nodes) running on Hadoop
    Hive clusters. Edge node support is for Linux only; SAP Data Services does not support using edge nodes on
    Windows.
    In addition edge node support, SAP Data Services now supports creating template tables in either Parquet or
    Table format
  • Amazon Redshift support:- Amazon Redshift is a data warehouse application for relational database query and management systems.
    You can connect to the Redshift cluster database on Windows and Linux platforms by using the Amazon Redshift
    ODBC driver. For information about downloading and installing the Amazon Redshift ODBC driver, see the
    Amazon Redshift documentation on the Amazon website

After creating a Redshift database datastore, you can do the following:-

  • Use Redshift tables as sources or targets in your data flows.
    • Preview data.
    • Create and import template tables.
    • Load S3 data files into a Redshift table using the load_from_s3_to_redshift function.
  • For more information, see the following topics in the Reference Guide:
    • “Amazon Redshift
    • ”Amazon Redshift source”
    • “Amazon Redshift target table options”
    • “Amazon Redshift data types”
    • “load_from_s3_to_redshift”.
  • Google BigQuery template table:- Use a Google BigQuery template table as a target in a data flow. When you execute the data flow, the software
    automatically creates the table in your Google account in the specified project and dataset. The software creates a schema for the template based on your Google BigQuery dataset, and accesses your Google account using information from the applicable Google BigQuery application datastore. To use the template table as a source, include a transform as a reader to pull specified data from the target table. For example, include a SQL transform in your data flow that includes a SQL statement that pulls the first 1000
    records from the specified target table

 

Relevant Systems:-

These enhancements were successfully implemented in the following systems:

  • SAP Business Objects Information Platform Services 4.2 SP03
  • SAP Business Objects Data Services 4.2 SP08

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 Upgrade Guide:

Upgrade Guide

SAP Data Services 4.2 Product Availability Matrix:

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

SAP Data Services Document Version: 4.2 Support Package 8:

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_whats_new_en.pdf

How to get a new License Key

https://wiki.scn.sap.com/wiki/display/EIM/How+to+get+a+new+License+Key

BI4.2 New License Key Requirement when updating from BI4.0/BI4.1

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

How to apply Permanant License Key in BODS

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

BODS License Key activation steps

https://scn.sap.com/thread/3601024

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:

1842698  for possible upgrade scenarios.

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

 

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

2067076 – RAM or RAO crashed with ” java.lang.OutOfMemoryError … ” – SRS

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

SAP Business Objects Data Services 4.2 SP7 Upgrade Steps

https://blogs.sap.com/2016/10/01/sap-data-services-42-sp7-2-upgrade-steps

To report this post you need to login first.

7 Comments

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

  1. Rabie Hamidi

    Wonderful blog Daya!

     

    I have tried to ask a question on this community about setting up a server for Data Server or IPS. This server is meant for CMS. However,  unfortunately I have not been able to find such guide on how to create A sever for DS and IPS

     

    can you please advice?

     

    thanks

     

    Rabie

    (0) 
    1. Daya Jha Post author

      Hi Rabie,

      Regarding your server setup query better to read server sizing guide  as well as if you share the details then i will guide you, below is the recommendation from myside.

      Recommendation I:- Better to use Information platform services as it was mini version of BOE platform where we can only deploy with SAP Business Objects Data services, Please refer above KBA mentioned in blog for more details.

      Option I:- Deploy IPS + BODS in single server

      Option II:- Deploy IPS in one server and BODS in another

       

      Recommendation II:- If you have already BOE then use that platform to deploy BODS Please refer above KBA mentioned in blog for more details.

      Option I:- Deploy BOE + BODS on same box this will impact performance

      Option II:- Deploy BODS in separate server so that it will not impact the performance

      Only problem with Recommendation II is if you upgrade then you have to think for BOBJ as well as BODS both.

       

      I hope this will help!!!!

       

      Thanks,

      Daya

      (0) 
  2. Rabie Hamidi

    Hi Daya,

     

    Thanks for your input. I have managed to Install IPS 4.2 + DS 4.2 on a Windows server 2012 with SQL Standard.

    Since this is used as a Demo environment for our Company we have chosen to install both IPS and DS 4.2 on one Windows Host.

     

    Thanks

     

    Rabie

    (0) 
  3. Donald Smith

    I am confuse. I have two files for upgrade IPS and Data Services. I only see one upgrade here and that’s is data services.. what about IPS

     

     

     

    Don-

     

    (0) 
  4. I am a Spurtan

    Hello Sir,
    I am trying to install DS 4.2 SP 9 on top of SBOP 4.2 SP04 . How ever, I am unable to install data service management console feature as the check box is disabled. See the image for more details. Can you throw me some insight on this ?

    Thanks.

    (0) 
  5. ASISH Kumar MOHANTY

    Hello Daya,

     

    Keep it up, All basic step are very essential , If you know Can you please share some very good tips in Data ingratiation using Different RDBMS or SAP CRM, SCM or other Functional Module .

    Thanks

    Asish

    (0) 

Leave a Reply