We're moving a database into Azure but all of the FME Azure writers assume it's an MS SQL database, and the MariaDB writer doesn't have any SSL settings.
Solved
Does FME support mySQL SSL connections?
Best answer by swalters
Just in case anyone else needs an answer to this, I figured out a way to do it (although I still don't know if there's a better way of doing it):
I used a JDBC writer with a mySQL driver, and at the end of the connection string I added the following:
&generateSimpleParameterMetadata=true&rewriteBatchedStatements=true
Without rewriteBatchedStatements it would go incredibly slowly, and without generateSimpleParameterMetadata it would warn me about a lack of metadata.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.