Use the procedures in this section to connect to a relational data source.
These are the relational data sources to which you can connect:
Oracle
IBM DB2
Microsoft SQL Server
MySQL
Netezza
Teradata
You may also connect to Oracle BI EE sources as you would relational sources, as either the Presentation Layer or Business Model.
For Presentation Layer connections, you may not see all the corresponding physical tables in the source. You may see views instead.
For Business Model connections, you see the OBI dimensions.
Note: | MySQL, Netezza, and Teradata can be used as a data source if you have installed the appropriate JDBC drivers. See Configuring JDBC Drivers. |
These topics cover the workflow for creating a connection to a relational data source: