Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Database Toolbox

Exchange data with relational and nonrelational databases

Database Toolbox™ provides functions and an app for working with relational databases. It includes support for nonrelational databases, and provides a native SQLite database. You can access data in relational databases using SQL commands, or use the Database Explorer app to interact with a database without using SQL.

The toolbox can connect to any ODBC- or JDBC-compliant relational database, including Oracle®, SAS®, MySQL®, Microsoft® SQL Server®, Microsoft Access™, and PostgreSQL. You can create, query, and manipulate native SQLite relational databases without additional software or database drivers.

The toolbox supports nonrelational databases Neo4j® and MongoDB®. The Neo4j interface lets you access data stored as graphs or queried using nongraph operations. The NoSQL database interface to MongoDB provides access to unstructured data.

The toolbox lets you access multiple databases simultaneously within a single session and enables segmented import of large data sets using DatabaseDatastore. You can split SQL queries and parallelize access to data (with MATLAB® Distributed Computing Server™ and Parallel Computing Toolbox™).

Getting Started

Learn the basics of Database Toolbox

Relational Databases

Explore data in databases such as Microsoft Access, Microsoft SQL Server, or Oracle by configuring ODBC and JDBC drivers and using SQL

Graph Database

Explore graph data in Neo4j database using MATLAB interface to Neo4j and perform graph network analysis

Document Database

Explore and manage collections of documents in MongoDB using Database Toolbox interface for MongoDB

Was this topic helpful?