We need external data to be imported synchronously into a Sharepoint list. The data is located in a MySQL database. The Sharepoint server is setup behind a firewall and no direct connection to the MySQL database is possible. In this situation we create a data file (XML or CSV) from the MySQL database and we want to import the data to a Sharepoint List synchronously.
How could this be done ?
I have looked into different possibilities : -Layer2 BDLC with ODBC Conto a file -External List / External Data Type ? -Data Connection Library ?