Oracle Queries

Covering Topics on Oracle Queries in a Detailed Way!

Privacy Policy

By Product

Privacy Policy of www.oraclecloudtools.com

At Oracle Cloud Tools, we collect and manage user data according to the following Privacy Policy.

Data Collected

We collect information you provide directly to us. For example, we collect information when you create an account, subscribe, participate in any interactive features of our services, fill out a form, request customer support or otherwise communicate with us. The types of information we may collect include your name, email address, postal address, credit card information and other contact or identifying information you choose to provide.

We collect anonymous data from every visitor of the Website to monitor traffic and fix bugs. For example, we collect information like web requests, the data sent in response to such requests, the Internet Protocol address, the browser type, the browser language, and a timestamp for the request.

We also use various technologies to collect information, and this may include sending cookies to your computer. Cookies are small data files stored on your hard drive or in your device memory that helps us to improve our services and your experience, see which areas and features of our services are popular and count visits. We may also collect information using web beacons (also known as “tracking pixels”). Web beacons are electronic images that may be used in our services or emails and to track count visits or understand usage and campaign effectiveness.

Use of the Data

We only use your personal information to provide you the Oracle Cloud Tools services or to communicate with you about the Website or the services.

We employ industry standard techniques to protect against unauthorized access of data about you that we store, including personal information.

We do not share personal information you have provided to us without your consent, unless:

  • Doing so is appropriate to carry out your own request
  • We believe it’s needed to enforce our legal agreements or that is legally required
  • We believe it’s needed to detect, prevent or address fraud, security or technical issues

Sharing of Data

We don’t share your personal information with third parties. Aggregated, anonymized data is periodically transmitted to external services to help us improve the Website and service.

We may allow third parties to provide analytics services. These third parties may use cookies, web beacons and other technologies to collect information about your use of the services and other websites, including your IP address, web browser, pages viewed, time spent on pages, links clicked and conversion information.

We also use social buttons provided by services like Twitter, Google+, LinkedIn and Facebook. Your use of these third party services is entirely optional. We are not responsible for the privacy policies and/or practices of these third party services, and you are responsible for reading and understanding those third party services’ privacy policies.

Opt-Out, Communication Preferences

You may modify your communication preferences and/or opt-out from specific communications at any time. Please specify and adjust your preferences.

Security

We take reasonable steps to protect personally identifiable information from loss, misuse, and unauthorized access, disclosure, alteration, or destruction. But, you should keep in mind that no Internet transmission is ever completely secure or error-free. In particular, email sent to or from the Sites may not be secure.

About Children

The Website is not intended for children under the age of 13. We do not knowingly collect personally identifiable information via the Website from visitors in this age group.

Changes to the Privacy Policy

We may amend this Privacy Policy from time to time. Use of information we collect now is subject to the Privacy Policy in effect at the time such information is used.

If we make major changes in the way we collect or use information, we will notify you by posting an announcement on the Website or sending you an email.

Database Access In Fusion Cloud Applications

By Product

When is comes to accessing Fusion ERP/HCM Data, there any many ways to do it. Ofcourse if you ask us, we will tell you the best way to do it is using SQLConnect application.

But for those who do not like efficiency, here we are listing a few traditional ways. (My personal suggestion, don’t waste time in reading this – Just buy SQLConnect and gain 20% or more productivity developing with ERP and HCM Cloud)….but if you are still interested, here we go!

You already know that Oracle doesn’t allows you to have direct SQL Access to Oracle cloud applications (ERP/HCM/SCM SAAS). However, you can access most of the data through published APIs and other supported features.

  • Web Services
  • BI Subject Areas
  • BI Publisher
  • File Based Loader Export
  • Product-specific Options
  • ADFDi and Export-to-Excel
  • Oracle BI Applications Configurations Manager
  • and yes, SQLConnect!

Web Services are the recommended method. They allows you not only to get, but also create, update and delete volumes of records. There are RESTful and SOAP services documented in Oracle API Catalog.

Here is a summary of API Support across Oracle SAAS Products.

BI Publisher is another preferred tool to get data out of Oracle cloud applications.

Release Notes

By Product, Support

Email to Request a feature – support@oraclecloudtools.com

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.

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.

SQLConnect User Guide

By Product, Support

Purpose:
Purpose of this user guide is to provide information on how to use the Oracle Cloud Tool’s SQL Connect software. If you are looking for the server-side administration of SQL Connect, please refer to our Administrator Manual.

Online Demo:  https://youtu.be/2X-dQdwzzxs

