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, as well as NoSQL support for Cassandra, MongoDB, and Neo4j.
With the Database Explorer app, you can explore relational data without writing code and then generate MATLAB code for automating or operationalizing database workflows.
For large data workflows, you can split SQL queries and parallelize access to data (with Parallel Computing Toolbox™ and MATLAB Parallel Server™).
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.
Easily reproduce and automate your exploration activities by generating MATLAB or SQL scripts.
Import from Relational Databases
Execute SQL scripts 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.
Export to Relational Databases
Export your results stored in a MATLAB table to a database by specifying the names of the database columns for storing results. Export your results in a MATLAB table as new data, or update existing data in the database.
Import Data from Cassandra
Access data using keyspaces, database tables, and partition key values without writing CQL queries. Alternatively, execute a CQL query on the Cassandra™ database and import the query results into MATLAB.
Import Data from MongoDB
Import complete or filtered data from a MongoDB® collection into the MATLAB workspace.
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.
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.
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
Analyze Graph Data
Perform graph network analyses such as dependencies, shortest path, and successor nodes using Cypher queries or the MATLAB digraph object.
Advanced Database Import Options
More options to apply on imported data. Access import options from the Database Explorer app.