I have a Django site running on a Linux based server. My partner has SQL Server running on a IIS Windows server behind a Cisco router. We are looking for a secure way for the Django site to connect to SQL server and interact with the database.
Currently we are solving the problem by running a shell script in a cron job that !) starts the VPN using vpnc, 2) runs python code (pyodbc) and writes the results to sqlite db, 3) disconnects the VPN. Then in the django code we access the sqlite database. This solution seems pretty obtuse.
The ideal approach would be to have pyodbc connect directly and securely to SQL Server. Anyone know how to accomplish this?