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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.