It depends what tools you want to deploy. You may want to use the UDT (Universe Design Tool) to create a UNV or use the IDT (Information Design Tool) to create a UNX.
- Can only be used by WebI
- Only use ONE data source
- Can be used by ALL tools (Crystal Ent, Dashboards, Explorer and WebI)
- Use multi data sources.
First you need to know the basics of each of tools to help you make that decision. You help decide see BI 4.0 Tools Tutorial link
Below is the Link for Creating RDBMS Connection for Backend.
At the time of Connection Selection You need to Select Oracle Client.
and for this First up all you need to install Oracle Client in your machine and Configure oracle Client with the DB Server.
Assuming you are using Universe Designer Tool for Universe Creation, below is the link for Universe Designer Guide to get you started,
Other relevant BO Material can be found at,
Let m e know if this helps...or if any more queries.