I have a custom table that I'd like to expose to administrators so that they can perform simple searches on the table data. I know I can create a series of custom views handlers for each field, but is there is a way to expose and search through the custom table data without custom coding? I expect there is a contrib module out there that solves this problem, but my Googling has come up dry.
Apparently Views Custom Table does that:
View custom table module provide you functionality to integrate your custom table data to views, and access all it's column in views. This module use hook_view_data to add custom tables in views. this module provides you following functionalities.
- Auto integrate custom table data to views
- Auto map mysql data types with drual data types
- Extend relationship of custom table data to drupal entities