DataConnect offers the Full Experience with Oracle. This allows you to create queries using a tile-based drag and drop query builder. The tile-based editor functions with Oracle Native Provider for .NET 4.0, OLEDB and ODBC.
However, automatic joins are currently only supported on Oracle Provider for .NET 4.0 based connections.
We recommend using the Oracle Provider for .NET 4.0 where available.
Create a New Connection
To create a connection to an Oracle server, make sure you are on the Connections tab. Then press the (+) icon at the very left hand side of the window.
Give your Connection a Name
You then need to give your connection a name, and optionally a description.
You then have a choice of connection technologies. We recommend using the Oracle Provider for .NET 4.0 where possible.