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.)
Requirements:
A database system which is ODBC/OLEDB compliant and which also supports ADOX. Microsoft Access and Microsoft SQL Server are ideal.
Limitations:
30-day trial. No other limitations.
Comments not found