Skip to main content

Quick Start

Setting Up SQL Connect is a Walk in the Park!

Setting Up SQL Connect is a Walk in the Park!

Download and install the software on your Windows or Mac device, and start exploring and querying Oracle Fusion Cloud live data in no time.

If you don’t have an account yet, click on the “SIGN-UP” button to receive your login credentials via email.

With SQL Connect, you’ll be able to quickly extract valuable insights from your Oracle Fusion Cloud data, unlocking its full potential.

Connecting to Oracle Fusion Cloud for the First Time

  • Download and install SQL Connect onto your Windows or Mac device.
  • Launch SQL Connect and navigate to View > Connections.
  • Enter your Oracle Cloud Username, Password, and URL, then click on ‘Create Connection’. And you’re connected!

Once your connection is established, you’ll be able to easily and quickly extract insights from your Oracle Fusion Cloud data.

If you encounter any issues during the setup process, don’t hesitate to refer to the SQL Connect user manual or contact our support team for assistance.

Running your first SQL Query

Follow these simple steps to get started:

  • Make sure you have successfully installed and set up SQL Connect on your device.
  • Navigate to the Query tab in SQL Connect.
  • Enter your SQL query into the provided text box.
  • Click on the blue “Run” icon to execute your query and retrieve results in real-time.

It’s that easy!
With SQL Connect, you’ll be able to quickly and easily query your Oracle Fusion Cloud live data, all with just a few clicks.

If you have any questions or need assistance along the way, our support team is always here to help.

SQL Connect with IntelliSense

SQL Connect is proud to offer a lightning-fast IntelliSense feature for all of your database objects.

With IntelliSense, you’ll be able to write SQL queries with ease and speed by providing you with real-time suggestions for keywords, table names, and columns, as you type.

This powerful feature can help you write accurate and efficient queries in a fraction of the time, all while minimizing the risk of syntax errors.

DB Browser

To browse your database objects directly from Oracle Fusion Cloud using SQL Connect, simply navigate to the “View” tab and select “DB Browser”.

From there, you’ll be able to explore your tables, views, and procedures with ease.

It’s a quick and easy way to access your data and get started on your data analysis.

Multi-line Editing

Multi-line editing in SQL Connect is a powerful feature that allows you to edit multiple lines of code simultaneously, saving you time and effort.

To get started, simply press “Alt + Shift” and then click where you want to start editing. Next, drag your mouse across the lines you want to edit, and you’re ready to go!

With SQL Connect’s intuitive interface and user-friendly design, multi-line editing has never been easier. You can easily navigate between multiple lines and make changes quickly and efficiently. It’s the perfect way to streamline your workflow and get more done in less time.

Setup Advanced Table Level Security

SQL Connect takes database security seriously, offering role-based advanced table-level security to ensure that your data is always protected. With our powerful security features, you can easily manage access to your database objects and ensure that only authorized users can view or modify your data.

Our role-based security model allows you to define specific roles and assign them to users as needed. You can control access at the table level, making it easy to limit access to sensitive data or ensure that only certain users have the ability to modify critical information.

Exporting to CSV, Excel, or HDL

Exporting your Oracle Fusion Cloud data has never been easier than with SQL Connect.

With just a single click, you can export your data to CSV, Excel, or HDL formats, giving you the flexibility you need to work with your data in the format that’s best for you.

Whether you’re looking to share data with colleagues or simply need to manipulate it in a different format, SQL Connect’s export features make it easy to get your data where it needs to go.