Oracle data source

The Oracle data source provides direct access to an Oracle database from a portal.

Note: This data source is designed to work with Oracle's 64bit Oracle Data Access Components for Windows.

Testing was performed using the "64-bit Oracle Data Provider for .NET 2.0 11.2.0.3.0" installed by the "64-bit ODAC 11.2 Release 5 (11.2.0.3.20) for Windows x64" package from Oracle. At the time of testing, this package was found at: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

Testing was performed against an installation of Oracle Database 11g Express Edition.

The Oracle.ManagedDataAccess NuGet package is included with IPF, so you do not have to install the Oracle client libraries to use an Oracle data source.

This is the general process for using the Oracle data source:

  • Configure the data source for a selected portal using Portal Manager.
  • Use collections from the data source as needed when working with layouts and scripting.