Connecting to Oracle

Display data from an Oracle® Database on a Microsoft® SharePoint® page, can be difficult and / or time consuming. Using BCS Meta Man for Windows from Lightning Tools with Microsoft® SharePoint® 2013 or Microsoft® SharePoint® 2010, you can connect to your Oracle® Database and generate a BDC model – External Content Type – without having to write any code. The External Content Type is then used with Business Connectivity Services. This video shows how to generate an External Content Types using BCS Meta Man, for an Oracle® Database without writing any code.

!When you are connecting to an Oracle data source, the correct Oracle Client must be installed on the server where you intend to run BCS Meta Man and the SharePoint environment where you plan to use the BDC model generated by BCS Meta Man.

!Oracle client databases can be downloaded from: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.

For the latest version of the Oracle Data Access Components (ODAC), they can be downloaded from this url – http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html.

We suggest to install 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 if you have Oracle Client 12, or 64-bit ODAC 11.2 Release 6 (11.2.0.4.0) Xcopy for Windows x64 if you have Oracle Client 11.

Creating an External Content Type →
Connecting to Salesforce →