ADF Desktop Integration with Excel

Oracle's Application Development Framework (ADF) Desktop Integration provides various ways to integrate desktop applications like Microsoft Excel with ADF. This integration allows for a seamless connection between Excel spreadsheets and the business logic of web applications. Users gain the ability to access and edit business data directly within Excel, leveraging the familiar spreadsheet environment while maintaining the integrity and security of the data through the ADF infrastructure.

Creating Custom Spreadsheets

Developers can use ADF Desktop Integration to build custom spreadsheets that allow users to interact with business data. By utilizing the tools provided by ADF, spreadsheets can be designed to perform specific tasks and to handle data in a way that aligns with the business processes implemented in the web application.

Integrating with Web Application Infrastructure

ADF Desktop Integration ensures that the spreadsheets created are not standalone but are integrated with the web application's security and business logic infrastructure. This means that any interaction with the data within Excel will adhere to the same rules and permissions as if it were being done through the web application itself.

Editing Data Offline

One of the key features of ADF Desktop Integration is the ability to edit data without requiring a live network connection. This is particularly useful for users who need to work remotely or in environments with unreliable internet access. Any changes made can be stored locally and then synchronized with the application's backend once the user reconnects to the network.

Validating Changes on Reconnection

When the network connection is re-established, ADF Desktop Integration can upload and validate the user's changes against the application's backend. This step ensures data integrity and consistency by applying the same validation rules as the web application, providing a robust and reliable experience for end-users.

Integrating ADF Desktop with Sourcetable

Integrating ADF Desktop with Sourcetable instead of Excel offers numerous benefits, particularly in terms of data synchronization, automation, and business intelligence capabilities. Unlike Excel, Sourcetable can seamlessly sync your live data from a wide array of applications or databases. This means that the data in Sourcetable is always up-to-date, minimizing the risk of decisions made on outdated information.

With Sourcetable, the process of pulling in data from multiple sources is automated, which significantly reduces the manual effort required to import or export data as is often the case with Excel. This automation not only saves time but also decreases the potential for human error during data transfer. As a result, teams can rely on the accuracy of their data and focus on more strategic tasks.

Moreover, Sourcetable's user-friendly spreadsheet interface allows users to query and manipulate data without the need for complex database knowledge. This empowers team members to engage in business intelligence activities, generate insights, and make informed decisions without the steep learning curve that more sophisticated BI tools may require.

By integrating ADF Desktop with Sourcetable, organizations benefit from a powerful combination of live data synchronization, streamlined workflows, and enhanced data-driven decision-making capabilities, all within an accessible and familiar spreadsheet environment.

Common Use Cases

• A

  
  Create a valid user session within Excel for a Fusion web application
• A

  
  Download data from a Fusion web application into Excel
• A

  
  Display web pages from a Fusion web application within Excel
• A

  
  Validate and test the integrated Excel workbook for data entry
• A

  
  Publish and deploy the integrated Excel workbook

Frequently Asked Questions

How do I install the ADF Desktop Integration Add-In for Excel?

You must download the installer adfdi-excel-addin-installer-current-user.msi using the ATK_DOWNLOAD_DESKTOP_INTEGRATOR_PRIV privilege and run it to install the Excel Add-In.

Can I work on my data offline using ADF Desktop Integration with Excel?

Yes, you can access and edit your business data without a live network connection and upload your changes when you reconnect to the network.

Do I need to update the ADF Desktop Integration Add-In with each new release of Oracle Fusion Cloud Applications?

Yes, the ADF Desktop Integration Add-In is updated with each release, and it's recommended to install the latest version when prompted.

What are the system requirements for installing the ADF Desktop Integration Add-In?

You need to have the appropriate version of Excel and Windows to install the add-in.

Is it possible to install the ADF Desktop Integration Add-In for all users on a machine?

Yes, installing the add-in for all users is possible if you have administrator privileges.