I've followed the instructions here: http://telligent.com/support/analytics/w/documentation/configure-the-web-analytics-task-to-write-data-to-a-separate-database.aspx
And now have my Extended Analytics data being logged to the new database.....however, the default TaskStrings.config pulls in cs_Users which does not get created by the ExtendedAnalytics.sql script and is not populated by the CommunityServer.ExtendedAnalytics.dll module. One solution is to update the TaskString to either remove the outer join referencing the table or to rework it such that it pulls the data from two DBs and merges it on the Reporting side.
Layne
-----Error Message in log file-----
Task: WebAnalyticsTask @ 2010-01-13 10:23:56.867327 : Task Started.
2010-01-13 10:23:56.867327 - WebAnalyticsTask - TaskBase.Execute() - Begin
2010-01-13 10:56.867327 - WebAnalyticsTask - ReadConfig(node) - Begin
2010-01-13 10:56.882953 - WebAnalyticsTask - ReadConfig(node) - End
--- ---
TRANSFER FROM(DB): CommunityWebAnalytics - TO(DB): Analytics_SIT
--- ---
Error retrieving Web Analytics data from Source Database using connection string server=[[omitted]];Trusted_Connection=yes;database=CommunityWebAnalytics;Connection Timeout=300 @ 2010-01-13 10:56.914204
Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'cs_Users'.
Task: WebAnalyticsTask @ 2010-01-13 10:23:56.914204 : Exited on error.
2010-01-13 10:23:56.914204 - WebAnalyticsTask - TaskBase.Execute() - End
----TaskString----
<Task name="WebAnalyticsTask" ImportIdField="">
<Queries>
<add Query="
SELECT top @MaxItemCount f.UserId, f.SessionId, ISNULL(u.UserId, 0) AS [CsUserId], f.RequestedUrl, f.ReferringUrl, f.IPAddress,
f.UserAgent, f.IfModifiedSince, f.PageTitle, f.RequestDt, f.ApplicationType, f.GroupId, f.SectionId, f.ThreadId, f.WikiId, f.PageId, f.PostId
FROM cs_WebAnalytics f LEFT OUTER JOIN cs_Users u ON f.UserId = u.MembershipId WHERE RequestDt > @ImportDt ORDER BY RequestDt ASC" />
</Queries>
<ConnectionStringNames>
<add Source="CommunityWebAnalytics" Destination="[[omitted]]" SiteSchema="[[omitted]]" />
</ConnectionStringNames>
</Task>