For a long time I am looking for methods of data exchange between Hansa Enterprise and FileMaker database applications. For me, this is a big problem. I know only one method of reading data from Hansa – SQL Shadowing. (Are there any other methods?)
My Hansa Server and FileMaker Server are running on Mac OS.
I found this old description of the configuration:
(http://downloads.hansaworld.com/downloads/university/materials/HWU_SQL_18.pdf).
I can connect Hansa with MS SQL Server Express using ODBC. There is also an option "Oracle" is added to Hansa Enterprise 7.0. In theory this is great but it requires MS Windows.
At this point, I have a two questions:
1) On Mac OS I can install MySQL database and ODBC driver. I can also configure own DSN. (Exactly the same as under MS Windows). Is it possible to get connected Hansa Enterprise with a MySQL database - on Mac OS? (This is my main problem.)
2) Is there a possibility to connect Hansa Server with SQL database installed on another computer?
PS. I posted this questions in Polish version of this forum. Unfortunately, no one answered.
This answer was correctCreated by18:27 18 Jun 2013
Hello,
There is no integration at the moment with MySQL and Enterprise.
The ODBC is working only with MSSQL and Oracle, but as you mentioned, both of them will need Windows.
Also, there is no possibility to connect Hansa database with a database running on another machine.
If I understand your issue correctly, then you would like to do a data exchange between Hansa HDB and FileMaker.
We do support XML files and a technology called Web Requests (or web calls).
Maybe you can exchange the data that way.
HansaWorld Support
