Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What software components does Audit DB install and where?

April 26, 2017audit components DB install Software

0

Posted

What software components does Audit DB install and where?

1 Answer

0

Posted

For audit data collection the answer to this is different per database type • For SQL Server, Components called Collection Agents collect data from target SQL Server instances, and transmit the data in proprietary compressed and encrypted format to Repository machines, where the data is made available for reporting and analysis.. These Collection agents may be installed anywhere within your network or on the server being audited. For the collection agent to work properly a small software package must be installed on the SQL Server database server • For Oracle, Components called Collection Agents collect data from target Oracle instances, and transmit the data in proprietary compressed and encrypted format to Repository machines, where the data is made available for reporting and analysis. These Collection agents may be installed anywhere within your network or on the server being audited. The Repository is a set of tables within any instance of SQL Server 2000 or Oracle. A Report Serve