Toad Data Point 2025 R2 - User Guide

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. See Set Connection Categories for more information.
   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. See Security Options for more information.

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

Understand

Determine the Best Method to Locate Objects

Toad offers a number of features to assist you in locating objects. The following table provides guidelines based on typical use cases:

Object Explorer

You can view database objects for the current connection with the Object Explorer. This feature is useful for dragging and dropping database objects into an open Editor, Query Builder, or other document window. Right-click the objects in the Object Explorer to access additional features such as multiple tasks and actions.

To open the Object Explorer

1. Select View | Object Explorer.

2. Review the following for additional information:

   Schema (first field)	Select the schema you want to view. You can filter the list of schemas that display. See Filter Databases and Objects for more information.
   Object Filter (second field)	You can quickly set a filter in this field. To do so, enter a name or partial name of an object and press ENTER. Any advanced object filters you set display in this field. You can also perform advanced filtering based on case sensitivity, statistics, or other options. See Filter Databases and Objects for more information. Tip: You can enable an option to filter using regular expressions in Tools | Options | Explorer | General.
   Note: For tables and views, the columns, data types, and comments display at the bottom of this window.

Tips:

• To navigate to a previously selected object, click . You can also click to move to the next selected object.
• To locate objects including procedures, functions, views, variable names and comments in an object's source code, use Object Search. See Search for Objects for more information.
• To use a different method to select objects such as tabs, drop-downs, or a tree view, click .
• To generate reports, export data, create SQL statements, or send objects to the Project Manager, SQL Modeler, or Master Detail windows, right-click the objects and select an option.
• To open the Background Processes window and cancel a query, click the progress bar at the bottom of the window.

Related Topics

Differences in the Database Explorer and Object Explorer