Installation: SQL Connect installer file will installed SQLConnect.exe on your computer. Once you receive your license information including username and password, install the exe on your computer. Read our FAQ for any issues during installation. For enterprise license, contact your administrator. If you have not already registered for a username/password, then Click on “SIGN-UP” button on the login screen. This will allow you to register and send you an email with Username and Password for login to the application.

CLICK HERE FOR INSTALLATION INSTRUCTIONS

STEP 1 – Download Software (Use one of the links for PROD or BETA version) and Install
STEP 2 – If you do not have a Username / Password – Then click “SIGN-UP” button and you’ll receive an email with credentials., 
How to Use

First Time Launch

After installation is complete, Go to Programs –> SQLConnect –> SQL Connect or Run the executable file SQLConnect.exe.

Application will execute, and you should be able to see the login prompt.

The login information you should have received from your license administrator. In case you are using a trial version, this user name and password will expire after 15 days. For production/live users, this is provided to the license administrator.

These are the login credentials you should have received from your license administrator. In case you are using a trial version, this user name and password will expire after 15 days. For production/live users, this is provided to the license administrator.

Login

On the login screen, enter your username and
password. You should’ve received the username and password with your license.
If you do not have one, please contact the administrator for SQLConnect and obtain login
credentials or use “SIGN-UP” button to register. SQLConnect client can
be used by the user associated to the application on each machine.
  1. Enter User Name
  2. Enter Password
  3. Press the login button.
Note: Login button will be enabled after entering username and
password. If the Login button is greyed out, you must enter the Username and
Password.

  1. After logging in, Click on the Plus sign on the
    Connections options on left pane. If the left pane is not open, click the
    Yellow slider to open left pane.

Creating a new Connection

  1. Create Connection window will open. Enter following
    information in the connection fields.
  1. Oracle Connection Name: Enter the Oracle Connection Name. This is the name you want to save this connection as. In the screenshot above, you can see connections are saved with different names for quick reference.
  2. Oracle Cloud User Name: In the second field, enter your username for Oracle Cloud. This must be a valid user in cloud environment/pod that you want to connect to. Also, this user must have the required role and data access in Oracle. If you are not sure about this, please contact your system administrator.
  3. Password: Enter your Oracle Cloud password. You can use the EYE icon to toggle the visibility of the password.
  4. URL: Enter the URL for your Oracle pod. e.g. http://EEEE.us6.oraclecloud.oracle.com
  5. Once you enter all the fields, the NEXT button should be enabled. Click NEXT To check the connection. If the connection is successful, it will be saved under your connection and you will be connected to the database. If for some reason, the connection is not successful, you’ll get an error. If the system is unable to establish a connection it may spin forever – in which case cancel and close the application.
  6. While using the application, you can select “Connect To” and select the name of the pod form drop-down list.

Opening new tab:

To create new Tab, simply click the + button. You can also open files from File menu to open file in new tab.

Working with Files

You can open one or more files at the same time, by using File –> Open menu option. Also the same menu provides options to SAVE and CLOSE files. You can also click the SAVE icon to save the file.

Running Query

Query can be executed by clicking the EXECUTE button, or pressing CTRL+Enter keys on your keyboard.

Editor functions

Following are some of the shortcuts used for editing purpose:

  • Ctrl-C – Copy
  • Ctrl-V – Paste
  • Ctrl-F – Find
  • Ctrl-Shift-F – Replace
  • F4 – Open DB Browser

User Interface features

The user interface of SQL connect is divided
into five sections.
  1. File Menu & Header
  2. View Menu
  3. SQL (Query) Editor
  4. Left Pane & Controls
  5. Main Menu
  6. Results Pane
In the File Menu, you have options to open,
close and exit from the file and application. You can add multiple tabs, Save
them with different names locally on your file system.
In main menu, you’ll find a button to Execute a
SQL – “Execute”. Options to export the results to “CSV” and “Excel”. You can
also manage the number of items you want to see in each page from the query
results. This defaults to 100. You can also switch connection between multiple
connection using the “Connected To” drop down menu.

View Menu:

View Menu provides you option to Hide/UnHide the Connections Tab, and Database Browser Tabs.

Sizing the panes:

Using the yellow control button, you can hide or
unhide the left pane. Using your mouse controls, you can resize the
panes.

Here is a full video demo for SQL Connect user:

https://www.youtube.com/watch?v=8MNRHoI1tQ0and here is how to use Bind Variables in SQL Connect – https://youtu.be/PhjJ7xFLEtk
SQLConnect Demo

Architecture:

