MatLab R2018B Database Support

2 views (last 30 days)
George Mick
George Mick on 3 May 2021
Answered: Aravind on 5 Mar 2025
Does MatLab R2018B support Oracle's Pluggable Databases (PDB)?

Answers (1)

Aravind
Aravind on 5 Mar 2025
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.

Products


Release

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!