Web Log to SQL Exporter

Parse and write or append Apache web log files to SQL database table.
Download

Web Log to SQL Exporter Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Price:
  • Free to try
  • Publisher Name:
  • By Data Perceptions
  • Operating Systems:
  • Windows 2003, Windows 8, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP
  • Additional Requirements:
  • A database system which is ODBC/OLEDB compliant and which also supports ADOX. Microsoft Access and Microsoft SQL Server are ideal.
  • Total Downloads:
  • 28

Web Log to SQL Exporter Tags


Web Log to SQL Exporter Description

Our Web Log To SQL Exporter does much more than simplifying the parsing and transfer your Apache web log file to a database table. It adds value to the data in the table by adding fields for: Country (from IP); Host name (via reverse DNS lookup); Filename and extension pulled out of request for easy querying; Flexible rules to identify spider and robot entries; Flexible rules for extracting search terms; Individual 'Sessions' given unique identifiers for easy analysis; Time on page calculated from 'Sessions' ID data; Date/time of log entry added as a database date/time field for easy day/week/month etc. SQL grouping; Allows you to optionally specify file extensions to exclude from the log file (e.g. images) which would just be 'noise' in the target database table. Once the data is in a SQL database such as Microsoft Access or Microsoft SQL Server you can use SQL to extract all the value you like from it (rather than being limited to the inflexible, largely fixed reports available through alternate solutions.)


Web Log to SQL Exporter Related Software

About SoftwareSea