For a project at work I am building an intranet site using Contao. I need to get data from an existing MS Access database which is important for me to display inside the website. Right now I am just in a planning/orientation stage and I'd like to figure out how to best approach the problem. Just to be clear; the Contao db is MySQL, I need to get external data from the Access db.
I see in the drivers folder that there is no existing driver. Should I write one, or are they only intended for use by the Contao website itself?
Has anyone done this already?
ps, Would adding an Access driver not allow Contao to be run on servers without a database? It might be an extra feature to think about? Scratch that, I did some research. Still wanting an answer to the actual question though...