Select the Connection Type 'OLEDB Connections' and the Oledb Driver Type of 'Oracle Connection'.
The Data Source is the host name or IP address of the machine running Oracle.
User Id is your username, and Password your password.
Missing IBM DB2 Provider for .NET 4.0
If you attempt to use the IBM DB2 Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.
The message will say:
The DB2 .NET Data Provider cannot be found. Please ensure you have the driver installed and configured correctly.
Contact your system administrator or you can download directly from here:
http://www.ibm.com/support/docview.wss?uid=swg21385217
This driver must be installed on the server where the DataConnect Runtime service is installed.
After installing this driver, you may need to reboot the server.