Database Connectivity

The Wolfram Language has a built-in high-level interface to all standard SQL databases that allows immediate searching, reading, and writing of arbitrary data and expressions, as well as supporting general SQL database features, including discovery, result sets, and transactions.

Dataset represent the contents of an SQL or no-SQL database

SQL Database Operations »

OpenSQLConnection connect to any JDBC-compatible SQL database

SQLSelect  ▪  SQLUpdate  ▪  SQLInsert  ▪  SQLDelete  ▪  ...

SQLExecute execute any SQL command, generating Wolfram Language output

SQLTableNames  ▪  SQLTableInformation  ▪  SQLDataTypeNames  ▪  ...

SQLBeginTransaction  ▪  SQLResultSetOpen  ▪  ...

DatabaseExplorer use a GUI to explore databases and generate notebooks

Import import entire MDB etc. databases

SemanticImport import semantically, converting to Wolfram Language representations

Related Tutorials