Skip to Content
avatar image
Former Member

SAP BI Reporting database oracle config

Dear All,

I have installed the business object 4.2 SP3 with oracle database (cms database) , Now We need to configure Business object reporting database with oracle which is on separate host.

Could you please assist me how to configure the same.

Thanks

Sandeep Mathur

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 05 at 02:02 AM

    Sandeep,

    You will need to install Oracle 12c 32Bit client tool on all the client machines. You will also need to configure the 12c 64bit client of servers using the same System DSN name.

    Steps to follow:

    • Configure the tnsnames.ora file and validate connections from 32bit Oracle client and 64 bit Oracle Clients using SQLNET
    • Next configure the 32bit / 64bit System DSN's on BOBJ Client and BOBJ Servers
    • Create a connection using the either Universe Designer &/or IDT tool
    • validate the connection are working

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05 at 12:43 PM

    You are asking a very basic question - have you read the official product guides ? Data Access guide describes what you need.

    Add comment
    10|10000 characters needed characters exceeded