Using Information Worker Demo with Oracle VM VirtualBox

This is my third article about using the preconfigured 2010 Information Worker Demonstration and Evaluation Virtual Machine (SP1).

I think I've found the final solution, or better, I've found a sequence of exceptional blog postings describing how to use it with Oracle VM VirtualBox in very deep detail:

SQL Server: how create a linked server to Oracle

The steps to create a new linked server to access Oracle data from SQL Server are:

  1. install the Oracle client drivers on the SQL Server machine;
  2. install the Oracle client ODAC (Oracle Data Access Components);
  3. in the linked server providers, configure the OraOLEDB.Oracle provider to allow Inprocess.

Now you can choose:

Finally: you have to configure the security, i.e. the login used to access the Oracle server.

About the two final steps: you can use the SQL Server Management Studio (as described in the first link) or via stored procedures (as in the second link).