Technichal Consultant

Jayesh Acharya

<div>
<div class="content wysiwyg-content">
I have an oracle database in AWS, but I need to create an Azure function that will allow me to start a &quot;PL/SQL&quot; function. But I do not know how to create a connection between the Azure function and the AWS Oracle database. <br />
<br />
I am not an admin, so I would need some sort of idiot guide to kind of follow to help get round the problem.<br />
<br />
A very basic example would be <br />
<br />
from the azure function i would want to issue the following sqls<br />
<br />
Select sysdate from dual;<br />
<br />
if I had a typical sqlclient I would just first create a connection username/password@db but in this case I dont know how to get that connection to be made.
</div>
</div>


I have an oracle database in AWS, but I need to create an Azure function that will allow me to start a "PL/SQL" function. But I do not know how to create a connection between the Azure function and the AWS Oracle database. 

I am not an admin, so I would need some sort of idiot guide to kind of follow to help get round the problem.

A very basic example would be 

from the azure function i would want to issue the following sqls

Select sysdate from dual;

if I had a typical sqlclient I would just first create a connection username/password@db but in this case I dont know how to get that connection to be made.

Connect to AWS oracle from Azure Function App

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.