Skip to Content

Tutorial: How to install SAP Data Services 4.2 – Part 1

As mentioned in my previous article, I’m “celebrating” the release of SAP DS 4.2!  There are so many of our customers stuck with SAP BI 4.0 + SAP DS 4.1 (some also with SAP IS 4.1) and can’t wait to go to SAP BI 4.1 and start benefiting from the new features.

 

Problem is SAP DS 4.1 and SAP IS 4.1 are of course incompatible with SAP BI 4.1…  See SAP Note 1740516

 

For reference: SAP Data Services 4.2 and Information Steward 4.2 now “Release to Customer”: http://scn.sap.com/docs/DOC-50190

 

 

This article is Part 1: Installing SAP Data Services 4.2

 

Next, Part 2 will cover Post-Installation Configuration

 

Finally, I will cover the installation of SAP Data Services 4.2 SP01

 

 

Pre-requisites

 

Refer to the Product Availability Matrix (PAM): https://service.sap.com/sap/support/pam?hash=pvnr%3D67838200100900005703%26pt%3Dg%257Cd before starting the installation.

 

As always, it is useful to refer to:

 

 

 

 

 

Environment

 

This tutorial has been written with the following environment:

  • OS: Microsoft Windows Server 2012
  • SAP BI: SAP BusinessObjects BI Platform 4.1 SP02
  • Database: Sybase SQL Anywhere 12.0.1

 

Note: I could have of course use Microsoft SQL Server 2012 or others but I wanted to experiment with Sybase SQL Anywhere.  And it takes very little RAM which is great for my VM on my poor laptop!

 

 

Step by Step Installation

 

Install SAP Data Services 4.2 SP01

 

 

Download the software at: http://service.sap.com/support > Software Downloads > Installations and Upgrades > A – Z Index > D > SAP Data Services > SAP Data Services 4.2

 

/wp-content/uploads/2013/12/image_png_342613.png

 

Extract 51047280_2.zip to a temporary directory E.g.: C:\Temp

 

Run: C:\Temp\BD_SAP_DATA_SERVICES_4.2_SP1_W_L_64B_\DATA_UNITS\DS_42_WIN64\setup.exe

 

1. View.png

 

Click: Yes or No

 

2- Pre-req.png

 

Click: Next

 

3- Message.png

 

This is a new screen and I really like it.  Looks like SAP is raising it’s hand here and accept they have created a problem which shouldn’t have occurred in the first place.

 

As mentioned above and elsewhere, this incompatibility issue is a real nightmare.  I’m glad there is a better way.  I’ll be investigating it and hopefully document this at a later time.

 

Click: Next

 

4- License.png

 

Click: Next

 

5- License.png

 

I accept the License Agreement: selected

 

Click: Next

 

6- Key.png

Enter: license key

 

Click: Next

 

7- Folder.png

 

Click: Next

 

8- Language.png

 

Click: Next

 

9- CMS.png

 

Enter the System name (aka CMS host name)

 

Enter the Administrator account password

 

Click: Next

 

10- Question.png

 

Click: Yes

 

11- Install Type 2.png

 

I personally prefer to select Install without configuration.  This allows the installation to run without trying to do too much and perhaps fail.  We’ll deal with the creation of a Repository and the configuration of the Job Server after the installation.

 

12- Features.png

 

Click: Next

 

13- Merge.png

 

Skip configuration: selected

 

14- Login.png

 

It is recommended to run Data Service as a service account so the Job Server can read/write to network file locations fir instance.  This is something that can be done later.

 

Select Use system account or Enter the credentials of your service account.

 

Click: Next

 

15- Ready.png

 

Click Next

 

16- Done.png

 

Click Next

 

17- Finish.png

 

Click: Finish

 

18- Reboot.png

 

Click: Yes (when possible)

 

 

Screenshots Post Installation

 

Here are some post-installation screenshots.

 

Central Management Console (CMC) – Where you create and manage the repositories

 

1- CMC.png

 

Applications Rights

 

2- CMC Apps.png

 

Hope this was helpful.

 

Thanks!

 

 

