Purpose:

The purpose of this document is to deploy SAP BusinessObjects BI platform or Information platform services and SAP Data Services 4.x in Microsoft SQL Server 2012 Database

Overview:

Environment Details:

Operating System, Database, SAP Business Objects Application and Web Application Details:

1.PNG

Product Infrastructure Dependency:

Data Services requires SAP BusinessObjects Business Intelligence or Information Platform Services (IPS) for security capability. The following is compatible versions from Data Services 4.2 onwards:

  • SAP BusinessObjects Business Intelligence (BI) 4.1 SP2 or its higher compatible patches* OR
  • SAP BusinessObjects Information Platform Services (IPS) 4.1 SP2 or its higher compatible patches*

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

The Supported Platforms information of BI/IPS 4.x can be found in http://service.sap.com/PAM.

Documentation and supported platforms information for BI also apply to IPS.

Installation Steps of SAP Business Objects Information Platform Services 4.0 SP4:

  • Log in to BI4SERVER as Administrator.
  • Go to the “SAP BusinessObjects” folder, open it, and double-click Setup.exe.
  • On the “Information Platform Services 4.0 SP4 setup” page, select English, and then click OK.

/wp-content/uploads/2014/03/2_411151.png

When the prerequisite system check completes successfully, click Next

/wp-content/uploads/2014/03/3_411155.png

On the “SAP BusinessObjects BI platform 4.0 SP4 setup” page, click Next

/wp-content/uploads/2014/03/4_411156.png

Type the information required for the Full Name, Organization, and Product Keycode boxes, and then click Next

/wp-content/uploads/2014/03/5_411157.png

Click Next to accept the default language (English)

/wp-content/uploads/2014/03/6_411158.png

Click Custom/Expand, and click Next

/wp-content/uploads/2014/03/7_411159.png

Click Next to accept the default path to the folder where the program will be installed.

/wp-content/uploads/2014/03/8_411160.png

Recheck the services as per your requirement

/wp-content/uploads/2014/03/9_411161.png

Expand Platform Services, and clear the Integrated Database check box.

/wp-content/uploads/2014/03/10_411162.png

On the “Expand Installation” page, click Start a new SAP BusinessObjects BI Platform deployment, and click Next.

/wp-content/uploads/2014/03/11_411163.png

For use as the CMS database, click Microsoft SQL Server using ODBC, and click Next

/wp-content/uploads/2014/03/12_411164.png

For use as the auditing database, click Microsoft SQL Server using ODBC, and click Next

/wp-content/uploads/2014/03/13_411166.png

In the Node Name box, type the SIA name, leave the default SIA port to 6410, and then click Next

/wp-content/uploads/2014/03/14_411168.png

Leave the default port for the CMS to 6400, and click Next

/wp-content/uploads/2014/03/15_411169.png

Type a password for the CMS Administrator account, type the cluster key, and click Next.

/wp-content/uploads/2014/03/16_411171.png


Type the login credentials for the CMS database, and click Next.

/wp-content/uploads/2014/03/17_411173.png

Type the login credentials for the Audit Database, and click Next.

/wp-content/uploads/2014/03/18_411175.png

Make sure the Start server upon installation check box is selected, and click Next

/wp-content/uploads/2014/03/19_411176.png

Leave the default port for the Tomcat to 8080, 8005 & 8443, and click Next

/wp-content/uploads/2014/03/20_411177.png

Leave the default port for the HTTP listening Port to 6405, and click Next.

/wp-content/uploads/2014/03/21_411178.png

Specify a port for the LCM repository, type the password for the Repository User account, and then click Next

/wp-content/uploads/2014/03/22_411179.png

Click Do not configure connectivity to SMD Agent, and click Next.

/wp-content/uploads/2014/03/23_411181.png

Click Donot Introscope Intergation and click Next.

/wp-content/uploads/2014/03/24_411183.png

To start the installation, click Next.

/wp-content/uploads/2014/03/25_411184.png

Installation Finish

/wp-content/uploads/2014/03/26_411186.png

Upgradation Steps of SAP Business Objects Information Platform Services 4.0 SP4:

Log in to BI4SERVER as Administrator.

Go to the “SAP BusinessObjects” folder, open it, and double-click Setup.exe.

On the “Information Platform Services 4.1 SP2 setup”

When the prerequisite system check completes successfully, click Next

/wp-content/uploads/2014/03/27_411187.png

On the “Information Platform Services 4.1 SP2 setup” page, click Next

/wp-content/uploads/2014/03/28_411189.png


Accept the License Agreement, and click Next

/wp-content/uploads/2014/03/29_411191.png

Pass existing CMS Information, and click Next

/wp-content/uploads/2014/03/30_411192.png

To start the installation, click Next

/wp-content/uploads/2014/03/31_411193.png

Installation Finish

/wp-content/uploads/2014/03/32_411195.png

Installation Steps of SAP Business Objects Data Services 4.2 SP1:


Log in to BI4SERVER as Administrator.  Go to the “SAP BusinessObjects” folder, open it, and double-click Setup.exe.

On the “SAP Business Objects Data Services 4.2 SP1 setup” page.

When the prerequisite system check completes successfully, click Next

/wp-content/uploads/2014/03/33_411197.png

