question

Andrew McLintock avatar image
Andrew McLintock asked

How do I track what data is being pulled from a database object (View or Table) by an external ODBC connection?

I hold n years of data in Operational Data Stores. I need to be able to monitor the date range parameters applied to the SELECTion of this data by the enquiring framework (Cognos8) as it interrogates my MSSQL2005 databases. This will allow me to dynamically go and pull additional historical data if required (i.e. if the SELECT is for a period beyond three years historically I can load the Delta).

ssisssrsdatabaseview
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.