Deploy SAP BusinessObjects BI platform or Information platform services and SAP Data Services 4.x in Microsoft SQL Server 2012 Database
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:
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.
When the prerequisite system check completes successfully, click Next
On the “SAP BusinessObjects BI platform 4.0 SP4 setup” page, click Next
Type the information required for the Full Name, Organization, and Product Keycode boxes, and then click Next
Click Next to accept the default language (English)
Click Custom/Expand, and click Next
Click Next to accept the default path to the folder where the program will be installed.
Recheck the services as per your requirement
Expand Platform Services, and clear the Integrated Database check box.
On the “Expand Installation” page, click Start a new SAP BusinessObjects BI Platform deployment, and click Next.
For use as the CMS database, click Microsoft SQL Server using ODBC, and click Next
For use as the auditing database, click Microsoft SQL Server using ODBC, and click Next
In the Node Name box, type the SIA name, leave the default SIA port to 6410, and then click Next
Leave the default port for the CMS to 6400, and click Next
Type a password for the CMS Administrator account, type the cluster key, and click Next.
Type the login credentials for the CMS database, and click Next.
Type the login credentials for the Audit Database, and click Next.
Make sure the Start server upon installation check box is selected, and click Next
Leave the default port for the Tomcat to 8080, 8005 & 8443, and click Next
Leave the default port for the HTTP listening Port to 6405, and click Next.
Specify a port for the LCM repository, type the password for the Repository User account, and then click Next
Click Do not configure connectivity to SMD Agent, and click Next.
Click Donot Introscope Intergation and click Next.
To start the installation, click Next.
Installation Finish
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
On the “Information Platform Services 4.1 SP2 setup” page, click Next
Accept the License Agreement, and click Next
Pass existing CMS Information, and click Next
To start the installation, click Next
Installation Finish
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
On the “SAP Data Services 4.2 SP1 setup” page, click Next
Accept the License Agreement, and click Next
Enter the Product Key details
Click Next to accept the default path to the folder where the program will be installed
Click Next to accept the default language (English)
Specify CMS Connection information
Click Yes to restart all services
Select Installation type & click on Next
Select Feature & click on Next
Skip DS Config file & Click on Next
Select login information and click on Next
To start the installation, click Next
Feature Summary, Click on Next
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
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
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!
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