On the “SAP Data Services 4.2 SP1 setup” page, click Next

/wp-content/uploads/2014/03/34_411198.png

Accept the License Agreement, and click Next

/wp-content/uploads/2014/03/35_411199.png

Enter the Product Key details

/wp-content/uploads/2014/03/36_411200.png

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

/wp-content/uploads/2014/03/37_411202.png

Click Next to accept the default language (English)

/wp-content/uploads/2014/03/38_411203.png

Specify CMS Connection information

/wp-content/uploads/2014/03/39_411205.png

Click Yes to restart all services

/wp-content/uploads/2014/03/40_411206.png

Select Installation type & click on Next

/wp-content/uploads/2014/03/41_411208.png

Select Feature & click on Next

/wp-content/uploads/2014/03/42_411209.png

Skip DS Config file & Click on Next

/wp-content/uploads/2014/03/43_411211.png

Select login information and click on Next

/wp-content/uploads/2014/03/44_411212.png

To start the installation, click Next

/wp-content/uploads/2014/03/45_411213.png

Feature Summary, Click on Next

/wp-content/uploads/2014/03/46_411214.png

Installation Finish


Reference Material:

SAP BusinessObjects Data Services 4.1 Support Package 1 (14.1.1.0)  – Technical Manuals

Links:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo411_ds_tech_manuals_en.pdf

SAP BusinessObjects Data Services 4.1 Support Package 1 (14.1.1.0)  – Upgrade Guide:

Links:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo411_ds_upgrade_en.pdf

Supplement for SAP – SAP BusinessObjects Data Services XI 4.0 (14.0.0):

Links:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ds_sap_en.pdf

Designer Guide – SAP BusinessObjects Data Services XI4.0 (14.0.0):

Links:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ds_designer_en.pdf

Management Console Guide – SAP BusinessObjects Data Services XI 4.0 (14.0.0)

Links:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ds_mgmt_cons_en.pdf

Administrator’s Guide – SAP BusinessObjects Data Services 4.1 Support Package 1 (14.1.1.0)

Links:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo411_ds_admin_en.pdf

Information platform services Installation Guide – Information platform services 4.0 Support Package 4

Links:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo411_ips_inst_unix_en.pdf

Installation Guide for UNIX- SAP Information Steward 4.2 (14.2.0.0)

Links:

http://help.sap.com/businessobject/product_guides/sboIS42/en/is_42_install_unix_en.pdf

Installation Guide for UNIX – SAP BusinessObjects Data Services 4.1 (14.1.0)

Links:

http://help.sap.com/businessobject/product_guides/sboDS41/en/sbo41_ds_install_unix_en.pdf

KBA:

1388363 – Where can I download Data Services software, support packages, and patches?

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

1740516 – Compatibility requirements between DS, IPS, and Cleansing Package

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

1720236 – Available releases and patch levels of Data Services

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

1615646 – After installing Data Services 4.0 the string ???dummy.action.DS.Repository_List.display.name??? is shown in the CMC

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

1739380  Data Services 4.1 installation fails with Microsoft Visual C++ Runtime Error

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

1414816 – How to change log location – Data Services

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

1452165 – How to increase the maximum memory pool for Apache Tomcat used by Management Console – Data Services / Data Integrator

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

1452186 – What is the maximum memory pool limit for Apache Tomcat used by Management Console? – Data Services / Data Integrator

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

1679970 – How to reset the Administrator password in Business Intelligence Platform 4.0

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

1514119 – Error: “CON-120302…ODBC call <SQLDriverConnect> failed…Data source name not found and no default driver specified – DS and IS

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


1243336 – Error: “ODBC call for data source failed….SQL Server does not exist or access denied” when running a job in Data Integrator (DI)

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


To report this post you need to login first.

3 Comments

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

  1. Sing Cheon Chen

    The “Integrated Database” option during IPS installation should be clearly clarified that it is going to be dependent on OS. For Windows, it will install MS SQL Server Lite. For Linux, it will be IBM DB2.

    User/customer/consultant needs to know the maintenance related to IBM DB2 database, and not to assume it is as simple, easy, straight forward as MS SQL Server. Any wrong configuration in Linux kernel will cause DB2 failed to run, or throwing false alarm on login error

    (0) 
  2. Deepak Mohanty

    Hi Daya,

    Thanks for the valuable information!

    I am new to BI platform and I need some help installing BODS in my system. In your post you have mentioned to login to BISERVER and then do the installation steps. So here my understanding is its basically a real time infrastructure. But I am trying to install it in personal Windows Server 2012 and want to use same system for everything (BISERVER,JOBServer,Repository) .How could I achieve that. I installed it in my system and created one job server and repository(SQL Server) and registered it with job server. But I did not get any chance to configure the CMS while installation and when I log in to designer its obvious to ask me the server details to login but I don’t have any. I read and found that if we could configure IPS then we can use it without CMS. Is it correct? Could you please help me in doing this..

    Thanks in advance!

    (0) 
    1. Deepak Mohanty

      Hi Daya,

      I did some RD and found that I have installed the client version of BODS , as a result I did not get any option to configure CMS. Either I need to install IPS or server edition of BODS. How I could get the trial version for DS server edition?

      Deepak

      (0) 

Leave a Reply