Drupal 7 Data Module

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
G0DeSs76's picture

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

G0DeSs76's picture

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

geekluv's picture

I think you're good? Are you able to create feeds from the external Mysql server?

IMO -- you might be better

geekluv's picture

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

garethsprice's picture

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:

  1. Added the external database into settings.php file as an alternative data source
  2. Wrote a custom module that ran queries against the external database
  3. Displayed retrieved data using the Theme API's Table function

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!

G0DeSs76's picture

@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

Florida

Group organizers

Group categories

Florida Topics

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: