Posted by rahr on May 6, 2009 at 1:52pm
I am working at a company that has several databases and applications. There are currently databases set up in FoxPro, .ASP, Microsoft Access and MS SQL and they are using ESRI for geo maps. There is currently a web site up using Dreamweaver, but we are interested in moving over to a Drupal platform. Will it be possible to access any of our myriad databases through Drupal? We can convert if we can get at least one to work. Any help will be very welcome.
Thanks in advance,
Huckleberry Rahr
Comments
=-=
http://drupal.org/requirements
That doesn't really help me.
That doesn't really help me. From my research, we can't have the drupal platform access our Microsoft Access database. We can't move our data to a different database. If anyone can help, that would be great, if not, anyone know where we can look?
ODBC
I solved this by connecting to the database with an ODBC. With Access, the database had to be local, with a SQL database, I can connect to the base server. I created PHP code for the interaction with the database. Overall it worked well. That said, if the information in the Access database was small, it is nice to be able to create a CCK and use Drupals database management system to manage the information, and views for the display.
Huckle
Module Development
Is there a module that could assist with linking a local database and a Drupal database?
For instance, to setup a large amount of users, we exported the users we wanted from our database and imported them into Drupal. However, we have frequent profile updates (e-mail changes, address changes, etc.) It would be very helpful if the manager of our Microsoft Access database could make an update, and then have that reflected on that specific user's profile on our Drupal install.
Should I make a feature request, or?