topic Can QlikView report on SQL Server data? in QlikView

Can QlikView report on SQL Server data?

Thu, 09 Jan 2014 16:18:05 GMT

Hello,

I'm new to ClickView and my company is considering it as BI tool. Does anyone know if this tool can work with SQL Server 2008? If so is the process of integrating with SQL is easy or complicated?

Any response is appreciate.

Thanks,

Ash.

Re: Can QlikView report on SQL Server data?

Thu, 09 Jan 2014 17:25:27 GMT

Ash,

Qlikview will connect to a SQL database instance via ODBC or OLEDB connection. It can extract data from SQL using a SQL script written in the Qlikview application itself or by connecting to a table, view or stored procedure predefined on the sql server.

Hope this helps.

Re: Can QlikView report on SQL Server data?

Thu, 09 Jan 2014 19:05:05 GMT

Yes,

I t works with Sql server, we get the data and do reports .Not only sql server it works with oracle like different data sources like xml and from active directory,Excel like various Data sources

using ODBC and OLEDB

Regrds

Mahesh Thalluri