Now you don't have to be a programmer to easily connect to a MySQL, PostgreSQL or SQLite database! Finally, there is an ODBC driver that is really easy to use. The Actual ODBC Driver for Open Source Databases installs quickly and easily, using familiar Mac OS installation tools. You'll be importing data into FileMaker Pro in no time - for only $49.95!
Use FileMaker Pro and Excel to Connect to Your Database
FileMaker Pro is great for creating great looking reports, and now you can use it with
data from your MySQL, PostgreSQL or SQLite database. You can also harness the full power of
Excel's built-in support for ODBC database queries to create pivot tables and charts
and graphs from your data.
See our list of featured compatible applications for other
common programs you can use with our drivers.
Easy Installation and Setup
A helpful setup assistant will guide you through the process of connecting to your database. Handy diagnostic tools and on-line help are there if you need it. And Actual Technologies' knowlegable support staff is always there to assist you if you have trouble.
The setup assistant walks you through the process of configuring your connection. It prompts you for the information it needs.
You can connect to MySQL, Postgres and SQLite databases using the same familiar setup screens. All you have to do is specify which type of database you want to connect to.
All you need to connect to your database is the IP address of the server, your user ID and password (PostgreSQL users also have to know the name of the database).
Only Actual drivers give you the reliability and ease of use you've come to expect as a Mac user.
Connect to Your Database in the Cloud
In addition to local databases, the driver now supports cloud-based solutions. Amazon Relational Database Service (RDS) provides a fast and easy way to configure MySQL and Postgres databases in the cloud. Google Cloud SQL is a MySQL database that is hosted within Google's massive hosting environment. And Amazon Redshift is a massively parallel data warehouse base on PostgreSQL. The Actual Technologies ODBC driver makes it easy to connect to these great cloud-based databases in just a few clicks.
Get Connected to CoreData
Apple's CoreData technology is built on top of SQLite, so many of your favorite applications use
SQLite databases to store information. You can use this driver to access that information using
an ODBC-enabled application such as FileMaker. For example, you can import your Safari RSS articles
into an Excel spreadsheet, or import your Mail data into FileMaker. See our partial list of applications
using a SQLite database.
Like CoreData, Xojo's built-in database is also based on SQLite. If you develop software with
Xojo, you can give your users the ability to generate reports using Excel and FileMaker from the
data stored in your database.
Try It Today
Download and evaluate our driver today. You will be able to install the driver, set up a connection, and retrieve data* from your database using Excel or FileMaker. You will also have access to our on-line help and technical support.
* Downloaded driver has all features turned on, except that it will only return 3 rows from any query until the driver is registered. Once you are ready to register your driver, just go to our secure on-line store. We will send you a license key that will allow an unlimited number of rows to be returned from any query.
Database Compatibility
- MySQL 5.0 or later
- MariaDB 5.3 or later
- PostgreSQL 7.3 or later
- SQLite 3.0 or later
- Amazon Redshift
Mac OS Compatibility
- Mac OS 10.9 or later (including Sequoia)
- Intel and Apple Silicon Macs