Oracle Database

Parent Previous Next

Oracle Database


Tutorial Video


Oracle Provider System Requirements

  64-bit Operating Systems:

o   64-bit Oracle Data Access Components (ODAC) 12c

  64-bit Oracle 12c Managed Data Access Client installed into the GAC

o   32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c

  32-bit Oracle 12c Managed Data Access Client installed into the GAC

   32-bit Operating Systems:

o   32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio 12c

  32-bit Oracle 12c Managed Data Access Client installed into the GAC


If planning to use both the 64-bit and 32-bit Oracle Provider, it is important to download the same release for both the 64-bit and 32-bit version of the Oracle Data Access Components. That means if downloading the 64-bit ODAC 12c Release 4, then the 32-bit ODAC 12c Release 4 version should be the 32-bit version chosen to download.


Best Practices

BI Compare

Documentation

Lineage

Data Dictionary

a

b


a Best Practices rules can be analyzed for the Oracle Database provider once the user has created User Defined Best Practices


b Data Dictionary categories can be applied to the Oracle Database provider once custom paths have been created


Getting Started

1.   After creating a solution, click the "Add" button on the right side of the page


2.   Give the solution item a meaningful name


3.   Select the Oracle provider from the source type drop down

4.   Provide a valid data source a credentials



5.   You may also customize your documentation by adding filters


Important Note:

Excluding certain types may affect Lineage Analysis.



6.   Click "OK" to add the Oracle Database to the Solution Items window


Sample Output:

In the documentation you can drill into the server to view a list of schemas as well as a summary of what each schema contains.



You can drill into a specific schema to view a list of tables, procedures, views and more.



Table documentation provides table properties and the table definition.