You must satisfy the following prerequisites for creating a connection with the Oracle Integration Cloud Service.
- Ensure that the target database is publicly accessible.
- Ensure that you have write permissions to the database.
- Ensure that you have the required permissions to run stored procedures and SQL statements.
- Know the database URL, including the hostname or IP address and the port number.
- Know the database system ID and service name.
- Know the username and password for connecting to the database.
- Know the agent group if you are connecting to an on-premises application.