使用SSIS将WebTrends数据导入SQL Server

时间:2022-10-28 23:55:25

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

我需要将所有webtrends数据导入到我的本地sql server数据库。最重要的是,我需要建立报告。

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

我是Webtrends的新手,所以有人可以建议我如何将WebTrends数据导入我的本地数据库服务器。

1 个解决方案

#1


Just for context - I work at Webtrends.

仅供上下文使用 - 我在Webtrends工作。

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

我的第一个问题是您使用的是网站软件版本还是按需SaaS版本?它还取决于哪个版本。

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.

如果您使用的是最新版本的软件,那么从Webtrends Analytics产品数据存储中获取内容的最佳方法是使用可用于该产品的ODBC连接器。您可以从Web UI下载它,只需单击即可安装。我可以提供更多文档,只需发送电子邮件给我,我就会向您发送实际的文档文件。

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

另一种方法,目前处于测试阶段,仅供OnDemand客户使用,即使用我们创建的Web服务(基于REST)。查看以下文档:http://product.webtrends.com/dxapi/index.html

#1


Just for context - I work at Webtrends.

仅供上下文使用 - 我在Webtrends工作。

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

我的第一个问题是您使用的是网站软件版本还是按需SaaS版本?它还取决于哪个版本。

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.

如果您使用的是最新版本的软件,那么从Webtrends Analytics产品数据存储中获取内容的最佳方法是使用可用于该产品的ODBC连接器。您可以从Web UI下载它,只需单击即可安装。我可以提供更多文档,只需发送电子邮件给我,我就会向您发送实际的文档文件。

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

另一种方法,目前处于测试阶段,仅供OnDemand客户使用,即使用我们创建的Web服务(基于REST)。查看以下文档:http://product.webtrends.com/dxapi/index.html