Summary
These are almost identical products.
Question
The BSM connector is a version of SiteScope and data about BSM connector is stored in same BSM(OMi) tables as SiteScope.
Answer
The BSM Connector SESSION Data will be stored in the BSM Management Database SESSIONS table ( which is the same as SiteScope)
The HOST information will be stored in the same tables as SiteScope :
HOSTS
hosts_HOST_TYPES,
and
hosts_HOST_TYPES_PROP tables.
The BSM/OMI user interface about BSM connector will be stored in the BSM Management Database :
SESSION_SITESCOPE_PROPS ( again, the same as SiteScope uses) table