Built-in Universal Database Connectivity

Using Mathematica for working with your database means:

• Applying the world's foremost high-level analysis system to your data
• Using Mathematica's high-speed data processing capabilities
• The choice to output results directly from Mathematica, back to the database or through another application
• Using the Mathematica language for encoding complex data manipulation, searching, or reporting--making programs many times shorter and faster to write
• Accessing Mathematica's unique tools for graphics and reporting

DatabaseLink is JDBC-based and works with all major databases, including Oracle and Microsoft Access. A lightweight database engine is also included, as are interactive point-and-click tools for making connections and querying data.

DatabaseLink features, in detail:

• Connectivity to most standard SQL database applications
• Connectivity to databases whether local, network-based, or on different types of machine
• Supplied drivers for a number of important databases, including MySQL, ODBC, and HSQLDB
• Includes a lightweight database, the HSQL Database Engine, useful for database applications if you don't have an existing database
• SQL command interface, letting you 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 databases
• Access to data and metadata lets you inspect the names of tables and columns and 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
• Datatype support--works with standard SQL datatypes, including numbers, strings, binary data, date and time, and Mathematica expressions
• Support for advanced features, such as multiple connections, transactions, and rollbacks
• Support for SSL communications between Mathematica and the database

Get complete example

In addition to a Mathematica language interface, DatabaseLink also includes GUIKit-based graphical interfaces:

A 7-step wizard guides you through setting up your connection.

The Database Explorer lets you do a quick query on a connected database.