Database Toolbox 

Exchange data with relational and nonrelational databases  

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™).

Get Started:

Database Explorer App

Explore data in relational databases without any prior knowledge of SQL.

Overview

Explore data from relational databases using a visual interface without knowing the SQL programming language. Filter and import data as a MATLAB table. Then perform subsequent analytics with your existing knowledge of MATLAB tools and functions.

Code Generation

Easily reproduce and automate your exploration activities by generating MATLAB or SQL scripts.

MATLAB code generated from the Database Explorer app.

Exchange Data with Relational Databases

Import data from – and export data to – relational databases directly within MATLAB. Use your existing knowledge of SQL to exchange data programmatically, or interact with your data without using SQL.

Import from Relational Databases

Execute SQL queries directly within MATLAB, or use SQL-speaking functions to exchange data and perform joins on database tables without writing SQL queries. Customize an import strategy for any relational database to minimize postprocessing steps on imported data.

Importing data into MATLAB using a variety of approaches.

Import Large Data Sets

Import data from large data sets in a segmented and sequential manner. Retrieve all or a subset of the data. Easily split SQL queries, which can execute in parallel using Parallel Computing Toolbox and MATLAB Parallel Server.

Importing large data sets in parallel (or sequentially).

Export to Relational Databases

Export your results stored in a MATLAB table to a database by specifying the names of the target database columns. Export your results in a MATLAB table as new data, or update existing data in the database.

Exporting data from MATLAB.

Exchange Data with SQLite Database Files

Use the MATLAB Interface to SQLite to create, read, and write relational data from SQLite database files without installing or administering database software or drivers.

Import from SQLite Database Files

Import data from SQLite files directly into MATLAB using the MATLAB Interface to SQLite.

Importing data from an SQLite Database file.

Export Data to SQLite Database Files

Create SQLite database files and insert or update tables from MATLAB using the MATLAB Interface to SQLite.

Exporting data to an SQLite database file.

Exchange Data with Cassandra

Access and import columnar data using the Database Toolbox interface for the Apache Cassandra database.

Import Data from Cassandra

Access data using keyspaces, database tables, and partition key values without writing CQL queries. Alternatively, execute CQL queries on your Cassandra database and import the query results into MATLAB.

Importing data from Cassandra.

Exchange Data with Mongo DB

Store, query, and retrieve unstructured and structured data using the Database Toolbox interface for MongoDB.

Import Data from MongoDB

Import complete or filtered data from a MongoDB collection into the MATLAB workspace.

Importing data from MongoDB.

Export Data into MongoDB

Create MongoDB collections from MATLAB. Insert data by exporting MATLAB MCOS objects, or by inserting table and structure data from the MATLAB workspace.

Exporting data into MongoDB.

Exchange Data with Neo4j

Explore, manage, and store graph data in Neo4j databases using the MATLAB interface to Neo4j. Perform graph network analysis with or without existing knowledge of the Cypher® graph query language.

Import and Explore

Import graph data from a Neo4j database into MATLAB as a digraph object. Conduct general or targeted searches with existing MATLAB functions.

Traversing a graph and exploring its structure.

Update and Export

Create, update, and delete nodes and relationships in a Neo4j database. Export a directed graph from MATLAB into a Neo4j database using the storeDigraph function. 

Creating, updating, and deleting graph information.

Analyze Graph Data

Perform graph network analyses to find dependencies, shortest path, and successor nodes using Cypher queries or the MATLAB digraph object.

Analyzing relationships with a MATLAB digraph object.

Latest Features

Native Interfaces

Support added for MySQL® and PostgreSQL® databases

Database Table Import

Preserve non-ASCII characters during column name import

JDBC Connectivity

Configure and save JDBC data source using SQLConnectionOptions object

See the release notes for details on any of these features and corresponding functions.