Get Started with Database Toolbox
Database Toolbox™ provides functions and an app for interacting with relational and NoSQL databases. The toolbox supports any ODBC-compliant or JDBC-compliant relational database and provides NoSQL support for Apache® Cassandra®, MongoDB®, and Neo4j®.
Native interfaces for MySQL®, PostgreSQL, and SQLite provide functionality that streamlines interaction with your database. The interfaces ship with third-party drivers that connect to your database in deployed and cloud environments without additional setup or installation.
Database Toolbox provides direct read and write workflows for novice users and fine-grained control for advanced users who are familiar with SQL. With the Database Explorer app, you can explore relational data interactively and generate MATLAB® code to automate or operationalize database workflows. For large data workflows, you can run query filters directly on your SQL queries. The toolbox has an Object Relational Mapper (ORM), which provides a layer between MATLAB and SQL queries, so your MATLAB objects can interact with your database tables.
- Access Relational Database Data in MATLAB
Decide which Database Toolbox functionality to use for your situation.
- Interact with Data in SQLite Database Using MATLAB Interface to SQLite
Analyze data without access to a database or driver by using the MATLAB interface to SQLite.
- Configure Driver and Data Source
Install drivers and configure data sources for your database environment.
- Connect to Database
After configuring a driver and data source, connect to your database.
- Data Import Using Database Explorer App or Command Line
Learn the best way to import data from your database into MATLAB.
- Explore and Import Data from Cassandra Database Table
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 and Analyze Data from MongoDB Using MongoDB C++ Interface
Import all documents from a MongoDB collection into the MATLAB workspace and perform a simple data analysis of numerical fields.
- Graph Database Workflow for Neo4j Database Interfaces
Discover the Neo4j graph database and explore the Neo4j database interfaces and workflow.
About Using Relational Databases with MATLAB
- Choose 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.