0 Replies Latest reply: Jun 27, 2013 5:59 PM by user1129606 RSS

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

    user1129606

      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