Connecting SQL Developer to Oracle Database Cloud Service (DBCS) on gen.2 Oracle Cloud (OCI)

SQL Developer is free and very powerful tool from Oracle to do database tasks in easy and fast manner. You would say to connect SQL Developer to Oracle Database should be as easy as possible. And in most cases it is. But with very fast pace of changes in the cloud era it’s not always that easy.

That’s a reason I would like to point you to the post which helped me to connect SQL Developer to Oracle Database Cloud Service – Virtual Machine running on Oracle Cloud Infrastructure gen.2 (OCI).

Here is the short and simple tutorial which will help you to connect in two minutes or less:
https://medium.com/@fathi.ria/sql-developer-connection-to-oracle-cloud-d6bb58507eae

Thanks Fathi Riadh

Oracle Autonomous Database and Oracle Analytics Cloud

Some time ago Oracle launched new flagship called Autonomous Database. It’s available in two flavors, one for OLTP systems called Autonomous Transaction Processing (ATP), the second one for DWH systems called Autonomous Data Warehouse (ADW). Now you have an access to this flagship via Always Free program for 2nd gen. of Oracle Cloud (aka OCI).

But that’s just the way how to store the data.

What about visualizing the data and get insight?

Oracle offers Oracle Analytics Cloud (OAC) and Data Visualization (DV) is part of that. You can install DV locally or use cloud service (OAC).

If you want to check what you can do with this powerful twin, give it a try.

I prepared for you Hands On Lab for Oracle Autonomous Database and Oracle Analytics Cloud.

You can find all supporting files here:

HoL Materials

It’s a living project, if you have any comment, please let me know here.