April – May 2020 Release:

Oracle Cloud Tools SQLConnect Version 2.20.03.008 (Official Build) is released on April 25th, 2020, and adds the following new features to the software. More details for each feature are listed below.

• Single Sign-On support
• Special character Password bug fix
• Ability for dynamic SIGN UP for new users/temporary users or demo users

Single Sign On Support:

Users can now choose to use SSO when setting up new connection to their Oracle Cloud Environments. With SSO you do not need to have an Oracle Cloud HCM/ERP username password. If your organization supports SSO, this will work just like any other SSO supported application.

How to enable SSO with Oracle Cloud SAAS –

When Creating a new connection, instead of Local Login, select “Oracle Cloud SSO Login” radio button (option).

You will be asked to Provide URL to the environment. Once you provide the environment name and press “CREATE CONNECTION” button, you’ll be asked to sign in using your Single Sign On username and Password.

Dynamic User Creation –

If you want to try the software, or add a temporary user to use the SQLConnect app for 15 days – You can not do so using the Sign-Up button that is added in the login window. On the first time launch of the app, select Sign-Up and add your details. This will enable your new user and automatically let you use the SQLConnect app to connect to Oracle Cloud HCM/ERP data. This is valid for 15 days.

January 2020 Release –

Oracle Cloud Tools SQLConnect V2.20.01.009 (January 2020 Release) adds the following new features to the software. More details for each feature are listed below.

• Bind Variables. (Demo of How to use Bind Variables)
• Improved UI
• Bug Fixes

October 2019 Release –

Oracle Cloud Tools SQLConnect V2.19.10 (October 2019 Release) adds the following new features to the software. More details for each feature are listed below.

• Database Browser
• SQL Formatting
• Intellisense
• Enhanced Editor Functions
• Search & Replace
• Slicker Export to CSV and Export to Excel functions
• Connection Pane, DB Browser and other windows actions via menu, to provide more real estate

• Bug Fixes

  1 – Connection window sometimes get stuck and does not disappear. Fixed.
  2 – Visual component do not render on opening multiple tabs at the same time. Fixed.
  3 – Issue with running queries with 1200+ lines. Fixed.

• Other minor enhancements

Database Browser:

Using F4 key on a table name, now you can see the description of that table or view, including column names, types and other relevant information. You can also choose Database Browser by selecting View –> DB Browser menu option.

SQL Formatting:

Right click on any SQL and select SQL Formatting from the context menu.