Migration of SAP Business Objects BI Platform 4.1 from Windows(OS), SQL Server(DB) to AIX(OS) and Oracle(DB).

[Former Member]

Dear All,

I have SAP Business Objects BI Platform 4.1  running on window servers and sql server database. We want to migrate this to  AIX and oracle.

Can you please share what should be the best approach to carry on this migration?

Regards,

Asleh

[DayaJha · Accepted solution]

Hi Mohammed,

Regarding your Query below is the suggestion:

Step I: Preparing for moving BOBJ application from Windows to AIX

There are some tasks that you need to perform:

To configure the existing deployment

• Perform inventory and cleanup, to ensure that only the required content is moved.
• Run the Repository Diagnostic Tool to detect any inconsistencies between the File Repository and the CMS repository. The upgrade management tool will not run successfully if there are inconsistencies between the File Repository and the CMS repository.
• Identify any content that the upgrade management tool can't upgrade, along with the process required to upgrade that content. There is some content like Voyager Workspaces or Desktop Intelligence documents that require manual intervention before running the upgrade management tool.
• Back up existing repositories, including the system database and the Input and Output File Repository Servers.
• Back up custom web applications, HTML pages, and scripts in your existing deployment.

To configure the planned BI 4.x deployment

• Setup and configure the Middleware and ODBC connections.
• Ensure that your machines meet the deployment system's requirements, you can find information about the supported platforms in the Platform Availability Matrix (PAM) http://service.sap.com/support -> Help and Support -> SAP BusinessObjects Support -> Documentation -> Supported Platform s/PARs -> SAP BusinessObjects BI 4.x

Step II:

• You can use database backup & FRS backup (Offline) in new environment (AIX) to deploy BOBJ 4.x Version
• Take the help of DBA to move CMS & AUDIT database backup from SQL Server (Windows) to Oracle (AIX)
• Test the Universe,reports, Check the rights

Step III:

• If you are configured any SSO then make sure that same configuration is deployed in new environment (AIX).
• Test the user SSO in new environment (AIX).

Or

• You can also use Promotion manager to move the contenet from Windows (Business Objects Application) to UNIX (Business Objects Application)
• Only prerequisite is Business Objects Application version should be same.
• You can copy content only 50 Object at a time in One Job
• FRS Offline backup is required.
• Necessary files regarding custom web applications, HTML pages, and scripts in your existing deployment.

Please refer the below KBA for more details

BOBJ Deployment Link:
http://wiki.scn.sap.com/wiki/display/BOBJ/Application+Server

BIP on Linux with Tomcat and Sybase ASE Pattern Book
http://wiki.scn.sap.com/wiki/display/BOBJ/BIP+on+Linux+with+Tomcat+and+Sybase+ASE+Pattern+Book

Installing SAP BI 4.1 SP01 on Red Hat Enterprise Linux 6.x Step-by-step
http://scn.sap.com/community/bi-platform/blog/2013/11/06/installing-sap-bi-41-sp01-on-red-hat-enterp...

Promotion Manager KBA:
http://wiki.scn.sap.com/wiki/display/BOBJ/BI4+Upgrade+and+Promotion+Management+KBAs

Hope this will help!!!!

Thanks,
Daya

[Former Member · Accepted solution]

Hello,

Adding some points!

In general, you could proceed as below:

1) Install the BI product in the AIX server using Oracle or the default database.

2) To restore the original repository into the new server, use the cmsdbsetup.sh to copy the CMS database content from the original server into the new oracle schema and copy Filstore folder, check KBA 1275068 for more help with the backup/restore.

Thanks & Regards,

Insaf

[Former Member]

Thanks Daya and Insaf for your reply.

I will proceed with POC keeping your suggestion in mind. I will keep posted here.

Thanks and regards,

Asleh