Search and data in seperate database

[daldred]

I have a site which I'd like to convert to CMSMS, but with data in certain areas pulled in using User Defined Tags to draw data from a relational database (it's for a theatre group; the pages in question are about the members of the group, and past/current/forthcoming performances: a page for a group member also lists all their roles in various productions, pulls in pictures etc).

The problem is that, from reading other questions on the forums, it seems that site search cannot be configured to pull in non-CMSMS tables.

What I have in mind is adding something to the code for the data side which. on update of any data, writes content directly to CMSMS content blocks on pages which simply list all plays / group members with links to the data-generated pages about them.   In this way the content will, I believe, become searchable. 

I believe I need to write directly to the cms_content_props table, and overwrite the content field (having first created the pages with some data in the content blocks, then identified the content_id by inspecting this table).  I can also add metadata to the metadata field of the page in the content table.

Can anyone see any reason why this wouldn't work?