35 Comments
You must be Logged on to comment or reply to a post.
  • HI Patrick ,

    In your document i am not getting the Repository Configuration steps which i am getting in Installation .

    ALso when i am putting all the details as mentioned in screen 1

    in screen 2 can you explain the significance of The Specified database does not contain a valid repository.

    Attached the screen in serial order pls help me .

    Regards,

    AbhishekScreen1.PNGScreen2.PNGScreen3.PNG

    • Hi,

      I’m not sure if I understand your questions but I’ll give it a try!

      1- In my installation I didn’t get the repository screen because I have selected to “install without configuration”

      2- Your error seems to indicate the details you are providing are either wrong or perhaps even don’t have connectivity?

  • Problem is SAP DS 4.1 and SAP IS 4.1 are of course incompatible with SAP BI 4.1…  See SAP Note 1740516

    We can now call all our customers to spread the good news with SAP DS 4.2 ! Thanks for sharing.

  • Patrick,

    Thanks for the step by step illustration. It was very helpful.

    Can you please share the steps for creation of a Repository and the configuration of the Job Server.

    Thanks,

    Rajesh

    • The CMC licenses section manages license for Information Steward and other applications.

      Depending on which version of DS you are working with, the following is now true:

      1. Pre-DS4.2.x:

      Go to Start => SAP Data Services => SAP License Manager

      Select existing Data Services trial license in “Registered Keycodes

      Click Remove

      then “Add” your new license

      Restart the Data Services Designer

      2. Post-DS4.2.1.x:

      When you try to launch the the previous manager GUI as in step 1 above, you get message:

      The License Manager user interface was removed from Data Services 4.2.2. You can still add, remove, and view license codes through the License Manager command prompt. For more information, see the Administrator Guide.

      The SAP License manager GUI is no more available but the MS-DOS shell batch file can still be used to add; remove licenses.

      To do this, runthe following command from the typical installation directory <C:\SAP\SAP BusinessObjects\Data Services\bin>:

      LicenseManager.bat -options

      regards,

      Mike

      (EIM Data Services Moderator)

  • Hello Patrick,

    Did you use Information Platform Services or BOBJ BI platform for Data Services 4.2 installation.

    We want to use our existing BOBJ BI platform 4.1 instead of Information Platform Services, but we are running into issue.

    We are installing Data Services 4.2 SP5 on a separate physical server in the same network where we have BOBJ BI platform 4.1 server.


    But when we enter the BOBJ Server CMS Name and credentials during DS 4.2 Installation, We receive a message in Data Services Installation that it cannot find any local SIA Nodes. We are able to ping and telnet both the servers back and forth, so no network issues.

    1. Do we need to install DS 4.2 on the same physical server as BOBJ BI Platform?

    2. OR Do we need to install Information Platform Services for DS 4.2 install

    Can you please advise.

    Thank you very much

    Suman

    • Best practice is to install the IPS so that your Data Services jobs don’t interfere with your reporting. 

      If you are going to use the existing BOBJ platform, make sure that you have extra memory and processors available to handle the extra load.  In this case you’ll need to install the server part of DS on the same server as BODS or on a separate server where you’ve already installed BOBJ and clustered it with your existing system.  You can have an “empty” SIA on this new server that does not include any of the BOBJ servers.

      -Dell

      • Hello Dell,

        Thank you for the prompt response and advise.

        In our case we have BOBJ BI Platform on a separate physical server.

        We are trying to install Data Services 4.2 on a separate physical server. When we enter the credentials for BOBJ server CMS during  DS4.2 installation, we get this message (See images below).

        We are not sure why DS 4.2 is unable to connect to our BOBJ CMS Server.

        Can you Please advise 🙂

        bobj Server.png

        DS42.png

        Thank you

        Suman

        • There are two parts to the DS Install, the first of which involves installing the server components on a server that already has an SIA installed.  This includes the Data Services APS.  If you’re going to run the web server only on the BOBJ web server, you also need to install the DS Management Console there.  I also install the Data Direct ODBC drivers there. 

          After that’s installed, I install everything except the DS Management Console and the Data Services APS on the DS server.

          -Dell

          • Thank you very much Dell for such a prompt response 🙂

            Is there a separate install program for installing the server components of DS on a BOBJ server that already has an SIA installed.

            Is this documented by SAP anywhere?

            Can you please point me to the source so that I can discuss with our team here.

            Thank you very much 🙂

            Suman

          • You use the same install for both, just select different components in the install.  I’m not sure about documentation from SAP – I just worked with a couple of our other consultants who have done a lot of these installs to make sure I was setting it up correctly for my client.

            -Dell

          • Hello Dell,

            Thank you very much for the details 🙂

            Yes, SAP also confirmed the same and sent a note that refers to your advise.

            Thank you very much and we will continue the install 🙂

            1690203 – No valid local SIA nodes exist for the given CMS connection information – Data Services 4.x


  • Dear Experts,

    For self study purposes am trying to install Sap data Service 4.2.

    Where can I host a server for sap data services management console and CMS?

    Thats the only question

     

    Thanks

     

    Rabie

  • Yes.  BODS can be install all on one server, Windows 2012 be one, for sandbox and Dev environments.  Not recommended for prod.  Obviously the server will also host the databases for repos as well as the CMS/Audit DBs –  one main reason why  you would not normally deploy everything on one server for prod.

     

  • Good Morning

    I am installing Data Services 4.2 SP9 on a client laptop with S.O Windows 10 64-bit, the installation finishes without problems, but when you run the program, it does not show anything.
    In the Event Viewer it shows the following message:

    – System

    – Provider

    [ Name] Application Error

    – EventID 1000

    [ Qualifiers] 0

    Level 2

    Task 100

    Keywords 0x80000000000000

    – TimeCreated

    [ SystemTime] 2020-02-03T14:27:30.425391900Z

    EventRecordID 26396

    Channel Application

    Computer LAPTOP-UVUMFV1O

    Security

    – EventData

    AL_Designer.exe
    14.2.9.2045
    5bc061d2
    ucrtbase.dll
    10.0.18362.387
    4361b720
    c0000409
    000000000006db8e
    211c
    01d5da9e0f02005d
    C:\Program Files (x86)\SAP BusinessObjects\Data Services\bin\AL_Designer.exe
    C:\windows\System32\ucrtbase.dll
    7d37ca29-09f8-4b7e-aed6-cadc08ce8684

    Please, your comments, Thank you.

    Regards,

  • Dear Patrick,

     

     

    Its a great guide very in  details. Appreciate if you  can share 2nd part as well.

     

    Regards

    Ken Jason Raj

  • Hi,

    Getting below error while installing BODS 4.2 SP13 on CMS of IPS 4.2 Patch 7.6 on RHEL with Database as Hana 2.0 Sp4 : IPS installation was successful. However while installing BODS, getting dump error just after providing CMS database details

    18:02:11.931 fullSourceName is set to: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/DSDialogs.pm

    18:02:11.931 sourceEntryPoint is set to: CMSInfo

    18:02:11.931 BasicStringLib: UI text not loaded.

    18:02:11.931 BasicStringLib: UI text not loaded.

    18:02:11.932 BasicStringLib: UI text not loaded.

    18:02:11.932 Error: Identifier not found in lookup: #CMSText1#

    18:02:11.932 BasicStringLib: UI text not loaded.

    18:02:11.932 Error: Identifier not found in lookup: #CMSText1#

    18:02:11.932 BasicStringLib: UI text not loaded.

    18:02:11.932 Error: Identifier not found in lookup: #CMSText3#

    18:02:11.932 BasicStringLib: UI text not loaded.

    18:02:11.932 Error: Identifier not found in lookup: #CMSText3#

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #System#

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #System#

    18:02:11.933 Push formtemplate line: {{DSCMSSystem!!!!}}[__60,60__(DSCMSSystem)]

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSUser#

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSUser#

    18:02:11.933 Push formtemplate line: {{DSCMSUser!!!!}}[__60,60__(DSCMSUser)]

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSPassword#

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSPassword#

    18:02:11.933 Push formtemplate line: {{DSCMSPassword!!!!}}[**60,60**(DSCMSPassword)]

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSAuthentication_UNIX#

    18:02:11.933 BasicStringLib: UI text not loaded.

    18:02:11.933 Error: Identifier not found in lookup: #CMSAuthentication_UNIX#

    18:02:11.933 Push formtemplate line: {{DSCMSAuth!!!!}}[__10,10__(DSCMSAuth)]

    18:02:11.933 Dump template contents …

    18:02:11.933 #System#

    18:02:11.933 {{DSCMSSystem!!!!}}[__60,60__(DSCMSSystem)]

    18:02:11.933 #CMSUser#

    18:02:11.933 {{DSCMSUser!!!!}}[__60,60__(DSCMSUser)]

    18:02:11.933 #CMSPassword#

    18:02:11.933 {{DSCMSPassword!!!!}}[**60,60**(DSCMSPassword)]

    18:02:11.933 #CMSAuthentication_UNIX#

    18:02:11.933 {{DSCMSAuth!!!!}}[__10,10__(DSCMSAuth)]

    18:04:11.095 Error: Couldn’t open library ‘/opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators’.  Error message: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators: cannot open shared object file: No such file or directory

    18:04:11.095 Error: Couldn’t open library ‘/opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators’.  Error message: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/libUIDSValidators.so: cannot open shared object file: No such file or directory

    18:04:11.095 Error: Assert(functionPointer) failed in file ValidatorUtils.cpp line 112

     

    Error and Warning Log:

    Error and warning logs

    Error: Property replacement not found in ‘[$available.langpack.langs]’: $available.langpack.langsError: Dialog uitext not found in: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/setup.ui.framework/uitext/dialog/CMSInfo.dialog.lang_en.uitext.xmlError: Could not load dialog uitext file for the following locale: en. Defaulting to English.Error: UI Text file doesn’t exists: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/setup.ui.framework/uitext/dialog/CMSInfo.dialog.lang_en.uitext.xmlError: Identifier not found in lookup: #CMSText1#Error: Identifier not found in lookup: #CMSText1#Error: Identifier not found in lookup: #CMSText3#Error: Identifier not found in lookup: #CMSText3#Error: Identifier not found in lookup: #System#Error: Identifier not found in lookup: #System#Error: Identifier not found in lookup: #CMSUser#Error: Identifier not found in lookup: #CMSUser#Error: Identifier not found in lookup: #CMSPassword#Error: Identifier not found in lookup: #CMSPassword#Error: Identifier not found in lookup: #CMSAuthentication_UNIX#Error: Identifier not found in lookup: #CMSAuthentication_UNIX#Error: Couldn’t open library ‘/opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators’.  Error message: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators: cannot open shared object file: No such file or directoryError: Couldn’t open library ‘/opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/UIDSValidators’.  Error message: /opt/bods/DS_42_LNX64/dunit/product.dataservices64-4.0-core-32/actions/libUIDSValidators.so: cannot open shared object file: No such file or directoryError: Assert(functionPointer) failed in file ValidatorUtils.cpp line 112

     

    Please suggest..What might have gone wrong…

    Thanks & Best Rgds,

    Kiran