I have connected a Database Admin Azure VM running Oracle’s SQL Developer (Windows version) and a Microsoft Power Platform application displaying Oracle’s HR demo schema (via on-premises data gateway on Azure VM connecting with Power Platform’s Oracle Premium Connector) to the same Oracle Database hosted on OCI. I used Oracle-Azure Cloud-Link by the fully automated Oracle Database service for Azure in the background. In this article I am sharing my design, learnings and key takeaways from this exercise I enjoyed a lot.
Previously, I used Oracle Application Express for Oracle Databases. Oracle APEX is really cool, it is a rapid application development tool offered by Oracle, based on the underlying database schema.
Below my updated design, on the left side you see Azure, on the right side you find Oracle Cloud. I am not using on-premises datacenter in this demo/deployment.
If you have Azure experience and are new to Oracle Cloud it will take some time to understand how similar purpose objects are called in OCI. For example, Azure Resource Group is called OCI Compartment. Networking foundations, such as Virtual Networks or Subnets are the same in each cloud. Policies on subnets, such as Ingress and Egress rules are automatically generated when you provision your first database.
a new network that is not existing in OCI and is not used in Azure
a new network that will be automatically created in OCI connecting Database System, Database, and Portable DB – you will connect to the portable database with your applications
ideally, a B class (20-bit block) network and the perfect subnet mask is /16 to utilize cloud link
be careful – it is not going to check if you enter non-private networks IP, for example, I was able to deploy with 22.214.171.124/16 which is obviously the wrong range (outside the private network range), and not part of the 20-bit block.
When you submit this wizard you can track what is going on using Tenancy Explorer and ORM Jobs.
Deployment jobs are running Terraform (Terraform by HashiCorp) code in OCI. This is how Cloud Link and DBS/DB/PDB get deployed.
* An Oracle client connects to the server using the port address of the listener, which is normally defined as TCP port 1521 during Oracle installation. sqlnet service is defined as using TCP port 1521.
You can also track the deployment on the “Oracle Database Service for Azure” portal.
Let’s connect from Power Platform. In order to do that, I had to deploy On-premises data gateway on the Azure hosted Admin VM.
After allocating the proper licenses it started to work
When it comes to price, I was mainly paying for Oracle Standard Database License for 2 days
Key takeaway, there is no charge on Azure side. The fantastic time saver full automation is free, the cloud-link is free and provides low latency, it is easy to use. Well done, I can’t wait to see how this evolves over time.
My calling is moving prem VMware workloads to Cloud.
I have connected a Database Admin Azure VM running Oracle’s SQL Developer (Windows version) and a Microsoft Power Platform application displaying Oracle’s HR demo schema (via on-premises data gateway on Azure VM connecting with Power Platform’s Oracle Premium Connector) to the same Oracle Database hosted on OCI.
As part of my multi-cloud research, I wanted to test Oracle Database Service for Azure. In this article, you will see how to sign up for the new service and how to link Oracle and Azure accounts. I used Frankfurt datacenters, Azure MSDN, and OCI paid account (Free Tier does not work) using my private Azure Active Directory.
While cloud migration is still a popular topic during customer discussions, I have noticed that more and more customers are considering an exit plan from one cloud (vendor lock-in) to another cloud meaning there is an increase in multi-cloud migration demand. VMware, Oracle, and SAP are the major workloads in on-premises data centers today. Based on my research both VMware and Oracle are very vocal about the importance of having a multi-cloud strategy.
There are two ways of approaching this challenge. (#1) running MikroTik virtual appliance (CHR) in AWS (#2) using Virtual Private Gateway, a “cloud-native” networking solution provided by AWS. Each solution has its own benefits.
Every week, almost every day, whenever I have time. This is a massive commitment in my life to do better. I am primarily focused on human and leadership skills, LinkedIn Learning helped me a lot in preparation for my expert certifications, both Microsoft and AWS.
I started to learn AWS last summer as a 2nd cloud after my Microsoftee years. So many similarities, but different vocabulary. What is your profile? What’s the best learning path for you? How you can bring the most value to the organization supports your development plan?
Moving VMware workloads to multi-cloud. Deploying new stuff and sharing my learnings to save time for you. Video interviews with senior technology advocates.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.