What Is Database Toolbox?
Database Toolbox™ provides functions and an app to interact with your relational or NoSQL database. Use an ODBC or JDBC driver to connect to relational databases hosted locally or on the Cloud or data platforms. You can also connect directly to your PostgreSQL®, MySQL®, or SQLite database using built-in drivers in both desktop and deployed environments. Connect and interact with NoSQL databases such as MongoDB®, Apache™ Cassandra®, and Neo4j®.
You can use the included app, Database Explorer, to navigate your database and import data from tables without writing SQL queries or MATLAB® code. Once you have your data of interest, you can save your workflow as a SQL query or MATLAB script.
Database Toolbox provides functions to interact with your relational database at any level of SQL knowledge. You can execute queries directly on your database, or call functions that generate SQL queries to read, write, and perform inner and outer joins from your tables. You can apply filters to your import functions that produce more complex SQL queries to filter on your database rows and columns, allowing you to import only the data you need into MATLAB.
Published: 10 Mar 2023
As organizations continue to standardize where and how data can be stored, engineering data is migrating away from local files to new locations, such as cloud storage, data warehouses, and more traditionally, databases. Database Toolbox provides features to build and deploy MATLAB applications that interact with your database regardless of your level of SQL knowledge. You can connect to any ODPC or JDBC-compliant database, including popular relational databases, databases hosted on cloud services, and data platforms.
Ship drivers from MySQL, Postgres, and SQLite allow for easy connection and deployment of your applications to your database. You can also connect to popular NoSQL databases, such as Apache Cassandra, MongoDB, and Neo4j. You can use built-in functions to interact with your database or use a database-specific query language.
An included app, Database Explorer, enables you to interactively work with your relational databases without having to write MATLAB code or SQL. You can explore your database tables, preview your data sets, and import data of interest as a table directly into MATLAB. Once you have your data, you can save your workflow, as either a MATLAB script or an SQL query.
The Toolbox also provides built-in functions to interact with your database with or without an SQL query. If you prefer using SQL, you can execute queries directly with the Fetch command. Otherwise, you can use functions such as SQL Read and SQL Write to achieve the same results as an SQL query.
For more fine-grained control, you can specify custom import options, or apply row filters to these functions. These filters generate SQL queries that apply predicate pushdown to filter data directly on your database, only importing the data that you need into MATLAB. To learn more, explore the documentation for examples and features. Or, try the Database Explorer to get started.