Pentaho Tips - How to Connect to Oracle EX 18c

 

Scenario

In the later Oracle databases, like EX 18c, the multitenant architecture is employed. A multitenant container database (CDB) can contains multiple pluggable databases (PDB).

A PDB made up of a list of schemas and objects can be used for an application or a group of dedicated users.

Note: This architectural change was put into practice starting from Oracle Database 12c.

Example

As illustrated in the below diagram, choose Oracle for Connection type, Native (JDBC) for Access.

For Host Name and Port Number, leave them blank.

For Database Name, use the connection string as following.

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = xepdb1)))

For Tablespace for Data and Indices, write down the proper table space names.

 

Output:

Click Test button. You'll see the connection is successful.