Toad Data Point 2025 R2 - Release Notes

Create Oracle Fusion Connections

Toad allows you to connect to Oracle Fusion data in a read-only mode, facilitating easier viewing, exporting, and analysis of the data.

.

After creating a connection, see About Business Intelligence and NoSQL Data Sources for more information about this data source.

Note: This feature is available in the Toad Data Point Professional Edition only.

To create an Oracle Fusion connection

1. Click on the Connections toolbar (ALT+F+N).
2. Select Oracle Fusion from the Group list.

3. Enter the connection information in the Create New Connection dialog. Review the following for additional information:

   URL	Enter the full URL address for the Oracle Fusion service to which you want to connect.
   Username	This is the default authentication that utilizes the Fusion App user account. Enter the user name to use when connecting.
   Password	If using the default authentication method that utilizes the Fusion App user account, enter the password to use when connecting.
   Single Sign-On	If using SSO, this checbox needs to be selected. This method utilizes a browser-based login flow managed by your corporate SSO provider.
   Forget User	The Forget User button removes cached user information, ensuring that the next time you connect, Toad Data Point will prompt you to authenticate again through the SSO login page.
   Category	(Optional) Select an existing category or create a new one. Set Connection Categories
   Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature. Security Options

4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
5. Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.

Tips: 

• Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
• You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.

Limitations of Oracle Fusion connections

Current limitations when using Oracle Fusion in Toad Data Point include, but are not limited to:

• Query Builder and Editor operate in read-only mode - only data retrieval is supported.

• Data Compare is not supported for Oracle Fusion Connections.

• Limited support for publishing objects with Oracle Fusion Connections.

Related Topics

About Business Intelligence and NoSQL Data Sources