Skip to Content

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!

 

 

To report this post you need to login first.

29 Comments

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

  1. 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

    (0) 
    1. Patrick Perrier 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?

      (0) 
  2. 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.

    (0) 
  3. 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

    (0) 
    1. Mike Koleosho

      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)

      (0) 
  4. Suman Kollipara

    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

    (0) 
    1. 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

      (0) 
      1. Suman Kollipara

        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

        (0) 
        1. 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

          (0) 
          1. Suman Kollipara

            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

            (0) 
            1. 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

              (0) 
              1. Suman Kollipara

                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


                (0) 
  5. Rabie Hamidi

    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

    (0) 
  6. Juan Quintana

    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.

     

    (0) 

Leave a Reply