Oracle
What is Oracle?
Oracle database is a relational database management system. It is also called OracleDB, or simply Oracle. It is produced and marketed by Oracle Corporation. It was created in 1977 by Lawrence Ellison and other engineers. It is one of the most popular relational database engines in the IT market for storing, organizing, and retrieving data.
What is AppiWorks integration with Oracle?
AppiWorks is an application integration platform. It can create a connection of Oracle in the AppiWorks platform and use it in any client platform such as AppiWorks for Zoho CRM, AppiWorks for Google Forms, AppiWorks Looker Studio Connector, etc.
Setup and Configuration
How to establish a connection?
Search for Oracle in the AppiWorks platform (as shown on the right side)
Click on the Oracle
To connect Oracle databases following elements are required.
Host
Port
Database
User
Password
Provide all the required credentials and click on Connect to create the new connection.
You could have your Oracle database running in any of the cloud providers such as GCP, AWS, etc. (can be any other providers) or on your private cloud or on-premises server that is connected to the Internet.
For AWS you can visit the following links for your reference
Before setting up the Oracle connection in the AppiWorks platform, one must configure the Oracle database to accept connection from the AppiWorks infrastructure.
***IMPORTANT NOTE***
The following IP range should be whitelisted in your cloud/ on-premise Oracle database so that AppiWorks Infrastructure can connect with it.
35.238.134.134