Back to Index |

ODP.NET - Oracle Data Provider for .NET

Setup Requirements for ODP.NET in BlueSky Integration Studio

BlueSky Integration Studio currently does not distribute the ODP.NET class library provided by Oracle. To obtain the ODP.NET data provider, please visit Oracle's website at: http://www.oracle.com/technology/tech/dotnet/index.html

The minimum requirements for ODP.NET are:

1. You must have an the suitable Oracle client installed on the BlueSky Integration Studio Server or local PC in which you are running.

2. You must download and install the ODP.NET component from Oracle's website.

Telling BlueSky Integration Studio that you have ODP.NET

Once you have the ODP.NET component installed, you simply need to reference the object from within the BlueSky Integration Studio References dialog. This dialog allows you to reference 3rd party, or custom developed .NET components from within any BlueSky Integration Studio job.

1. Select the Build menu, then select References

2. You will see the dialog window below. Click the Browse button, and go into the $Oracle_Home\bin directory where you installed the ODP.NET component.

3. Select the file Oracle.DataAccess.dll. This is the ODP.NET component.

4. Select the Oracle.DataAccess component in the lower window, and click on the Get Metadata button. This will extract the metadata for the classes, properties and methods so that they can be seen by the Intellisense engine.

5. Click OK.

(more information below this image...)

6. Now you must include the Imports statement. This will be compiled into your BlueSky Integration Studio jobs to tell them to reference the ODP.NET classes.

7. Click on the Build menu, then select the Imports menu option.

8. Enter the following line:

Imports Oracle.DataAccess.Client

9. Click OK

You can now begin using the ODP.NET object in your BlueSky Integration Studio jobs!

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved