All Actual Technologies ODBC drivers conform to the iODBC standard supported by Apple since Mac OS X 10.2 "Jaguar". Any application that also uses this standard will be able to take advantage of our drivers. Here is a partial list of some common applications you can use to connect to databases on Mac OS X.
Use FileMaker 15 to view and update data in your database without writing any SQL! Use FileMaker Pro 6 or later (including FileMaker 15) to import data from other databases into your FileMaker database. You can also create a new FileMaker database based on the structure of an existing ODBC data source (such as SQL Server or Sybase).
You can use Excel X or later (including Excel 2016) to query databases with our drivers. Users can build simple or complex queries using Microsoft Query. Excel allows you to import query results into spreadsheets in tabular form, or create sophisticated pivot table reports.
Xojo by Xojo, Inc.
Xojo (formerly REALbasic) is a powerful, easy-to-use tool for creating custom cross-platform applications. Xojo includes full support for ODBC on Mac OS X, so you can quickly create client / server applications that access and update data from your MS SQL Server database.
Other compatible applications:
Actual SQL Server:
- SQL Server 6.5 or later, including all editions of SQL Server 2016
- Microsoft Azure SQL Database
- Sybase ASE 12 or later
- Sybase ASA / iAnywhere 5.5 or later
- Oracle 7.3.4 or later, including Oracle 12c
Actual Open Source Databases:
- MySQL 3.23 or later
- MariaDB 5.3 or later
- PostgreSQL 7.3 or later
- SQLite 3.0 or later
- MS Access 97 or later
- Tab delimited text files
- Comma separated variable (CSV) files
- Excel 97 or later spreadsheet files
Mac OS X Compatibility
- Mac OS X 10.5 or later (including 10.11)
- PowerPC and Intel Macs