MatLab R2018B Database Support

Does MatLab R2018B support Oracle's Pluggable Databases (PDB)?

Answer 1

[Aravind]

Hello @George Mick,

MATLAB R2018b can indeed connect to Oracle's Pluggable Databases (PDBs) if the connection is set up correctly. Oracle's multitenant architecture, introduced with Oracle 12c, allows a Container Database (CDB) to host multiple PDBs, which are essentially databases within a CDB.

To connect to a PDB using MATLAB R2018b, you need the appropriate Oracle JDBC driver that is compatible with your Oracle Database version, including support for PDBs. Ensure that your connection string in MATLAB specifies the service name or SID for the PDB, rather than the CDB, to direct the connection to the specific pluggable database. An example of a connection string might look like this:

conn = database('username', 'password', 'jdbc:oracle:thin:@//hostname:port/pdb_service_name');

Once you have the correct connection string, you can establish the connection using functions from the Database Toolbox, such as the "database" function. For more detailed information on using the "database" function, you can enter the following command in the MATLAB command prompt:

doc database

This approach allows you to connect to PDBs from MATLAB R2018b. I hope this clarifies your query.