By Anatsim on

I have a standard relational database with 2 main tables:

  • Clients
  • Products ( related to Clients )

as well as several additional tables:
Countries, Cities etc related to Clients table and Categories related to Products table.

All these tables could be placed in the same MySQL database where D7 tables are located.

I want to edit my tables thru ODBC ( MS Access ) and view/search this information via D7 interface.
Please advice about proper way to do it.

Of course, I could create such ORM database by means of standard D7 features ( different Nodes types instead of main tables, Taxonony to define additional tables and Views to view/search etc ), but in this case database structure is very complicated and I do know how to edit it from MS Access.
May by I should integrate D7 with some ORM framework module like Zend or Symfony ?

Thanks you for attention !

⋅ Categories: Drupal 7.x

Comments

Anatsim’s picture

Anatsim commented

Is module Data Ok for that ?
http://drupal.org/project/data

bojanz’s picture

bojanz commented

My advice would be to forget about Access right away, and learn about the matching Drupal functionality.
There's no way to have those two play nicely, and you will only cause problems (Drupal data is normalized and doesn't like to be poked externally).