0 Replies Latest reply on Jun 27, 2013 10:59 PM by user1129606

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



      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?