Can someone give a recommendation? FM15 on a Mac trying to connect to IBM series i OS 7.1
Thanks in advance!
Are you trying to use ESS or using the "import from ODBC source" / "Execute SQL" script steps?
For ESS you have to use the ESS Adapter: Which ODBC data sources/drivers are supported with External SQL Data Sources? | FileMaker
For the two script steps to import data or update data you can use any Mac compatible ODBC driver for the AS400 back-end. But you're likely going to end up with Actual anyway
This is where I get lost, I see the link to IBM i 7.1 operating system: Overview but do not see OS X drivers.
I have texted with IBM support and they suggest I start here: IBM Knowledge Center
Please see this webpage for the Actual ESS Adaptor from Actual Technologies:
Beatrice Beaubien, PhD
FileMaker Business Alliance
FileMaker 15 Certified Developer
Knowledge Translation Certified Professional
Very close now ! I can cow hit the iSeries without any errors but does not return a list of tables for a data source.
I have filled in the Catalog Name, Schema Name, and Table name but no tables returned.
So very close! Any suggestions!
I am not familiar with your specific scenario, but I do know Actual Technologies are very helpful.
I'd suggest reaching out to them. http://www.actualtech.com/support.php
Beside the ESS feature, you can use a plugin like MBS FileMaker Plugin to connect directly to SQL databases.
This includes DB2 using the native DB2 drivers and without ODBC.
see Monkeybread Software - MBS FileMaker Plugin: SQL Connection
Retrieving data ...