How to enter additional connection properties to MySQL linked service in ADF

Question

How can I configure additional connection parameters in the latest version of the MySQL linked service connector? Connection strings are no longer supported and I would like to set TreatTinyAsBoolean=false, as suggested in the documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-mysql?tabs=data-factory#data-type-mapping-for-mysql

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

In the Azure Data Factory UI, when creating or editing your MySQL linked service, scroll down to find the Additional Connection String Properties field, in this field, enter the additional parameter you want to set:

TreatTinyAsBoolean=false;SslMode=Required

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Answer 2

Hi rmarian ,

Since there is no additional properties option in 'Azure Database for MySQL' , it seems it's not possible to add it . You could try editing the JSON of the linked service and see if it works.

In case you want to raise a product suggestion , kindly use this platform for the same: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

Hope it helps . Kindly accept the answer by clicking on Accept answer button. Thankyou