Marcel, Thank you for sharing. That is indeed the best way to do it.
In addition to that you might want to include escape characters in the configuration. Otherwise if you would have an 'Order' table this could give you errors:
Escape character open `
Escape character close `
The reason MySQL, and for example MS Access are not available by default is licensing. Last time I checked it wasn't allowed to redistribute the library.
The library is free to use and download, however at that time, it wasn't allowed to include the libraries in any form of re-distribution. In other words we are not allowed to include it in the appstore .mpk files.
We have use MySQL and MS Access integration for several customers, this is possible using the custom settings as specified in your question.
The implementation has been tested, and if you have any ideas on improving support for these 'custom' types please let us know and we can change that.
I connected a postgreSQL database and this works fine (although very slow, 1000 objects per 3 minutes). Also the associations are set and created as set in the mappings. Now I want to connect to a MySQL database and still use the associations. Is there any solution to make the association in the mapping work for a mySQL database?
I’m aware that this entry was made a long time ago. But I’m facing some issues while using your method to connect to a MySQL database. My question is posted here: Using Database Replication module, after set up: 0 tables found
Has anybody had similar behaviors? Is this a permssion issue on the database side?
Can anybody help me with this issue please?