Experiences of a FileMaker Pro Database Developer

FMS 15, ESS & AWS Redshift

This is part 2, configuring for Windows and FileMaker Server. Click here for Part 1 and configuring for a Mac.

fmsAmazonredshift_220x110Now, to get FileMaker Server running on Windows 2008 configured for ODBC access to Amazon Redshift. I first tried the specific Amazon Redshift ODBC driver and this did not work with the Actual ESS Adapter. The Adapter would not recognize Amazon’s driver. Maybe Actual can work on this. So, you will need to use the recommended PostgreSQL driver.

  1. Download the PostgreSQL driver and run the installer. The direct zipped installer can be downloaded here.
  2. After the driver is installed, go to the Start Menu, All Programs, Administrative Tools and open the Data Sources (ODBC), the ODBC Data Source Administrator.Screen Shot 2016-05-18 at 3.34.47 PM
  3. Click the System DSN tab, then click the Add button and select the PostgreSQL Unicode driver that you just installed and click Finish.Screen Shot 2016-05-18 at 3.38.06 PM
  4. I entered my server and credentials and set the SSL Mode to prefer, then left all the other default settings.Screen Shot 2016-05-18 at 3.41.37 PM
  5. Once setup, click the Test button and you should see a successful test dialog. Click OK and then Save. You are now done setting up the driver with Redshift.Screen Shot 2016-05-18 at 3.43.58 PM
  6. Next, download the Actual ESS Adapter for Windows from Actual Technologies. You will need to purchase the Server Edition for FileMaker Server for $299.
  7. After you purchase the license, download the driver and double-click the installer. When finished you should get this success dialog.Screen Shot 2016-05-18 at 2.44.56 PM
  8. Now you can jump back to the ODBC Data Source Administrator if it’s still open, or go back to the Start Menu, All Programs, Administrative Tools and open the Data Sources (ODBC), the ODBC Data Source Administrator.
  9. On the System DSN tab, click Add and then choose the newly added Actual ESS Adapter and click Finish.Screen Shot 2016-05-18 at 3.46.12 PM
  10. The Actual ESS Adapter DSN Configuration wizard will now pop-up, so first enter your license key, click OK and then click Next.Screen Shot 2016-05-18 at 2.52.12 PM
  11. Name your DSN and give it a description and select the PostgreSQL Redshift System DSN that you setup in the above stepson click Next.Screen Shot 2016-05-18 at 3.47.29 PM
  12. Then click Next if you want to set a log entry if you want to log long running queries, otherwise click Finish.
  13. Test your connection and if successful you are done configuring the ODBC setup.Screen Shot 2016-05-18 at 3.51.38 PM

The External Data Source configuration in FileMaker is the same setup as I described in Part 1, except that the Data Sources available are those defined by what is setup on the Host machine, in our case the FileMaker Server.Screen Shot 2016-05-18 at 4.21.07 PM

The above screenshot is from FileMaker Client 14 because I have not installed 15 on the Windows Server box yet. What I think this means is that the Actual ESS Adapter has been built to conform other SQL datasources to FileMaker’s ESS requirements and is just exactly that, an ESS adapter. I am not sure what this means yet and if it’s actually compatible and will work with other versions of FileMaker. Here is a screenshot of FileMaker Pro client v13 accessing the local PostgreSQL Redshift data source I configured in Part 1.FMP13_Redshift


There is a lot more testing needed to see if it would actually work in previous version or not. Just because I can add the table and do a simple find, doesn’t mean all things SQL will work. I need to dig deeper and find out if it was designed and created to only work with version 15. Regardless, I’m just happy that I now have a connection using ESS to our Redshift data sources.

Next, will be testing speed, adding and editing records, etc.

Post to Twitter

FileMaker 15, ESS and AWS Redshift


I'm rather excited about the release of FileMaker 15. One of the hidden gems is the expansion of SQL database support within ESS (External SQL Data Sources) and the addition of PostgreSQL databases. This means FileMaker can integrate directly with … [Continue reading]

Unix Timestamp Custom Function

I needed to create a custom function to convert a standard FileMaker timestamp to the Epic Unix Timestamp. We are beginning to develop in Redshift on AWS and need to pass data from FileMaker to a table in Redshift. I created the custom function to … [Continue reading]

Usability: A Lesson From Evernote’s Penultimate 6 Blunder

Penultimate 5

As software/app developers it's critical that we understand usability. We must learn who our users are and their behavior. Essentially, we build use cases and user personas. It’s our job to figure out what is working and what doesn’t work in their … [Continue reading]

It’s Been a While

It's been a while since I posted to this blog. No excuses, just adjusting to working full time. There has been a lot going on with my FileMaker development and I even heard from Commander "Devil Doc" Baker who's now stationed at Camp Lejeune. It was … [Continue reading]

FileMaker 12 Review – Part 1

We've been running the FileMaker 12 family of products since August 2012. These are my impressions and experiences in a real world, live development environment. My experience is taking an existing FileMaker 11 solution and converting it to run in … [Continue reading]

Creating QR Codes with FileMaker and KAYWA API

I want to thank Kevin Murphy for submitting his FileMaker QR Code solution using the KAYWA API for creating QR Codes. With the fate of Google's API for creating QR Codes unknown, it's good to see alternative solutions. Kevin's recent submission has … [Continue reading]

Recent Changes

I've recently made several changes and have been absent for a while in both the FileMaker community as well as my blog. I hope to be on track in the next few weeks as I dive into some new tools for optimization and new areas with FileMaker products. … [Continue reading]

A Time for Thanks

It's that time of year to celebrate Thanksgiving, to be thankful for the many blessing that we all have. This year, I have the pleasure of working with a military psychiatrist, CDR Alfredo “Devil Doc” Baker, MD, MC, USN, who is stationed in … [Continue reading]

Helping Our Soldiers Quit Smoking, Part 3


Planning the Database The way I see the Tobacco Cessation database laying out is that there will essentially be two tables. One table stores the Marine & Sailor's basic information. This is the people table. In this table is everything that … [Continue reading]