How to Create APG / Watch4Net Reports that Utilize Multiple Data Sources?

Hello, I hope all is well...

     I am trying to understand how to create mash-up type reports in APG that utilize data from multiple data sources "multiple databases".  Specifically, how to create a report that utilizes data from both a EMC SMARTS and SQL Collector Data Feed.  The data in this example will be focused on server information.

We have a two server setup with a frontend and backend running APG v6.2 u4 on a Widows environment.  We have a data feed to APG from EMC SMARTS that sends performance / "time series" metrics on the servers we monitor in our environment.  Then we have another external Microsoft SQL databases that contains other server attribute information that the EMC SMARTS feed does not have.  We call this external database the CMDB and it contains a server attribute we need call "server owner".

Our goal is to understand how we can produce a report that pulls attributes from multiple data sources by utilizing a unique primary key.  The primary key we will be using is the device name "server name".

We have the SQL collector configured on the frontend server and the EMC SMARTS collector is configured on the backend server.  We would like to add certain attributes from the external CMDB database to the incoming data from the EMC SMARTS collector.  This would allow us to create server reports by server owner.

This sounds like a Property-Tagging-Filter needs to be used on the EMC SMARTS data feed but that has to read from a .csv file.  How do you tag incoming data with already collected data from the SQL Collector?

Thank you very much for any help that can be provided.

Stuart