This is part 2, configuring for Windows and FileMaker Server. Click here for Part 1 and configuring for a Mac.
Now, 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.
- Download the PostgreSQL driver and run the installer. The direct zipped installer can be downloaded here.
- 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.
- Click the System DSN tab, then click the Add button and select the PostgreSQL Unicode driver that you just installed and click Finish.
- I entered my server and credentials and set the SSL Mode to prefer, then left all the other default settings.
- 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.
- Next, download the Actual ESS Adapter for Windows from Actual Technologies. You will need to purchase the Server Edition for FileMaker Server for $299.
- After you purchase the license, download the driver and double-click the installer. When finished you should get this success dialog.
- 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.
- On the System DSN tab, click Add and then choose the newly added Actual ESS Adapter and click Finish.
- The Actual ESS Adapter DSN Configuration wizard will now pop-up, so first enter your license key, click OK and then click Next.
- Name your DSN and give it a description and select the PostgreSQL Redshift System DSN that you setup in the above stepson click Next.
- Then click Next if you want to set a log entry if you want to log long running queries, otherwise click Finish.
- Test your connection and if successful you are done configuring the ODBC setup.
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.
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.
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.