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?