Before starting to work with desktop integration you need to configure the various software pieces to support ADF Desktop Integration. This part guides you through the steps to do this.

In order to be able to follow this tutorial you need to load the startup Fusion Web application and check that the application can successfully connect to the database.

These instructions will guide you through this task.

You can install the ADF Desktop Integration add-in from JDeveloper, or from the setup tool provided in <JDEVELOPER_HOME>\jdeveloper\adfdi. This part of the tutorial guides you through installing the add-in from JDeveloper.

1. Start JDeveloper by selecting Start > All Programs > Oracle Fusion Middleware 12.1.3.0.0 > JDeveloper Studio 12.1.3.0.0.

   If the Migrate User Settings dialog box opens, click NO.

2. If prompted for a user role, select Studio Developer (All Features).

   
   

3. Close the Tip of the Day window.

4. The JDeveloper IDE should now be displayed.

   

5. Make sure you do not have any other versions of Oracle ADFdi installed (Control Panel > Uninstall or change Programs) before installing ADFdi 12.1.3.
   From the Tools menu select Install ADF Desktop Integration.

   

6. Let the features load and the installer should start.
   Click Install button once the publisher has been verified.
   

   
   
   

   Click OK and the ADF Desktop Integration installer will continue.
   
   Installing the ADF Desktop Integration add-in starts. Notice that depending on software already installed, you might be prompted to install other mandatory prerequisites and, in some cases to reboot your computer.

7. Once the Microsoft Office customization has been successfully installed, click Close to exit.
   If you have problems with the installation, check to make sure you do not have a different version of Oracle ADF-Desktop Integration is installed. Check Windows Uninstall Programs in the Control Panel.

   

You need to configure Microsoft Excel settings to make it accessible from ADF Desktop Integration. You only need to perform this procedure once for a given installation of Excel. The following steps may be a bit different, depending on the versions of Windows and MS Office on a given machine. Installation of ADFdi must be done by the same Windows account that will use ADFdi.

1. On your desktop, click the Start button.

   

2. In the Start menu, select All Programs > Microsoft Office > Microsoft Office Excel 2007 (or 2010).

   

3. Once Microsoft Excel has started, click the Office button.

   

4. In the Office window, click Excel Options.

   

5. In the Excel Options window, click the Trust Center tab, then click the Trust Center Settings button.

   

6. In the Trust Center window, click the Macro Settings tab, then check the Trust access to the VBA project object model checkbox. Click OK.

   

7. Back in the Excel Options window, click OK.

   

8. Back in Excel, Close the workbook.

The startup application is provided to enable you to get started with ADF Desktop Integration as quickly as possible. If you missed loading it earlier, you can use this link to download the zip file. Just unzip it into a temp directory.

1. Back in JDeveloper, click the Open Application link (or Select File > Open from the main menu).

   

2. In the Open Application dialog, open the folder where you unzipped the adfdi_bc.zip file, and select the ADFdi_BC.jws file. Click Open.

   

   If prompted to migrate the application from a previous version, accept to proceed.

3. Once the application has loaded, you should see two projects in the Applications window. The Applications window should look as follows:

   

4. Click the Save All icon on the JDeveloper menu bar, or select File > Save All from the menu.

Your application needs to be able to connect to a database. A database connection has been created in the startup application. This step guides you through the tasks to check that the database connection in the startup application is able to connect to the database.

1. Right click the Model project and select Project Properties.

   

2. Click the Edit icon next to the Connection field.
   
   

3. In the Edit Database Connection dialog, check the following values (and amend if necessary):

   Property	Value
   Connection Name	HRConn
   Connection Type	Oracle (JDBC)
   Username	hr
   Password	hr
   Save Password	(checked)
   Driver	Thin
   Host Name	(your host, example: localhost)
   JDBC Port	(your port number, example 1521)
   SID	XE (or your database SID)

   

4. Click the Test Connection button and verify the success of the connection parameters.

   

   Click OK and OK again to return to the Applications window.

5. Expand the Model project nodes to view all existing Business Components. The Applications window should now look as follows:

   

6. Right click the AppModule node and select Run from context.

   

7. The Oracle ADF Model Tester launches.

   The Business Component Browser is invaluable for testing and debugging Business Components applications. It is important to verify that the startup application is working before moving further with the tutorial. The browser enables you to test that the Business Components are working correctly and that the application can retrieve data from the database.
   

8. Double click the DepartmentsView1 node to display departments data.

   

9. Click the right arrow to browse department information.

   
   
   

   Close the Business Component Browser window.

10. Click Save All on the JDeveloper menu bar, or select File > Save All from the menu.

You have now set up your development environment and you are ready to start developing ADF Desktop Integration-enabled Excel workbooks.