Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

TMG Reporter's Data Storage

Ricardo Feb 11, 2014 04:30PM PST

Is it possible to keep TMG Reporter data storage in database of SQL Server?

1 Community Answers

Best Answer
Fastvue Feb 11, 2014 05:15PM PST

Hey Ricardo,

Thanks for getting in touch.

TMG Reporter's data store is a flat file structure that is optimized for our reporting processes. It is not possible to back the data store onto SQL Server. We did investigate this architecture, but it introduced too many unacceptable performance overheads.

I assume you would like to run your own SQL queries on the data? Is there any specific query you would like to perform that TMG Reporter cannot provide?

Forefront TMG can log to a remote SQL Server that you can then query directly. You can also monitor the SQL database with TMG Reporter. Would this suit your purpose?

For information on remote SQL logging, see http://www.fastvue.co/tmgreporter/blog/forefront-tmg-enterprise-logging-with-remote-sql-server

For information on monitoring the SQL Database with TMG Reporter:
http://www.fastvue.co/tmgreporter/blog/reporting-on-forefront-tmgs-remote-sql-database

I hope this helps. Let me know how you go.

Cheers!
Scott


Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)

Contact Us

  • Post a Public Question
  • Email Us
  • Chat with us

    Call Us @ 888.885.6711
support@fastvue.co
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete?b_id=1646