Skip to Content
Author's profile photo Patrick Perrier

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!

 

 

Assigned Tags

      36 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ABHISHEK SINGH
      ABHISHEK SINGH

      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

      Author's profile photo Patrick Perrier
      Patrick Perrier
      Blog Post Author

      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?

      Author's profile photo Rashmi Sharma
      Rashmi Sharma

      Try different port ( SQL Server default is 1433... so i tried 0,1434, 1435 ..and one of them worked)

      Author's profile photo WILLIAM MARCY
      WILLIAM MARCY

      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.

      Author's profile photo Rajesh Ghosh
      Rajesh Ghosh

      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

      Author's profile photo Patrick Perrier
      Patrick Perrier
      Blog Post Author

      Thanks Rajesh,

      Creating the Repositories and configuring the JS are the topics of Part 2.

      I'm hoping to complete it in the next couple of days.

      Author's profile photo Anand Katdare
      Anand Katdare

      Please share the link of Part 2, without which its of no use.

      Author's profile photo Ina Felsheim
      Ina Felsheim

      Thanks for the step-by-step install instructions for Data Services and Data Quality.

      Author's profile photo Patrick Perrier
      Patrick Perrier
      Blog Post Author

      Thanks Ina, you're welcome!

      Feel free to "like" and rate it 😉

      Author's profile photo Michael vasanth
      Michael vasanth

      Thanks, It was very helpful

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai

      Informative. Thanks for sharing Patrick.

      Author's profile photo Former Member
      Former Member

      Hi Patrick,

      could you please share the post installation steps for Bods.

      Thanks,

      RAjiv

      Author's profile photo Former Member
      Former Member

      Thank you. I am unable to find Part 2 - could anyone share that?

      Author's profile photo Deepak K Gupta
      Deepak K Gupta

      Part -2 for this blog is awaited, help with the link, Thanks.

      My Best !

      Deep

      Author's profile photo Former Member
      Former Member

      Hi Patrick

      Can you please provide any guidance or doc to install DS on 4.2 SP3 on Sybase and Linux ?

      Thanks

      Rabi

      Author's profile photo Former Member
      Former Member

      Hi Patrick,

      this seems very helpful. Please what about the part 2 of your step by step installation and configuration guide.

      Thanks

      Jürgen

      Author's profile photo Former Member
      Former Member

      hi Patrick,

      can you help me out in installing data services 4.2 on linux?

      can you send me some documents?

      regards,

      Dharshith S

      Author's profile photo Cornelius Knall
      Cornelius Knall

      Hi, not very usefull without part 2

      Author's profile photo jorge velasquez
      jorge velasquez

      Hi,

      If I install a temporary license key for Data Services. To install the final one should be do it via CMC?

      Regards

      Author's profile photo Former Member
      Former Member

      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)

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Dell Stinnett-Christy
      Dell Stinnett-Christy

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Dell Stinnett-Christy
      Dell Stinnett-Christy

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Dell Stinnett-Christy
      Dell Stinnett-Christy

      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

      Author's profile photo Former Member
      Former Member

      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


      Author's profile photo Former Member
      Former Member

      I can't see  the step by step of DS installation.. Would you tell me what happened with this?

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Martin Eckhardt
      Martin Eckhardt

      Does it also works on Windows Server 2012 R2 ?

      Thanks in advance.

      Martin

       

      Author's profile photo Former Member
      Former Member

      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.

       

      Author's profile photo Soporte Crystal
      Soporte Crystal

      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,

      Author's profile photo Vyacheslav Zhukovskiy
      Vyacheslav Zhukovskiy

      We have the same problem. Some old files block a new installation.

      I don't know how to detect them and delete.

      Author's profile photo Dirk Venken
      Dirk Venken

      Have you checked SAP Notes 2367862 and 2688938?

      Author's profile photo ken raj
      ken raj

      Dear Patrick,

       

       

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

       

      Regards

      Ken Jason Raj

      Author's profile photo Kiran Sathyan
      Kiran Sathyan

      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