This can be accomplished via the Admin Console. Within the Integrations section, you can configure connections to an external database

Just need to enter Oracle DB connection string, username, and password. If it is Appian Cloud already includes the supported JDBC drivers (Oracle, SQL Server, MySQL, PostgreSQL, etc