What is Oracle ADFDII?

Oracle Application Development Framework Desktop Integration (ADFDII) is a framework designed for Oracle ADF developers. As part of the Oracle ADF architecture, it extends the capabilities of Fusion web applications to desktop environments, particularly integrating with Microsoft Excel 2007 and higher versions. ADFDII enables end users to interact with Fusion web application functionality directly from their desktops, even when they are offline from their company network.

As a software tool, ADF Desktop Integration facilitates the access and editing of business data within spreadsheets, providing a familiar Excel-based user interface for information management tasks. It ensures that any user changes are validated against the application's backend upon reconnection to the network. This integration is especially beneficial for managing large data sets and performing complex data operations within Excel.

The service functionality of ADFDII requires Oracle JDeveloper 12c and an Oracle Database schema. To fully utilize its features, users must run SQL scripts provided with the application, modify database connections in JDeveloper, run the Integrated WebLogic Server (WLS), deploy the application, and use the Component and Feature Demo Workbooks. ADFDII's architecture encompasses the ADF Desktop Integration, the ADF Desktop Integration remote servlet, and the ADF Model layer, ensuring a comprehensive integration experience.

Oracle ADFDII Plugins for Excel

The ADF Desktop Integration Add-in for Excel, commonly referred to as ADFdi, is a tool designed to extend the capabilities of Oracle's Application Development Framework (ADF) to desktop applications, specifically Microsoft Excel. This integration facilitates the creation of spreadsheets that are able to interact with the security and business logic of web applications, thereby enhancing productivity and user experience.

ADFdi is particularly useful for customers who have the ADFdi server component version 4.1.0 or later, as it is designed to be compatible with these versions. It is important to note that this add-in is not compatible with older versions of the server component, which means that users must ensure they have the appropriate server version before attempting to utilize the ADFdi add-in.

The ADFdi add-in empowers end users by allowing them to edit their data in Excel without requiring a live network connection. This offline capability is especially beneficial for users who need to work remotely or are on the move. Once a network connection is re-established, ADFdi can validate the user's changes against the backend, ensuring data integrity and consistency with the web application's business rules.

Common Use Cases

• O

  
  Use case 1: Creating spreadsheets for end users to access and edit business data from desktop applications like Microsoft Excel
• O

  
  Use case 2: Allowing end users to edit data offline and then upload and validate changes against the application’s backend upon reconnection
• O

  
  Use case 3: Integrating Excel with web applications to leverage security and business logic
• O

  
  Use case 4: Using Excel workbooks to edit and view customer and warehouse data from the Summit sample application
• O

  
  Use case 5: Downloading and uploading data between Excel workbooks and the Fusion web application using the ADF Table component

Frequently Asked Questions

What is Oracle ADF Desktop Integration?

Oracle ADF Desktop Integration extends Oracle Application Development Framework to desktop applications like Excel, enabling the creation of integrated spreadsheets for accessing and editing business data.

How does the Oracle ADFDII plugin work with Excel?

The plugin allows integration with Microsoft Excel, letting users develop and utilize integrated spreadsheets to access and edit business data, while maintaining the web application's security and business logic.

Can users edit data when they are offline?

Yes, users can edit data offline and the changes can be synchronized and validated against the application's backend once they are reconnected to the network.

Is there a way to learn how to use Oracle ADF Desktop Integration?

Yes, there is a tutorial available for getting started with ADF Desktop Integration, along with documentation and demos.

What happens to changes made in Excel when reconnected to the network?

Once reconnected, ADF Desktop Integration uploads and validates user changes against the backend, ensuring data integrity and consistency with the web application's business logic.