Posted by G0DeSs76 on April 18, 2012 at 7:48pm
So, I'm a Drupal n00b and I'm trying to display some data from an external MySQL database in a View. I found a Module called Data that says it can do what I want, however, there is no documentation and I have NO idea where to begin with it.
Do any of you guys/gals have experience with this module?
I could really appreciate some pointers.
Thank you in advance!!!
Comments
Appologies
If I broke some cardinal rule of what is allowed to be posted in this group, then I apologize. Like I said, I'm a n00b, so I still have a lot to learn.
I think you're good? Are you
I think you're good? Are you able to create feeds from the external Mysql server?
IMO -- you might be better
IMO -- you might be better off looking at the Feeds module: http://drupal.org/project/feeds
Are you able to create some RSS feeds of the external data? If so, you could import that data into your site and then create views from that imported data
Feeds is for importing data
Feeds is for importing data from a flat file into the Drupal database, which is probably not what you need.
Data and Table Wizard (Drupal 6 only) are promising but look to be irregularly maintained. Data says it has a "Data UI" module so you can hook up your tables in the back-end, but it seems to imply that it will only work with tables in the current Drupal database and not an external database.
I recently built a project that needed to query an external MySQL database and ended up taking the following approach:
Unfortunately there's no easy way to do this in Drupal (yet), it will require getting your hands dirty with some custom coding.
Orlando, FL Web Developer | http://www.garethsprice.com/
Thank you for the feedback, Everyone!
@gareth, you make custom coding sound sooo dirty... LOL
I was hoping for a cure-all/end-all that required anything but filty custom coding. :)
But I see it's time to ruin my manicure and get some dirt under my nails. pout