Hi,

I love the data module and the possibilities it opens up. I have a question regarding adopting tables. It looks like data can only retrieve information from the default database. I added a connection to a second database that is populated by another instance of Drupal. When I try to adopt a table in the secondary database, these don't show up. Would it be possible to evaluate other database connections, prefix all tables with the connection and allow adopting from secondary database?

What I discovered as well is that data is able to adopt views. What I ended up doing was create a database user with access to both databases (one read-only). Then I created a view of the table in the secondary database in my primary database which made it accessible by data module, i.e. I can now directly build a view against a data table that is maintained by another Drupal site. Pretty awesome!

Jens

Comments

jelo’s picture

jelo commented

Actually, it doesn`t work because my view does not have a primary key. Due to this no views can be created against it. Too bad. So the feature to be able to adopt views from any of the configured databases in the Drupal settings file (not only the default one) would be great.

jelo’s picture

jelo commented
Status: Active » Closed (duplicate)

Duplicate of https://www.drupal.org/node/864184