Skip to main content
Question

How can you integrate an external Oracle database or any database with Appian Cloud?

A
Anonymous
December 16, 2025

Answer

Appian Cloud connects to external relational databases such as Oracle over JDBC. You can set the connection up in two ways.


Method 1: Admin Console

  1. Log in to Appian Cloud as a system administrator.
  2. Go to Admin Console → Integration → Data Sources.
  3. Click New Data Source.
  4. Enter the connection details:
  5. Name: jdbc/OracleDB
  6. Type: Oracle
  7. Connection string: the Oracle JDBC URL
  8. Username and password for the database account
  9. Click Test Connection to check that Appian can reach the database, then click Save.

1765923708895-idn7mjkpr6.png

Once it’s saved, you can use the database through record types, data stores, and the Query Database smart service.


Method 2: Data Source connected system (recommended)

  1. In Appian Designer, select New → Connected System.
  2. Choose Oracle Data Source, or another supported database.
  3. Enter the JDBC connection URL and the authentication credentials.
  4. Create the connected system and use it in your application.

How can you integrate an external Oracle database or any database with Appian Cloud?

This is the better option for a few reasons. It deploys across Dev, Test, and Production. It supports object-level security. It keeps the database connection settings in one place, and it lets you set connection pool limits.


Supported databases

Appian has built-in JDBC support for Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MariaDB, IBM DB2, and Amazon Aurora (MySQL and PostgreSQL). Any other JDBC-compatible database can go through a Custom JDBC connected system, though functionality may differ from the supported ones.

Things to check

  1. Network: Appian Cloud has to be able to reach the database. A database on a private network may need a VPN or another supported private connection.
  2. Security: Use TLS/SSL and set firewall rules appropriately.
  3. Drivers: Appian Cloud ships with drivers for its supported databases, so you usually don’t need to install anything.


Interview tip: Getting the JDBC URL, username, and password right is only part of it. The database also has to be reachable from Appian Cloud, and the connecting user needs the right database permissions.


References: Appian: Data Sources · Appian: Data Source Connected Systems

Check yourself

Question 1 of 3, on what the answer above covers.

  1. 1.
    Your Appian application connects to an external Oracle database. The same application must be deployed across Development, Test, and Production, each with different database connection details. Which approach is most suitable?
JuniorAdmin ConsoleExternal Systems