By bg1 on

I am trying to create a view that will pull data from a remote database running on a remote data center. I recall reading that someone solved this or had a similar problem where someone posted a suggestion but I cannot find it now.

The ideal solution would be to have the View module call a web service on the remote server (remote server already has web services). However any solution to the remote data issue would be ok at this stage.

I am a Drupal newbie (and a PHP newbie), but have a lot of experience with other programming languages, application frameworks and database development so an example of integrating remote data sources into the view module would be great. If it is not possible to integrate remote data into the views module, any example of integrating remote data into Drupal in any other way would be appreciated.

Thanks in advance for any assistance.

⋅ Categories: Drupal 6.x

Comments

WorldFallz’s picture

WorldFallz commented

You have to define your data to views in order for it to able to see and display it. This is done with hook_views_data()-- see views advanced help for more info (help/views/api-tables). There's also the http://drupal.org/project/tw module.

However, both of those methods assume tables in the drupal db-- i have no clue how you would adapt that to a remote db.

bg1’s picture

bg1 commented

Thanks for the input. Unfortunately, I don't see how this would work with a remote database.

Anyone else have any ideas?