SQL Connect uses
following components to make the product work.
Component Purpose
SQL
Connect User Interface
(SQLConnect.exe)
The Graphical user interface, editor,
that is used by end user to launch and run queries against Oracle cloud. This
is the main user facing executable product for SQL connect.
Query Processing Engine This
is built within the executable to parse, syntax check, validate and convert
the user entered SQL in a format that can be processed by request processor
on Oracle cloud.
BIP
Web Service
A Web Service on Oracle Cloud Business
Intelligence application that is invoked from SQL Connect to establish
communication with Oracle Cloud.
Request
Processor
Key
logic component of SQL connects that interprets the request send by QPE and
processes that in Oracle Cloud to generate result set and send it back to the
BIP Web service
Results/Error
Processor
Component of SQL Connect which renders
results in a format the UI engine can process. It also processes any errors
produced by the request and converts that to user readable format to be
displayed on the UI.
UI
Engine
User
Interface (UI) Engine is the presentation component of SQL connect which
renders results for the user.

Online Demo Request

By Product

Please enter your name and email address below to setup a demo for your team. You can watch the online demo of SQL Connect application below and learn how you can connect with Oracle HCM, ERP, PPM Cloud SAAS Application from your desktop.

Online Demo of SQLConnect

[ninja_forms id=1]

SQL Connect Demo

By Support

Watch this video demonstration for basic functions of Oracle Cloud Tools – SQL Connect application.

– How to create a new connection
– Setting up your queries
– Working with Files
– Saving, Editing and executing queries
– Exporting results

This is demo of the Windows version of SQL Connect

https://youtu.be/8rIkv-f-Hoc

Below Video shows how to create a new connection with Oracle SQL Connect

If you see what you like, Contact us today for a demo of OracleCloudTools SQLConnect, or Buy Now and start using the application to gain productivity Today!


Buy Now!

SQL Connect

By Product

How do you connect to your Oracle Cloud ERP/HCM Database?
If you are using the standard mechanism to do this using Oracle and BI tools – read on. We may be able to save 20% or more of your development and support time – by changing the way you do Adhoc Query against Oracle ERP/HCM Cloud database.

Get your FREE Trial Now! and Start using SQLConnect today.

SQLConnect helps you connect to your Oracle Cloud ERP, Oracle HCM Cloud, Oracle PPM cloud database via standard Oracle API from your desktop. We are Oracle developers at heart. When we started developing with and supporting Oracle ERP/HCM Cloud users, we found various issues that other developers resonate with:

  • EBS developers, who are used to tools like Toad, SQL Developer, etc. lack the ability for rapid SQL queries and analysis with Oracle Cloud.
  • Tools provided within the Oracle BI toolkit are not efficient and user-friendly.
  • It is also time-consuming as you need to go through multiple hoops before able to execute a query.
  • Results are restricted by OTBI limitations.
  • Oracle does not have any immediate plans to enhance/release new tools to support developers.
  • For SQL-savvy super users or end-users, there is no easy way to query information for analysis except building OTBI analyses or build BIP reports.

BUY NOW

SQLConnect – Running a HCM/benefits query against Oracle HCM Cloud database

Get Your FREE TRIAL NOW

Features:

  • Rapid access to the database from your desktop – both Mac and Windows
  • Multiple connections, Query execution and saving just like Toad and SQL Developer
  • Webservice driven – which means you are always getting the real-time data from the cloud using the latest version of web API.
  • Ability to save, search, find-replace, and manage multiple queries/files
  • Secured by Oracle Cloud Role access
  • Export to CSV & MS Excel

Benefits:

  • Efficient: Faster development
  • Easy: User-friendly; Users don’t need to login to Oracle Cloud to run a query

Create multiple connections and use the same tool to connect to DEV, TEST, PROD and various pods – effortlessly!How to create connection

SQL Connect: Seamlessly create multiple pod connections with Oracle Cloud.

Intellisense: Don’t remember Cloud tables or column names? Don’t worry. SQLConnect does. With Intellisense enabled, SQLConnect will prompt Tables and Column names. It also provides you running search so you can jump to the column that you are looking for.

Get Your FREE TRIAL NOW

PRICING

Enterprise

  • Initial one time setup for one pod – included
  • Administrator and User Guides
  • Training videos
  • Product support : Includes new releases, bug fixes, production issues support
  • 5 users minimum

Individual

  • Initial one time setup for one pod – included
  • Administrator and User Guides
  • Training videos
  • Product support : Includes new releases
  • No minimum commitment
  • 1 User Minimum



Contact for Demo


Buy Now!