Importing data from a FunnelWeb database into SQL Server or any other RDBMS
FunnelWeb utilises a proprietary format for its databases. The data within a FunnelWeb database is not able to be imported directly into SQL Server or any other RDBMS (Relational Database Management System). There is another solution, however, depending on your requirements.
A FunnelWeb database stores the aggregated results of FunnelWeb's processing. Log data is pre-processed, filtered and accumulated before being stored within a FunnelWeb database. Individual log entries are not preserved. Another way of thinking of a FunnelWeb database is of a "binary report" where there is a direct correspondence between the data you see within a FunnelWeb report and the data stored within a FunnelWeb database. Given that the database is of a proprietary format, here are a couple of solutions for importing into SQL Server or other any other RDBMS:
1) If you want to export what is essentially aggregated report data to SQL Server then reprocess your database file, as if it was a normal log file, with Settings>Report>Output>Format set to "Comma Delimited". You may then import the resulting comma delimited data into the database of your choice. Please note that you may have to manually massage the comma delimited data a little before doing so.2) If you want to export raw log data (thus preserving individual log entries) to SQL Server then you can utilise FunnelWeb's W3C conversion feature. Simply select the log(s) you wish to export and then click on the File menu command: "Convert log file to W3C Format". FunnelWeb will then export the data into a file called index.log that resides within your current report output folder as specified by Settings>Report>Output>Location. This file will contain the original log data in a tab delimited format which may be imported directly into an RDBMS.
In version 5 of FunnelWeb, a new style of Extended database will be introduced that preserves individual log entries. You will be able to re-process an Extended Database with different Settings. With Version 4.x FunnelWeb databases, there can be problems with altering settings when re-processing or adding new logs. For further information on these issues, check the related article here
We at Quest would be interested to hear about any specific requirements with regard to exporting FunnelWeb data to an RDBMS. Please let us know specifically what you wish to do with the exported data and how you wish to do it. This will help us formalise better solutions for you in future versions of FunnelWeb.
Zoltan Toth
Funnel Web Analyzer
This site looks best using Safari or FireFox.
