How connect a MySQL database to Survey123?

[mayraiguago]

Hello, I need help with this, please
I have a database in MySQL and is updated daily, and I want to link that information to survey123. Is this possible? Currently, the information is in a CSV file, but I'm constantly updating it manually. How can I establish a connection so that the information is automatically loaded from a MySQL database, and the information is updated in real time?
Thank you for your help

[ZenMasterZeke]

I don't have an answer to this, but the S123 database in the field app is SQLite, if that helps. You may want to explain in what way you want to use the MySql db - surveys submitted there, data pulled from db to populate survey, other, ???.

[mayraiguago]

Thank you for your response. Yes, I want the data extracted from the MySQL database to be used for the survey. Currently, the survey data is extracted from a CSV file, but the CSV updates are manual and not real-time, so I want to connect to the MySQL database

[Neal_t_k]

It appears that mySQL is not support by ESRI. https://pro.arcgis.com/en/pro-app/latest/help/data/databases/dbms-support.htm.

Not sure if this would work or not, but have you considered a task/script to export your mySQL data to a CSV, and a second script to update that CSV to your linked media for your form.  In theory it should work, as some quick searches suggest both are possible.

https://stackoverflow.com/questions/55714258/steps-to-extract-data-from-mysqldb-to-csv-using-python#....

https://community.esri.com/t5/arcgis-survey123-questions/updating-a-hosted-csv-linked-to-survey123/t...