Hi, I'm testing the module but I still have not figure out how to use it correctly.
Goal: I need to expose the fields from an external non-drupal database, then create views using those fields. I don't want to import all the content from the external db into drupal. I only need to access the fields without creating nodes first.
I don't see a processor option that will allows me to query the db without mapping the fields to Drupal content fields. Is it possible to do this?
This is what I have at the moment in a drupal 7 site:
1) Added my db info to settings.php then I created an importer (/admin/structure/feeds/create).
2) Basic settings
Attached to: [none]
Periodic import: off
Import on submission
3) Fetcher
SQL fetcher: Fetches data from an external database
Settings for SQL fetcher: select mydatabase
4) Parser
SQL parser: Parses data fetched from an external database.
Settings for SQL parser: created my query here: select * from mydatabase
and verified the query works.
5) Processor
Select a processor: there are only 3 options, none of the options works for our needs. What do you recommend?
once the importer is ready, I can not create the views because there is not a way to read the table fields from the feed I created above. I never imported the content from the external db onto nodes.
The functionality I described above can be achieved in Drupal 6 with the table wizard module. The tw module exposes available tables from db connections defined via the settings.php file.
Do you think is it possible to use your module to achieve similar functionality?
Comments
Comment #1
sachbearbeiter commentedsub
Comment #2
Solarius commentedI have exactly the same need, make a sql query on another bdd and see the result but with no import.
Can i do that with feeds sql ?
Comment #3
ibrahim baykal commentedsub
Comment #4
luthien commentedTry out this module, it works for what you need: http://drupal.org/project/views_xml_backend