Import WebTrends Data to SQL Server Using SSIS

Question

Hi All,

I need to import all the webtrends data to my local sql server database. on top of that i need to build reports.

I am very new to Webtrends, so can some one suggest me how to import the WebTrends data to my local DB Server.

Thanks

Answer 1

Just for context - I work at Webtrends http://developer.webtrends.com/people/adron.hall - so if you need more insight feel free to ping me again via adron.hall at webtrends dot com.

My first questions is are you using the site software version or the ondemand SaaS version? It also depends on which version.

If you're using the latest version of software the best way to go about getting things from the Webtrends Analytics product data store is to use the ODBC connector that is available for the product. This you can download from the web UI and it installs with a single click. I can provide more documentation, just send me an e-mail and I'll send you the actual documentation file on this.

The other method, and this is currently in beta and available only to OnDemand customers is to use the web services (REST based) that we've created. Check out the documentation here: http://product.webtrends.com/dxapi/index.html

Please do send me an e-mail and I'll be sure to get you hooked up with the information you need.

Thx - Adron