Oracle® Fusion Middleware Desktop Integration Developer's Guide for Oracle Application Development Framework 11g Release 1 (11.1.1) E10139-03 |
|
![]() Previous |
![]() Next |
This chapter provides an introduction to ADF Desktop Integration.
This chapter includes the following sections:
Many end users of Fusion web applications use desktop applications, such as Microsoft Excel, to manage information also used by their web application. ADF Desktop Integration provides a framework for Oracle Application Development Framework (Oracle ADF) developers to extend the functionality provided by a Fusion web application to desktop applications. It allows end users to avail themselves of Oracle ADF functionality when they are disconnected from their company network. End users may also prefer ADF Desktop Integration because it provides Excel's familiar user interface to undertake information management tasks, such as performing complex calculations or uploading a large amount of data, easily and seamlessly.
ADF Desktop Integration is a part of the Oracle ADF architecture. More information about the Oracle ADF architecture can be found in the "Oracle ADF Architecture" section of the Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework.
Figure 1-1 illustrates the architecture of ADF Desktop Integration, which comprises of the following components:
ADF Desktop Integration add-in
ADF Desktop Integration remote servlet
ADF Model layer
For more information about ADF Desktop Integration, see the ADF Desktop Integration page on Oracle Technology Network (OTN) at:
http://www.oracle.com/technetwork/developer-tools/adf/overview/index-085534.html
Currently, ADF Desktop Integration supports integration with Microsoft Excel 2007, and other higher versions of Microsoft Excel.
Creating an integrated Excel workbook involves the steps described in Table 1-1.
Table 1-1 Steps to Create an Integrated Excel Workbook
Use | To |
---|---|
JDeveloper |
Create a Fusion web application. For information about creating a Fusion web application, see the Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework. |
Add data controls that expose the elements you require in Microsoft Excel. |
|
Create page definition files that expose the Oracle ADF bindings to use in Excel. For more information, see Section 4.3, "Working with Page Definition Files for an Integrated Excel Workbook." |
|
Excel |
Create the Excel workbooks that you intend to configure with Oracle ADF functionality. For more information, see Section 4.4, "Adding Integrated Excel Workbook to a Fusion Web Application." |
Configure the Excel workbook using the Oracle ADF bindings that you exposed in the page definition files and the Oracle ADF components that ADF Desktop Integration provides. For more information, see the following sections and chapters:
|
|
Test your integrated Excel workbook. For more information, see Chapter 13, "Testing Your Integrated Excel Workbook." |
|
Once you complete the integration of your Excel workbook with your Fusion web application, you deploy it to make it available to your end users. For information about this task, see Chapter 14, " Deploying Your Integrated Excel Workbook." |
Advantages that accrue from integrating Microsoft Excel workbooks with your Fusion web application include:
Providing end users with access to data and functionality hosted by a Fusion web application through a desktop interface (Microsoft Excel) that may be more familiar to them.
Users can access data hosted by a Fusion web application while not connected to the application. They must log on to the Fusion web application to download data. Once data is downloaded to an Excel workbook, they can modify it while disconnected from the Fusion web application.
Bulk entry and update of data may be easier to accomplish through a spreadsheet-style interface.
End users can use native Excel features such as macros and calculation.