Up next in 10
Multi-cloud Application Development with Microsoft Azure and Oracle Cloud Infrastructure
9K views
Nov 6, 2023
About Session: A current trend is that organizations frequently must address business requirements resulting in multi-cloud environments with applications and data deployed to more than one public cloud provider. Multi-cloud is becoming the norm concerning application development nowadays. Now, developers familiar with Azure can deploy Oracle DBs from the ODSA console and use ODSA’s automated cross-cloud network provisioning and identity federation with a single pane of glass for observability. This talk will provide attendees an excellent opportunity to learn how to implement a multi-cloud application with Java, Azure Functions, and Oracle OCI. They will understand the benefits of a multi-cloud approach with MSFT Azure and Oracle OCI. Register via our Meetup page https://www.meetup.com/azureusergroupsundsvallsverige/events/292027958 About Speaker: Juarez Junior is a Senior Principal Java Developer Evangelist at Oracle. He was previously an Azure Developer Relations Lead at Microsoft, a Principal Developer Advocate - Blockchain at Oracle, and a Thought Leader and Technical Evangelist at IBM. He has 27 years of professional experience in Software Engineering and Developer Relations, mainly as a Software Architect, Software Engineer, and Developer Advocate. He focuses on developing new code samples, hands-on labs (Oracle LiveLabs), workshops, demos, content (blog posts, videos) highlighting developer tooling and various Java-related and Open-Source projects, and participation in technical conferences and meetups.
View Video Transcript
0:18
Hi, everyone
0:38
This is Jonah Anderson, and welcome to Azure User Group Sweden. Today, I am hosting the session alone, live, but Håkan is actually backstage tuning in and helping us in our session today
0:56
So I hope that you are doing great wherever you're watching this session right now
1:02
And we look forward that you will be learning something great and awesome today
1:08
And before I start, let me introduce myself. So I'm Jonah Anderson
1:13
I'm the founder and community leader of Azure User Group Sweden. I'm an Azure MVP and I work as a developer and DevOps engineer and also as an IT consultant
1:28
And today, Håkan is also with me in the backstage and he is also our community leader
1:35
and also a great speaker as well as AI MVP that we have in the community
1:44
But before we start our session and introduce our speaker for today
1:50
let me just remind everyone about our code of conduct. So at Azure User Group Sweden, we do have a community that follows this conduct
2:02
so we are expecting everyone to be nice and friendly listen with purpose and be thoughtful
2:10
be respectful to others try to understand others and not criticize be curious to share your ideas
2:19
to others and be inclusive and respectful with your comments and questions both in the live chat
2:26
and even our after session FICA. And if you have questions related to our code of conduct
2:33
feel free to reach out to me and Hogan anytime on LinkedIn
2:37
or through our GitHub page. Okay. So that's our code of conduct
2:44
And to those of you that are learning with us today, we do have our Microsoft Azure Heroes learner badge
2:53
So the Learner Badgers are actually given to those that are very passionate about learning Azure with us
3:00
And feel free to also add Azure, Microsoft Azure to your skills in your LinkedIn account because you deserve it
3:09
Okay, so our Fika link to the Zoom will be shared later on
3:16
And let me just bring in our speaker today. with me. Let's see. Oh, let's see. All right. Hi, Waris. Yes. Hi, Janna. Hi. Yes. Welcome to
3:34
Azure. I'm great. I'm great. Thank you. Welcome to Azure User Group Sweden. Thank you. Oh
3:40
my pleasure. Thanks for having me. Yes. Let me introduce you if you don't mind. Of course. Yes
3:47
So here with us today is our special guest, Warris Jr. Warris Jr. is a senior principal Java developer evangelist at Oracle
3:59
He was previously an Azure developer relations lead at Microsoft, a principal developer advocate for blockchain at Oracle
4:10
and a thought leader and technical evangelist at IBM. He has 27 years of professional experience in software engineering and developer relations, which is mainly working as an architect, engineer, developer advocate
4:29
And he focuses on a lot of things, workshop, content, sharing, and everything from Java related to open source project for almost conferences and meetups around the world
4:46
And I myself have been impressed today of his profile based on what I've seen on his page
4:53
So welcome, Juarez, for being here. And thank you for joining us
4:56
my pleasure once again and you know thanks for the gentle introduction as well yes i do appreciate
5:03
that yes where are you joining us today uh i'm in dublin ireland yeah i'm resilient you know but
5:10
i'm living here for seven years now yeah yes yes i was actually in ireland two weeks ago but i did
5:17
miss you because i was in the north ireland oh i see yes i'll visit dublin uh someday but uh we do
5:26
have our friends saying hi. Ashish is saying good morning with some
5:32
I think it's a smiley there. We have Wayne from South Africa
5:40
He's also a community member. I believe Wayne is also working for
5:44
Microsoft. And then we are also streamed on C Sharp Corner. Oh, that's really
5:52
nice. Thank you very much. Hi, folks. Yes, I hope you like the presentation today
5:58
Yes, that's right. Yes, yeah, you're going to be great. You're the developer relations
6:05
Yes. Do you want to share your presentation or PowerPoint? Yeah, let's do it
6:14
Okay. Yep. Not yet? Can you see my screen now
6:38
Yes, I can. All right. All right. Rock the stage, Junior. It's yours
6:49
Perfect. All right. So hi everyone, as introduced by Jonah, I'm Juarez
6:55
You know, today we are going to explore a new service provided by Oracle, you know, in collaboration with Microsoft called ODSA, the Oracle Database Service for Microsoft Azure
7:09
I work as a developer evangelist here in Ireland with a focus on Java and data applications
7:16
And previously I used to work for Microsoft here as well, so I still have a very good relationship and connections
7:24
with the Microsoft community So without further ado let get started I think Jonah did a fantastic job introducing me so we can skip this slide here
7:36
But anyway, I have this QR code here, so if you want to connect with me
7:41
and ask questions about these things, you know, Java, but also the service
7:46
that we'll explore today, and feel free to scan it, and we'll get to my profile on Linktree
7:56
And then you can find my social media channels and everything else there, okay
8:00
27 years of experience working in IT, also as introduced by Jonah
8:04
and out of that, 11 years in developer relations for several different companies
8:09
Currently, I focus on Java, Cloud DevOps, Cloud Native, Blockchain, and I do a little bit of Python, Golang, and Rust as well, okay
8:17
Well, so let's talk first about the Oracle Cloud because that's kind of important and the baseline to allow you to understand what we explore here today concerning this collaboration between Microsoft and Oracle Cloud Infrastructure
8:36
Oracle, we have this portfolio of multi-cloud solutions and services, you know, and also to an extent, hybrid cloud as well
8:46
And that's interesting because usually some people, they confuse the terms, but it depends on the literature in a different way that you can see it and the perspectives
8:55
But at the end of the day, when we talk about hybrid cloud, usually we are talking about on-prem deployments and systems and the public cloud
9:05
And of course, when we talk about multi-cloud, we are talking about integration among different cloud players in public cloud environments and the providers
9:16
So Oracle has several different offers as part of Oracle's portfolio, things that are more related to the public sector and governmental applications
9:31
Dedicated regions as well with OCI, which stands for Oracle Cloud Infrastructure
9:38
exadata uh it's a kind of a specific environment that we have for uh mission critical uh database
9:49
applications for example with cloud of customer we can actually deploy the oracle cloud to a
9:56
customer's um environment you know and that's good for regions and some countries and customers
10:02
where they want to have the full governance and achieve data sovereignty, for example
10:11
financial applications, countries like Switzerland, for example, and so on. The interesting bit here is the Microsoft Azure Interconnect
10:19
That's a service that started as part of this collaboration between the two companies to create connections
10:26
and VPNs between the two clouds, Azure and OCI. So we have ExpressRoute and FastConnect, as you know that
10:36
And now the evolution on top of Interconnect is the service that I will present to you today
10:43
I just have a few slides, you know, just to give you a glimpse of what I'm talking about
10:48
Because actually I want to go and show you the different consoles, you know, and service and how the Interplay works
10:55
works and I have a simple application here as well to show you
10:59
how easy it is to deploy an application to Azure and then connected to the Oracle Cloud in an Oracle database
11:07
without being worried about those usual non-functional requirements like security, networking, monitoring
11:15
federation, identity access management, and so on. By the way, I'll take questions at the end
11:24
Okay, just to keep the flow here because I really want to allow you to see everything that I have to present here today
11:32
It's interesting first to start with this interconnection diagram. And currently we have 41 regions with eight more planned for the roadmap and the strategy plan by Oracle
11:51
and out of that 12 Azure interconnect regions. So we are talking about data centers
11:57
that are effectively collocated and interconnected to Azure. And that's nice because it only allows you to approach it
12:10
in a simplified way, not only that actually, sorry. And also, it will be good because things like the data egress and ingress fees, they are not charged
12:25
You know, you have better latency, response times, and connectivity. So all the benefits that usually you can get out of such integration, they are there for you. Okay
12:38
Then Microsoft decided actually to improve this service. And in conversations with Microsoft, you know, in this collaboration
12:48
then they decided to create a new service to integrate the best of both clouds
12:54
And also you can see here, for example, we're starting with the Oracle Cloud Infrastructure at the bottom
12:59
you know, which is our kind of IaaS and PaaS platform. we have different options in terms of data intensive applications you know if you are
13:11
talking about environments and database options that the customer wants to manage the oracle
13:17
manages the infrastructure but the customer wants to manage the databases you know so you know
13:22
perform tasks like dba related tasks and you know and do patching upgrading and all those things you
13:30
can start with the base database service, you know, which is a kind of more controlled and single
13:37
environment with just a few standalone database instances that you can run, but that's still a
13:44
cloud provisioned database service. Then if you move towards my right hand side here, we have
13:54
Exadata, which provides more mission-critical features in terms of using clusters, for example
14:02
with RAP, the real application clusters that perhaps you've heard about, you know, that's
14:07
specific and provided by Oracle databases. But then we have the autonomous database on the right-hand side here, which is a fully
14:16
managed Oracle database service. So all those tasks that I talked about, things like patching, performance optimization, fine tuning, all the governance and all the concerns that usually you need to be aware of in terms of managing databases for mission critical applications, Oracle will take care of that
14:38
So you can see the arrows at the top here in terms of automation and this abstraction in terms of hiding all the complexity and so on
14:47
When we talk only about the Oracle Cloud Infrastructure, along with the databases, those are the options
14:54
But now we have the service that I going to talk about now the ODSA service the Oracle Database Service for Azure You can see here Azure has so many services that are somehow
15:07
related and can be used with data intensive applications, things like Power BI and Power Apps and
15:15
Power Automate as part of the Power Platform, Synapse ytics for DW applications
15:21
AKS for cloud native, web services for web servers and web applications, you know
15:28
They are all here, you know, the cognitive services and APIs, IoT
15:33
central and all the other IoT services, Databricks for big data and so on
15:39
So Microsoft and Oracle, they decided then to expand and improve this integration
15:46
you know, to make it natural to both clouds. they created the database service for Azure
15:54
Basically, there are just a few steps that you have to perform in order to leverage the benefits of that
16:01
First, connect Azure and OCI, but that's quite straightforward. You just have to go to a console that I'll show you today here
16:08
that resembles Azure. It has the same look and feel, the same organization
16:14
same colors, everything. that sits on top of the Oracle Cloud, of course
16:19
I'll show you the domain just to allow you to make sure. And then provided that you can connect them
16:26
you just provide information about your Azure subscription to this service. Then you can go and easily provision an Oracle autonomous database
16:34
and there are other types of databases there as well. And with that, you can just go straight to Azure
16:42
deploy it, an application to Azure, you know, And provided that you have the same regions, for example, you can, of course, achieve more elaborate data and network topologies and work on more elaborated network paths
17:00
You know, there are some different ways that you can also customize it. But my focus here today is just to show you what is available out of the box, you know, as the default option
17:09
And then Oracle and Microsoft, of course, they are engineering things. They work with all the design patterns in terms of solution architecture and software architecture as well
17:24
And things like the Azure Royal Architected Framework and a similar approach on our side here at Oracle
17:33
Things like Cloud Adoption Framework and so on. So beyond abstracting this complexity and somehow providing an easy way for you to work with both clouds and concerning this integration between the two clouds, the good thing is that this is somehow another tool that you can have under your belt in case you have those customers that typically outsource their IT departments, for example
18:01
So perhaps they don't have the DevOps guys there, SRE and, you know, in the cloud architects and so on
18:10
You know, this is an option that perhaps as a consultant you can use to modernize their applications and maybe move applications from on-premise systems to the cloud
18:21
And then easily deploy, you know, the database applications along the existing web applications to Azure
18:28
And then after that, in terms of governance, you know, and monitoring and everything else, it will be easier for them to sustain the operations, you know, and move forward concerning day two operations, for example
18:40
Yes, so this is just to give you a glimpse of what I talked about here
18:48
You know, it was launched in July 2022 during the Microsoft Ignite event when Satya Nadella, Microsoft's CEO, and Larry Ellison, who is the founder, chairman, and CTO of Oracle presented the service together
19:05
As I said, you can run apps on Azure and databases on the Oracle Cloud infrastructure with zero downtime, high availability
19:12
We have Oracle REC on Exadata. As I said, the real application clusters, you know, that's really amazing in terms of high availability
19:21
You know, the SLA levels are great, you know, in terms of replication, all those things that usually are provided by enterprise clusters
19:32
Latency is good because remember, we are talking about collocated data centers and regions here
19:39
So in terms of latency and performance, there's no impact. Even concerning that, we are talking about two different clouds, but at the end of the day, they run collocated
19:52
scalability is good as well in terms of the data warehouses and in terms of the petabytes that you
19:59
can have for the data stores and the databases nice thing as i said we have a kind of azure
20:06
native like user experience you know so the user interface resembles azure just to allow you to
20:12
easily work with the azure portal for example and then go to the also the odsa console and have the
20:20
very same user experience uh and connectivity with many services here and everything else is
20:27
automated and that's the great benefit and the things that you can really elaborate in terms of
20:32
abstraction concerning as i said identity access management networking connections and connectivity
20:39
monitoring integration by the way for example the oracle database will create events and propagate
20:46
them to the Azure site, so you can use Azure Monitor and the services
20:51
under the monitor umbrella like app insights and log ytics, for example, just to capture
21:00
And you also have, I would say, easy monitoring provided by that
21:05
The way it works, as I said, there's a guided cloud-to-cloud setup
21:11
and integration step in the documentation. I have it today just to give you a sample of how easy it is in terms of the steps and the things that you have to perform
21:25
You go and you configure them the Azure subscription on the Oracle tenancy
21:32
And then you get everything. The handshake happens, a federation, all the policies, security roles, everything else as usual concerning security
21:41
the network configurations as well, monitoring, and so on. After that, you can go to the ODSA step two here
21:52
You can see a similar graphical user interface here. And there you can create the databases, deploy them
22:00
You can also restore backups, perform the usual database-related tasks. Interesting to say there's a tool, a very interesting tool
22:09
a web tool called Database Actions that you can just, from this console
22:15
open a tool that you can do everything, run queries, model your databases, for example
22:23
You can even run machine learning with the Oracle database do Python notebooks with Python You can do deep learning machine learning data ytics data science and so on
22:35
Of course, as a result, and as I said, you can see here as step number three
22:42
monitoring is available as well. You have those events that I talked about
22:46
with App Insights and Log ytics. This is the user interface. I just want to give you a screenshot
22:54
just to allow you to get a glimpse of it. You can see autonomous database here identified and highlighted
23:03
You click that, and then you move to provision a database. The typical step between FormG workload type
23:09
there are a couple of options, DW databases for, of course, DW applications
23:14
and OLTP for ytics, and the number of OCPUs that you want
23:20
If you want to enable outscaling, for example, storage, you know, inform what are your requirements
23:28
If you are using the included license or if you want to bring your own license
23:34
you know, for the databases and the database version and name. And with that, you can provision the database
23:42
And these are the features there. You can create and delete databases, start, stop and restart then
23:47
You can also use manual scale up and down instead of auto scaling
23:53
Download and rotate your wallet. That's interesting because with the Oracle database
23:58
there are a couple of different options that you can use to enforce security. The first one is what we call one-way TLS
24:05
where usually you just have the authentication enforced by security credentials that are provided by the client application
24:15
Or you can have also what we call MTLS, mutual TLS, where actually both sides authenticate
24:23
And for that, you have to use a security wallet that you can download from this console as well
24:28
I have a step to show you how to do so. Network access, as I said, you can create your ACLs and so on
24:35
and enable public access as well because we are talking about initially an integration
24:43
you know, concerning both services that I talked about, FastConnect and ExpressRoute
24:48
Backup and restore is there for you as well. So yes, let's revert to my web browser now so I can show you
24:56
So this is the ODSA service. As I said, you can see that it resembles Azure
25:02
but at the end of the day, you can see that the domain here is multiply.oracle.com
25:07
Okay, so that is actually running on top of the Oracle Cloud infrastructure
25:11
In terms of configuration, when you go to enable it, It's just a matter of identifying the subscriptions that you listed
25:21
You have to perform some initial steps here. And then you select the very same location just to allow it to be integrated with no further steps
25:30
In terms of this initial integration, we have this documentation here. And there are just a few onboarding steps here that you can see just
25:41
You can perform automated onboarding, for example. So you just inform the details of your subscriptions and the tenancy and so on, and everything else will be performed for you transparently
25:53
So as I said, guys, this is another interesting tool that you can have under your belt to perform, you know, fast migrations, for example
26:02
enable customers that are not so used to these things in terms of having the IT guys to provide that expertise to them
26:13
After that, you can create some security roles as you may need, you know, in terms of enabling the people who will be able to access all the applications, you know, and the security principles and so on that you'll be able to integrate to this database
26:31
And then after that, it is actually the database provisioning step, the very same user interface here
26:37
But before I show you how to provision a database, actually, we can do it now
26:43
So I create create database, for example. I selected the workload and you can see I have autonomous database here
26:49
the one that has the AI services running in background, you know, to do things like fine tuning, optimization, patching and so on
26:57
But all the options are here as well. Exadata, VM, you know, base database, even MySQL
27:02
which is quite interesting as well. You know, a fully managed MySQL service is here for you
27:09
Let me just show you how to create an autonomous database. You select a subscription here
27:15
You can select an existing resource group, for example. You provide the name, you know, for example, myDB Azure Sweden
27:25
You select the region, you know, as configured here. Then you can move in terms of configuration, the workload type, as I said
27:33
If you want to run transaction processing or a database warehouse, a JSON database is available as well, a document-based database
27:42
There's a more specific one here for Oracle Apex, which is a kind of low-code tool that you can use with your Oracle database
27:50
OCPOcout, I want to enable scaling, for example, my requirements in terms of storage, license type, for example, license included, and so on
27:58
Database type, if we are talking about autonomous, the current version is 21C, but for this service we are still running 19C
28:09
Database name, I can say my database, a through Sweden demo. Okay, that's it
28:19
In terms of networking, if you want to have secure access from everywhere, you can use this option here
28:28
or you can also, and then you can use the wallet that I talked about, okay
28:33
And I'll show you where to find it. Or you can just allow access from allowed IP addresses for those options
28:41
for example, that you want to use security credentials and not the mutual TLS option with a wallet
28:47
but the single TLS option, for example. And then you have to whitelist your IP addresses, you know
28:54
My example today, I can show that it is just a matter of going to the Azure specific service, usually the networking configurations, and you can get the outbound IP addresses there and add that to the Oracle configuration
29:11
If I want to enable mutual TLS or not, in terms of security, database, username, password, and confirm password, that's for the tool that I talked about, the database actions
29:23
I will explore that again with my up and running database instance that I created for this demonstration here
29:33
I'm just showing you the provisioning steps. Of course, as in Azure, you can use a tagging as well, review and create, and that's it
29:40
But if I come back here, I have an existing database instance running here
29:46
The workload type is transaction processing. The location is East US. If I click it
29:53
this is what you see when you create a database. You can see resource group, the status, location, Subscription
30:01
You know, if I want to see the database on the OCI side, I click this link
30:05
It will open the Oracle Cloud Infrastructure Console in the portal. The user admin for the database actions features
30:14
If I click here, for example, database actions, that's the tool that I told you
30:19
It's quite nice because you have all things that you might need to work with databases here
30:24
You know, the SQL tool to execute queries and scripts. but you can also model databases
30:31
I talked about Oracle machine learning, for example, it is here. You can create charts, you can enable REST APIs and so on
30:38
But when I click SQL, for example, I will end up seeing this user interface here
30:47
You can see I have just a simple query here, the very same one that I have as part of my functions app
30:54
I can just run it and you will see the results here. okay uh here in terms of configuration tagging um you can you have all the commands here start stop
31:05
restart refresh delete for example for the connection feature with a wallet for example
31:11
i have a couple of options here okay i can go in if i want to enable and i have the documentation
31:18
here remember again if i want to enable mutual tls or just one way tls depending on your options
31:24
mutual you don't have to provide that you just download the wallet you unzip it and then you
31:30
point it to your data source okay the other option i just uh enable a single one-way cls for example
31:38
and then i might need these connection uh strings here okay depending on your uh requirements in
31:46
terms of latency and availability and so on there are different ones that you can connect you copy
31:51
this string from here and my Azure apps application for example I have created a properties file
31:58
I have a link for to this documentation here you just provide the username password
32:03
url username and password here the url I'm talking about is this one here okay that I can copy here
32:10
otherwise I can just say no I want to work with mutual tls I click download wallet you provide
32:16
the password for this wallet here so you can then go and have something like this here oracle wallets
32:25
so this is the wallet for this demonstration you know in the wallet at the end of the day we are
32:30
talking about some security certificates you know you can see the pen file here in extension the
32:38
the usual oracle configuration files there's a jks file here as well a java key store you know so
32:44
that's a straw store and then you can also point that as part of your configuration you know
32:51
instead of using uh uh the full url here you can just point it to your wallet and if on the cloud
33:00
side the service is unable to use a wallet that will work out of the box as well in terms of
33:06
configuration again you can see the workload type is uh atp you know autonomous transaction processing
33:11
CPU count, if auto scaling is enabled, licensing included, storage and so on. Networking, that's where
33:18
you have to enable, for example, I disabled MTLS just because I wanted to show you
33:23
the most difficult option here or the most elaborated one, the one that usually we are
33:31
using a one-way TLS, but you have to whitelist the IP addresses here, so you can see that it is
33:37
actually MTLS is disabled, you know, and typically you just go to your
33:42
for example, I have this function as a service resource group here
33:46
I just go to my function app and you, of course, you like Azure and you do all things Azure
33:53
So you know, you click the networking tab and then of course
33:58
you will see the outbound addresses here. So you just have to copy them and provide them to the Oracle database side
34:06
on Oracle, CI, ODSA, and that's it. You know? Yes, and you can perform backups as well if you want
34:14
but that's it. So I can now move to show you a sample application
34:22
you know, just as a quick demonstration, nothing elaborated because at the end of the day
34:26
I just want to allow you to see how easy it is to use this option here as another tool
34:32
that you can have as part of your options in terms of ideas and solutions to your customers
34:39
But by the way, I have this GitHub account, so you can go to ODSA
34:46
Oracle Database Service for Azure Function as a Service. The functions app that I have here
34:52
it's I would say just one simple function to show you how easy it is
34:57
You can really go straight to Azure, deploy the application and then provided that you are using
35:03
the same region, everything will be connected, because I provisioned them to the very same regions
35:11
so they are somehow co-located. So everything else provided that you are using ODSA will be configured for you
35:17
Also, any of those non-functional requirements that I talked about, security, networking, monitoring, and so on
35:23
I have a blog post on Medium as well. If you want to execute the steps again
35:30
Just to get a glimpse of that, you know, all the steps are here, including pointers to the source code repo
35:36
And by the way, I used the Azure CLI, you know, but Azure, you know, you can use things like infrastructure as code with Terraform, Bicep, you know, Ansible
35:46
Or you can use, you know, ARM templates or you can use the Azure portal or the Azure SDK, you know
35:53
So you decide, you know, this is just maybe to simplify things
35:57
I do everything from the command line here, including how to create the application and so on
36:02
how to deploy the application, and all the steps are here. Of course, I provide links to the documentation concerning
36:11
everything related to Azure and the Azure functions to core tools that I used
36:17
Let's have a look at the application then. First, I used this option here
36:24
Actually, the amazing as part of Azure Functions, there are some Maven plugins for Azure Functions
36:32
Maven is a famous build tool that you can use with Java projects
36:36
and usually you create a POM file In this case here I just wanted to easily deploy my fast application to Azure and have that integrated to the database on the Oracle side
36:50
Quite easy. You just provide in this example here, you know, and if you go to GitHub to get the source code
36:56
remember that, and you can see the recording later as well. You can just provide a name for your function app
37:03
you know, and then you can scroll down here and there are other options for customization here
37:09
but at the end of the day, just provide your resource group name
37:13
and Azure service plan and the region, which is, by the way, the same region that I configured here
37:22
Okay, so remember that. Yes, after that, I can use Maven to deploy the application
37:30
I have the easy steps here. Again, the blog post is there on Medium for you
37:34
along with the source code. I use it maybe just to create a fast application from scratch with the moving plugin for Azure functions
37:43
You know, so I create just the files to open that in a integrated development tool
37:48
I'm using Eclipse here, but you can also use IntelliJ or even VS Code with the Java extensions for VS Code
37:57
Yes, then you can go and build a package for this application
38:02
Remember to log in to Azure, set your default subscription. and then I can deploy the application
38:07
I can execute that here now, okay? But before I do so
38:12
maybe I can just actually show you on the Azure side. As you saw, you know, I have this resource group here
38:22
So everything, as you can see here, will be provisioned with a single command
38:28
from the command line with Maven, okay? And the same query that I run here at the end of the day
38:34
it is actually related to this application here. It's just a simple Azure Functions application
38:43
no fast application, nothing special here. I have the connection URL, database username and password
38:50
database results query, I think. The query statement is the same one that I executed
38:55
from the SQL Actions dashboard here, okay, actually here. And yes, but the application here, you know
39:04
just um this is just the query execution side but before i show that i will revert to it functions
39:12
app you know you can see the typical imports here for function function applications the http trigger
39:18
you know status the method request and response messages you know quite simple here i just include
39:23
get and post as http methods or http verbs you know uh the authorization level is anonymous
39:30
so and I then just have that processed you know I capture a couple of request parameters name
39:38
and the year just to perform the the database query and then I delegate the database query
39:45
actually to this class here which is this one here as I showed you I retrieve the information
39:50
from the config file that file that I showed where you can configure the connection and then I you
39:57
I get the properties, I prepare the typical database query here. I create an Oracle data source, which is a pulled data source
40:08
I set the database connection details. I get a database connection or Oracle connection
40:14
I can also retrieve metadata if I want. After that, I just delegate it to a method that I created to SQL work
40:22
which is effectively just a simple prepared statement query. So I bind the parameters name and year that we captured from the HTTP request here
40:33
And then I execute the query. I process the results app. And then I just create a string that I result
40:40
I return to the functions app, which will then send that to my browser
40:45
So this query here, and you can see the Cosmo City is hoofed up in the Netherlands
40:51
So I can just go here. you can see the same parameters here as part of my URI
40:56
So I just click here and I get the same results. Okay. What else
41:03
Yes. So here, remember, and the last step now I can just show you how easy it is
41:11
with this option here to deploy the Azure Functions app. So I just run this maven command here
41:22
Oh, by the way, it is reconfiguring, I guess, my application. But then it will perform everything
41:29
It can even check if you have an existing application. So if that's a redeployment, for example
41:35
all the tools are being instantiated here. You will see some messages being echoed with some details about my environment
41:44
And then everything that you can see here, the app insights for this application
41:51
function app, app service plan, and so on. Everything will be provisioned automatically
41:56
by using this function app. That was all this Maven tool and the option for
42:03
Azure functions. When I have that deployed, so I don't have to be worried about anything else
42:09
You know, monitoring, security, networking, and so on. Everything is there for you because remember, again
42:16
my database is running on the Oracle side. You can see the domain here is actually Oracle
42:21
although it resembles Azure, and then I have the application deployed to Azure
42:26
and I can run it from my tool on the Oracle side
42:29
or I can go and just call my functions, application, and get results
42:34
The functions app is quite easy and simple indeed to work with
42:42
Um, yes. So let me revert to my presentation. So the key takeaways here, as I said, you know, if you have a scenario where perhaps
42:51
that would be a good option for you in terms of simplifying this IT transformation and
42:56
modernization customer to your customers, you know, and as a consultant as well, that
43:01
might ease things for you. This is another option that you might consider, you know
43:08
we have this unified user experience with a kind of single pane of glass not only for the management
43:15
and provisioning steps but also monitoring on the Azure side the benefits in terms of this interconnect integration and also remember as I told you egress and ingress data is not charged you know if you have this deployment and so your customer might be able to you know reduce costs
43:37
and save money as well. Many different options in terms of the database. Last step, I have the
43:43
official announcement here where you can see both Satya and Larry Allison presenting the service
43:50
it's quite interesting presentation. If you want, by the way, you can send me a message on social media
43:57
and I'll be more than happy to provide you a copy of this deck
44:01
My blog with the steps, documentation, the official one that I showed you
44:07
the blog post on Oracle Developers as well. Our developers.oracle.com, we have also a profile on Medium that you can explore
44:18
and once again as i said if you want to uh you know get all the information and you know get
44:26
access to my deck or maybe uh the source code everything else you or ask some questions uh in
44:33
case i don't have all the answers i can connect you with the guys you know at oracle who are the
44:38
solution architects and solution engineers that focus on that you know and that's everything or
44:45
if you just want to, you know, add me to your network as well, you know, as a professional
44:51
I'm more than happy to connect with you, okay? That's everything. I think we have a kind of
44:59
Q&A FICA session after this presentation here. Let me just show you, you know, the provisioning
45:06
step is happening here. It takes a short while, but that's exactly how it works, okay
45:13
So let me stop sharing. And thanks again for the opportunity to introduce you to this
45:20
another tool that you can use. Yes. Thank you so much, Juarez, for the great session
45:29
A lot of like things to learn there for everyone. Thank you so much
45:35
Yes. We don't have any questions as I can see in the screen
45:39
Everyone likes it's quiet, But I do have a question in myself because I've been in a project where we do have Oracle databases, I mean, on-prem
45:53
But I know that in that project, there's a thought to move to Azure or to the cloud
45:59
So my question to you is, what are the best practices or advice that you can give to people or developers or organizations who are thinking to migrate their Oracle workloads to Azure or integrated multi-cloud or hybrid
46:18
Yes. No, that's a very good question. Thank you very much. Yes, as I told you, there is no true or wrong or false here or right or wrong
46:30
The thing is that it depends on how far your customer is in terms of maturity and being acquainted with all those things in terms of complexity and so on
46:44
You can, of course, deploy Oracle databases to Azure. you know, that's available usually as an option from the Azure marketplace
46:56
But if you do so, what you perhaps will miss is the opportunity to abstract all the database-related tasks
47:06
things like patching, as I said, you know, which is quite important in terms of security and cybersecurity
47:11
for example, you know, and avoiding some breaches, fine-tuning and performance optimization as well
47:18
And I can tell you that actually, of course, you know, as you may infer, the Oracle database runs optimally on top of the Oracle cloud, you know, because Oracle worked as an engineering system to optimize the environment
47:33
And but in terms of maturity, as I told you, if you want to simplify this journey and allow your customer to migrate easily and then sustain that in an easy way
47:44
So perhaps the ODSA service is an option. Yes. And I understand the scenario as well, because some customers usually they have that deployed to a non-prem server
47:58
and regardless of which hardware platform we are talking about, you know, you can have a number of different hardware providers
48:06
but usually they are approaching the end of life for that hardware platform as well
48:12
So instead of, you know, reacquiring new hardware servers and a new platform, for example
48:18
it makes more sense to move to the cloud now, you know. At some point, they will have to modernize
48:24
So I'm not sure if it is still worth to acquire hardware service that at some point will face a depreciation and some constraints again
48:34
Yes, thank you for that. I mean, the UDSA for Oracle, is that something that you can apply also for .NET application or there's some limitation for only Java on that
48:46
No, no, no. Everything you can do that. Yeah, .NET. Because Azure is quite interesting because Azure now runs everything in terms of languages and open source
48:58
So you can do that for Golang apps, Python apps, JavaScript, .NET, C Sharp, and so on
49:06
Even Rust now. Yes, okay. Thank you so much for your answer on that
49:13
I don't think we do have questions from our audience today, but maybe some will come up more questions when we have our after session FICA
49:28
But do you have any sessions coming or events coming that you want to share to our audience, Junior
49:34
Initiatives that you might want to invite them, aside from connecting with you, of course
49:39
Yes. I think that interesting to this community is we are about to start the Azure Sprinkling event next week
49:52
So yes, I'm participating there as well. So yes. And of course, I'm talking about this one because there are so many great presentations about all things Azure and Microsoft
50:02
So that's the one that I would like to refer to. Yes Yeah Thank you for that I think this is a good session because multi talks or session actually is not so much I mean not spread out in the community So it good to have this like hybrid and multi talks and knowledge that we share within the community So this has been great
50:29
I do agree. Yes. And remember, the benefit is the abstraction in terms of hiding the complexity and so on, because everyone is talking about multi-cloud, but it is not something quite straightforward to implement
50:42
No, that's right. Yes. And then if you do multi-cloud, you need to understand the two sides of the world, right? You need to understand Azure. You need to understand the other side of the cloud
50:53
So it can be complex, especially that some organizations are also not ready for change
51:02
And sometimes you need to do changes in order to move forward. So I'm glad the community can help with some knowledge to developers or those that are watching us today
51:15
Yeah. Sorry, just one last one. You said it right because there's no better option than having Microsoft and Oracle to implement that for you and address the complexity and all the hurdles
51:26
So you can just go and focus on giving your customers solutions. Yes, that's right
51:31
One last question before we end our session and share our Fika link to everyone since others are quiet
51:38
So I'm going to ask some of the questions. How is Microsoft, like, I mean, based on your experience and you working with developer relations and Oracle and you in the Microsoft community as well, do you see that there is a big trend or collaboration happening between cloud providers in terms of multi-cloud and hybrid in terms of working together
52:06
So these technologies work together? I think so because that's not a trend, but actually it reflects the reality in terms of the environments customers usually have in the deployments, for example
52:23
Because at the end of the day, when you talk, let's say, about a massive telecom provider, for example, they have Azure, they have Oracle, they have Oracle databases, they have possibly tools from other players as well
52:39
So, you know, they have people who are trained in those technologies, you know, so it is not so easy to ask your existing team members and the professionals to focus specifically on a given tool, for example, or if you have, I don't know, 20% of your guys doing Oracle and 40% doing Azure and so on to say, no, now everyone has to focus on Azure and blah, blah, blah, you know
53:08
So they are just trying to actually reflect what they have running, you know, as existing in mission critical systems at the minute
53:17
So that's actually a reflection of reality in terms of requirements, you know
53:23
So that's a good thing anyway, because it does not have to be exclusive
53:27
You know, this collaboration, I use it to advocate for blockchain, for example
53:32
That's another example, because when it started years ago, actually, we used to talk about different blockchain networks and platforms
53:41
But now there are some initiatives as part of the community and the industry as well to kind of create this convergence in terms of the blockchain protocols, data formats, and the integration between the different blockchain related networks as well
53:56
And, you know, at the bottom, we have the cloud environments and solutions. So, yeah, that's natural to it
54:02
yes thank you so much all right we're about to end our session so thank you so much uh waris
54:11
for sharing your knowledge and we look forward to chatting more with you uh on our after session
54:17
fika uh and uh do you know what fika is right away waris well i understand what it is in practical
54:26
terms but the meaning no no it's the the it's spelled f-i-k-a it's the swedish word for
54:34
having a break and having coffee something sweet either digital or on in person to chat with friends
54:42
or colleagues so we we started that in ashley user group sweden because we're doing live streamings
54:49
remotely since the covid times so we decided we need to interact more with our community so
54:56
So we thought those who want to spend time with us on weekends
55:01
then they can join us, have coffee or tea, and then just have a chat with a speaker like you
55:07
So that's the FICA. Yes, it's like a culture thing. I can use that now next time when I have an opportunity to go to Sweden
55:15
and Stockholm. I've been there twice, so I'll tell my friends, okay
55:19
so we should get together and have a FICA session. Yeah, sure, sure
55:24
you can use it as a small talk conversation when you're in Sweden. All right. Yeah. So yeah
55:31
thank you everyone for tuning in with us. And I hope to see you also on our Zoom meeting today
55:37
And if ever you forgot to scan the learner, Azure Heroes Learner Badger, you can scan this QR code
55:46
or you can do a replay of this recorded session. And I think HoltCon is going to share, or maybe not yet
55:57
We will be having this Zoom link, Bitly linked for our Zoom meeting at one in three minutes
56:07
So feel free to join us and prepare your questions for Junior today
56:14
so all right thank you so much junior and see you next time thank you thank you
#Virtual Worlds