Skip to main content
Use this to connect Alumio to an Oracle database server. Once it is set up, the connection can be reused by other features that read from or write to your Oracle database. Oracle servers can be reached in two ways, by service name or by SID, and this connection lets you pick whichever your server uses.

Fields

Sample data

A typical Oracle connection using a service name:
FieldValue
Server hostyour-db-host.example.com
Server port1521
Connection typeserviceName
Database nameORCLPDB1
Character setUTF8
Usernameintegration_user
Passwordyour-password
{
    "host": "your-db-host.example.com",
    "port": "1521",
    "connectionType": "serviceName",
    "databaseName": "ORCLPDB1",
    "charset": "UTF8",
    "username": "integration_user",
    "password": "your-password"
}
Connection credentials are shown here as placeholders. See Placeholders for how to reference an environment variable instead of typing a secret directly.