Skip to main content

Oracle Queries

Covering Topics on Oracle Queries in a Detailed Way!
Feb 19

SQLConnect Data Security with Oracle Cloud SAAS

By Product

SQLConnect is one of the few ways to connect to your Oracle Cloud SAAS (Oracle Cloud ERP/ Oracle Cloud HCM/PPM) applications and get your data for analysis, or adhoc queries.

How do you know that SQLConnect is secure and your data is not at risk? Specially, with your Oracle Cloud HCM data. You do not have to worry. Oracle Cloud Tools SQLConnect helps you connect with HCM Cloud, connect with Oracle ERP Cloud, without compromising your data security. Here are some basics about SQLConnect data security with Oracle SAAS Cloud that might help you understand and make a decision easily.

  • SQLConnect does not store any username/password information for your Oracle Cloud environment.
  • Username and Password for each connection is encoded and stored locally on your (user’s) desktop. This information does not get stored on our server.
  • When you run queries, our application connects to Oracle Cloud and gets data in a standard XML/JSON format and converts it to show you on the display – no data is stored on our server.
  • User can choose to export the data and save it locally – but OracleCloudTools does not store any data on the server.
  • You can also go to https://www.sqlconnect.com/bipublishersecuritysetup/ to find out specific setups required for BI Publisher security setups for accessing Oracle HCM and Oracle ERP cloud data via adhoc SQLs in SQLConnect.
  • When you run a Query in Oracle Cloud Tools SQLConnect, it calls the standard Oracle BI Publisher API and sends your query to the API. The API in turn runs our data model in the BI environment, gets the data required for your query, and sends it back in a specific format. Our application then convert that data into readable format and presents that on the User Interface where you can copy paste and work with that data. There is no easier way to query your oracle hcm cloud or oracle ERP cloud data.
Feb 02

SQLConnect 1 Month FREE Referral Program

By Product

If you are on this page – someone who cares about you has sent you a link to this page. Welcome, to SQLConnect.

Using Coupon Code MYFRIEND you will get SQLConnect FREE of cost for 1 Month. When you purchase a subscription, your friend gets rewarded too!

You can also refer your friends and get rewarded, while you share the best app to run adhoc SQL with Oracle Cloud SAAS Applications.

Next Steps:

 

  1. Go to PRODUCT Menu and add SQLConnect to you cart.
  2. Use coupon code MYFRIEND when checking out!
  3. Contact us at [email protected] If you have any questions.

 

Jan 23

How to connect to Oracle cloud ERP database using SQL developer

By Product

A lof of Oracle Cloud ERP and HCM users are searching online for ways on how to connect to Oracle cloud ERP database using SQL developer. Unfortunately, there are not many answers they are getting.

The results show them videos and links to articles on how to connect with Oracle cloud database, which is a different product then Oracle ERP cloud or Oracle HCM cloud. Oracle Cloud database is just like any other database and you can connect to it using SQLNet from Toad, SQL Developer etc. But Oracle ERP and HCM cloud is a whole different story.

This was infact a search term recently shared by one of our customer who was looking for how to connect to oracle cloud erp database using sql developer and he landed up on our website following the google results for this.

SQLConnect truly provides you a way to connect with your ERP and HCM Cloud data from your desktop. If you have not already tried downloading our trial version then contact us today and get the desktop version installed. You can connect to multiple pods of Oracle ERP and HCM Cloud from your desktop – Windows or Mac.

So, instead of searching for how to connect to oracle cloud erp database using sql developer, just get SQLConnect.

Dec 17

Oracle BI Publisher Security Setup for SQLConnect

By Support

1. Local Connections with Administrator Privileges

When you are using a local connection and have the admin privileges, SQLConnect will automatically upload BI Publisher Objects for you. You will get following message. You can check if you have administrative privileges or not using instructions listed in Step 5

Please go through Step 4 to setup the permissions

2. Update Existing Connections with administrative privileges

In case of P2T you may have to setup the connections information again, you can upgrade the existing connections. If you are using Local Oracle cloud login and have administrative privileges, then you can follow the steps as in screenshot below.

Please go through Step 4 to setup the permissions.

If you do not have administrative privileges or connecting via SSO, you can follow steps listed in Step 3 to upgrade connections as well.

