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.
Best answer by swalters
View originalWe'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.
Best answer by swalters
View originalJust 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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.