Features of DatabaseLink

DatabaseLink provides the following features.

• Connectivity with most standard SQL databases applications.
• Connectivity with databases that are local and network based (including different types of computer).
• Supplied drivers for a number of important databases, including MySQL, Open Database Connectivity (ODBC), and HSQL Database Engine (HSQLDB).
• A lightweight database, the HSQL Database Engine (HSQLDB) - useful for database applications if you don't have an existing database.
• SQL command interface - you can exploit your knowledge of SQL without learning a new system.
• Mathematica command interface - useful if you are familiar with Mathematica programming.
• GUI interfaces - the Database Explorer and the Connection Tool provide convenient tools for opening connections and querying the database.
• Access to data and metadata - you can inspect the names of tables and columns, as well as the data in each entry.
• Configurable - common tasks can be simplified and Mathematica applications can add their own database information.
• Batch support - provides efficiency when making repeated changes to a database.
• Data type support - works with standard SQL data types, including numbers, strings, binary data, date and time, as well as Mathematica expressions.
• Support for advanced features - e.g. multiple connections and transactions (including rollbacks and savepoints).
• Support for Secure Socket Layer (SSL) communications with the database.