Exporting data from MSSQL for use in EDM

We have data in a SQL database that changes daily that we would like to use in an Exact Data Match (EDM) index . (About Exact Data Match). I can do this manually, but we are looking for an automated solution that would run daily and query the DB, store the results in a CSV, and then place in on the EDM Index VM ( I believe it is running CentOS). Just curious if anyone is already doing something similar or had any suggestions.

Reach out to @Paddy_Ganti . I believe he did this for a specific customer.