Oracle Database

​
Connection Details

FieldDescriptionExample
HostOracle server addressoracle.example.com
PortOracle port (default 1521)1521
Service NameOracle service name or SIDORCL
UsernameOracle userreadonly_user
PasswordUser password••••••••

​
Setting Up

1

Go to Connectors → Database

Select Oracle as the database type.
Selecting Oracle
2

Enter connection details

Fill in the host, port, service name, SID, and schema.
Oracle connection form
3

Test connection

Testing Oracle connection
4

Select schemas and tables

Selecting Oracle tables
5

Save

Your Oracle data is now queryable.