Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change OBIEE RPD to point from Netezza to Oracle DB as source

user1129606Jun 27 2013

Hi

I have an OBIEE (10g)  RPD and Dashboard implementation that is connecting to Netezza as the primary data source. I need to now source the same data from an oracle database. What steps/planning do I need to do to make this move clean. Some steps that come to mind are:

1. Change connection pools to point towards Oracle data source. 

2. Do I have to rebuild the entire physical layer in RPD because Netezzza supports nvarchar datatype that oracle does not? Can I do  a re import of select objects?

What are the other areas I need to plan for?

Thanks

Comments

user11688070
in workspace go to navigate-->adminster -->classic application administration-->consolidation administration-->then from left menu expand tasks-->click consolidation administration--> click register application. Select the Cluster name and then select the application name and click register.

Kumar
1 person found this helpful
Chanti
If you are not able to follw the above proceedure you do that manually just by entering the same credentials in "HFM Application Registration.exe" that would be placed under "HFM Directory\Server\HFM Application Registration.exe".
1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2013
Added on Jun 27 2013
#bi, #business-intelligence-applications, #connection, #obiee
0 comments
473 views