Get Started with Database Toolbox
Database Toolbox™ provides functions and an app for exchanging data with relational and nonrelational databases. It enables this exchange by automatically converting between database and MATLAB® data types.
Database Toolbox supports any ODBC-compliant or JDBC-compliant relational database. It also provides NoSQL support for Apache™ Cassandra®, MongoDB®, and Neo4j®. Native interfaces are provided for MySQL® and PostgreSQL.
With the Database Explorer app, you can explore relational data without writing code and then generate MATLAB code to automate or operationalize database workflows. For large data workflows, you can split SQL queries and parallelize access to data (with Parallel Computing Toolbox™ and MATLAB Parallel Server™).
Decide which Database Toolbox functionality to use for your situation.
Install drivers and configure data sources for your database environment.
After configuring a driver and data source, connect to your database.
Learn the best way to import data from your database into MATLAB.
Access the structure of a Cassandra database and import data from the database with a keyspace, database table, and partition key value using the Apache Cassandra database C++ interface.
Import all documents from a MongoDB collection into the MATLAB workspace and perform a simple data analysis of numerical fields.
Discover the Neo4j graph database and explore the Neo4j database interfaces and workflow.
About Using Relational Databases with MATLAB
- Choosing Between ODBC and JDBC Drivers
Discover the differences between ODBC and JDBC drivers, and choose the correct driver for your situation.
- Connection Options
Choose the best way to connect to a database for your situation.
- Setup Requirements for Database Connection
Before configuring a driver and data source, find the requirements for establishing your first database connection.
- Data Type Support
Find supported data types for data import and export.