I have a pretty detailed relational database that I would like Drupal to communicate with (Read Only). Now, I know that I can create custom modules to output the data but I am not sure I will be leveraging Drupal's benefits using in that fashion (it seems like a hack). I do not plan on moving the data to Drupal either (too large in size and also more than 80 tables).
Is there a way that I could use views to get the data out from my external database without interfering with the Drupal core? I am sure that Drupal developers run into this issue many times, I would like to have a pointer as far as where to look. Is that possible? has anyone ever done this?
I have already used Google in an attempt to find a solution. I even tried the entity module, entity api, data module a few other API and modules without success.
Just need a workflow/pointer or simply a successful website that is using Drupal in that fashion.
I am using Drupal 7 and I will be willing to go to Drupal 8.