What can you do with an Actual Technologies ODBC driver on Mac OS X?

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.

 

FileMaker Pro by FileMaker, Inc.

Use FileMaker 9 to view and update data in your database without writing any SQL! Use FileMaker Pro 6 or later (including FileMaker 9) 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).


Excel and Query by Microsoft

You can use Excel X or later (including Excel 2008) 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.


REALbasic by REAL Software

REALbasic is a powerful, easy-to-use tool for creating custom cross-platform applications. REALbasic 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:

 


 
 

 
 

 

Database Compatibility

Actual SQL Server:

  • SQL Server 6.5 or later, including all editions of SQL Server 2005
  • Sybase ASE 12 or later
  • Sybase ASA / iAnywhere 5.5 or later

Actual Oracle:

  • Oracle 7.3.4 or later, including Oracle 10g

Actual Open Source Databases:

  • MySQL 3.23 or later
  • PostgreSQL 7.3 or later
  • SQLite 3.0 or later

Actual Access:

  • MS Access 97 or later
  • Tab delimited text files
  • Comma separated variable (CSV) files
  • Excel 97 or later spreadsheet files

Actual OpenBase:

  • OpenBase 8.0 or later

Mac OS X Compatibility

  • Mac OS X 10.2.8 or later (including 10.5)
  • PowerPC and Intel Macs