Skip to Main Content

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2013
Added on Jun 27 2013
0 comments
474 views