3. SSO Connections/ or Without administrative Privileges

At the time of setting up SQLConnect, if you do not have admin Privileges or if you are logging in as SSO, you will get following message.

You can follow the steps below to setup

3.1 Download the latest catalog file

3.2 Login to Oracle POD as BI Publisher Administrator

Once the file is up, login to your Oracle Cloud POD as an administrator

Example URL:

You will see on the right if you have admin rights or not

3.3 Unarchive the Catalog file downloaded earlier

Click on Custom Folder, Unarchive the file you have downloaded.

After uploading the files, Please go through Step 4 to setup the permissions.

4. Set Permissions

Once the object is uploaded, Cloud Tools folder should appear in Custom Folder.

At this time change the permissions so that only BI Administrator (or any IT Developer role) has access to run queries using SQLConnect.

After deleting the undesired roles, you can apply permission to items within folder and subfolders.

5. Check if you have administrative privileges in BI Publisher

Login to your Oracle Cloud POD BI Publisher

Example URL:

You will see on the right if you have admin rights or not

Nov 15

How to connect to oracle cloud database using SQL Developer?

By Product
SQLConnect In Action

SQLConnect In Action

 

A lot of our Oracle Cloud ERP and Oracle Cloud HCM users ask us this question: How do I connect to oracle cloud database using SQL Developer?

Users also ask – How to connect to oracle cloud database using sqlplus?

The answer is, you can not connect to Oracle ERP/HCM Cloud database using SQLPlus, SQL Developer, Toad or any such other tools except using SQLConnect.          (This is Nov 2019 – If you are reading this in Future, there may be new tools on the market).

 

You do have the ability to connect to Oracle HCM/ERP/SCM/PPM Cloud using SQLConnect and query the database just like you would otherwise do using SQLPlus, SQLDeveloper, Toad or OTBI. The only thing SQLConnect doesn’t provide is Data Manipulation (DML). You can not update or create tables. You can not enter/insert data. But you can query Oracle ERP Cloud, HCM Cloud, PPM Cloud, SCM Cloud without any issues.

You can see a demo here  

After the demo you can download SQLConnect from our website and give it a try.

You can connect to the Oracle Cloud HCM environment (HCM_IMPL), Oracle ERP Cloud environment, Oracle PPM cloud environment, Oracle SCM cloud environment (SCM_IMPL) and run SQL Queries against Oracle cloud just like you would do using traditional tools like SQL Developer, Toad or SQLPlus.

SQLConnect uses webservice and BI layer to connect. So essentially it seems just like you are connecting to the Oracle Cloud database using SQLPlus and getting the data out of your tables.

 

Oct 10

Using Database Browser for Oracle Cloud

By Product

Oracle Cloud Tool’s SQLConnect comes with a Database Browser. Using this Database Browser, you can browse most of the Oracle Cloud ERP and Oracle Cloud HCM tables and views.

How to use the Database Browser for Oracle Cloud:

You can use the shortcut CTRL+SHIFT+D to open the Database browser for Oracle Cloud, or you can go to View Menu -> Select Db Browser menu option.

Database Browser Oracle Cloud
Database Browser for Oracle Cloud

Once you take this step, the Oracle cloud Database Browser will open as a new Tab withing SQL Connect

On the left hand side of the DB Browser window, you can search for any table in Oracle Cloud ERP or HCM. Our list of tables gets updated with every release and whenever Oracle changes the database schema for Oracle Cloud ERP or HCM.

 

Sep 25

SQLConnect Installation Instructions

By Product

STEP 1 – Download Software (Use one of the links from www.oraclecloudtools.com/downloads for Mac/Windows PROD or BETA version).

STEP 2 – Install the software (Instruction below).

STEP 3– Get your SQLConnect Username and Passwords. You can get it by “SIGN-UP” button on the login screen, or by contacting your system administrator.

PLEASE REVIEW Our Security guidelines for Oracle BI Setups here: http://oracloudquerytool.com/bipublishersecuritysetup/

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

Installation Instructions:

If Windows shows “Unknown Publisher” error, then please click on More Info… button and then choose “Run anyway” to install it.

Now go and connect to this environment from SQLConnect app. If you do not have a username, password, you can either purchase a license online or contact us to get a trial version.