I wonder what is the best way to allow the Views module to access external tables not in Drupal?

I tried the Data module, but it doesn't allow for a datetime datatype.


1 Answer 1


The data module is a good start.

You can skip the data module and create your own views type with hook_views_data()
Angie has an example here.

Date times can be tricky, if you post another question with your specific problem with date times there may be a solution.

You don't specify if the DB is the same. You would need to define a second database in your settings.php if you need to connect to a different DB.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.