Data Access Features

ODBC Driver for ODBC-compliant Windows Applications

Popular Microsoft Office applications such as Access and Excel, as well as Crystal Reports and Visual Basic programs, use the ODBC standard for connecting to external data sources. AcuXDBC provides a driver that enables users of these applications to connect to your database and execute SQL commands for data retrieval and manipulation purposes.

ODBC Driver for UNIX Operating Systems

AcuXDBC enables connections to an ODBC driver from a UNIX command line or script, allowing UNIX users to access the database directly. Once connected, UNIX users can execute SQL commands or scripts through the AcuXDBC command-line query tool. For information about ODBC drivers on UNIX, see the topic: To use the unixODBC driver.

JDBC Driver for Java Applications

AcuXDBC includes a JDBC driver, which enables Java applications to connect to the database.

Command-line Query Tool

An SQL query tool enables you to execute SQL commands and scripts directly on your database tables without having to connect to the database from a third-party application or go through an ODBC connection. The command-line query tool is useful for such tasks as creating batch reports that require a series of complicated SQL commands to produce.