topic Re: How to connect to an SQL Server in QlikView

How to connect to an SQL Server

Wed, 21 Aug 2013 08:06:15 GMT

Hello,

I am currently trying to integrate datas from an SQL source on QV

I proceed as follow:

I went to file > Edit script

I clicked on Database OLE DB and pressed the button "Connect"
I selected the provider "Microsoft OLE DB Provider for Analysis Services 9.0".
I entered the server name and I chose to use Windows security instead of username and password.
I clicked “Test Connection” and the window “connection succeed” appeared.
Then QV generated the connection string into the script window and I chose to use Views.
Finally I clicked OK and QV gave me the script

Here is the problem: when I tried to reload my file I got an error message.

Please see the attached document for more details.

Many thanks,

Helene

Re: How to connect to an SQL Server

Wed, 21 Aug 2013 08:10:15 GMT

You are trying to connect a Analysis server Cube.

You should chose

Microsoft OLE DB Provider for SQL Server

Update:

If you want to connect to a OLAP source as an analysis cube. Your connection should look like this:

OLEDB CONNECT TO [Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorksDW2012Multidimensional-EE;Data Source=localhost;Location=localhost];

and then your load statement could look like this:

LOAD

"[Measures].[Internet Extended Amount]" as [Internet Extended Amount],

"[Customer].[Total Children].[Total Children].[MEMBER_CAPTION]" as [Total Children];

SELECT

{

[Measures].[Internet Extended Amount]

}

DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY

{[Customer].[Total Children].Children}

ON ROWS

FROM [Adventure Works]

;

Re: How to connect to an SQL Server

Or — Wed, 21 Aug 2013 08:11:25 GMT

Hello,

If memory serves, when connecting to an OLAP source, you will need to use an MDX query, not an SQL query.

Re: How to connect to an SQL Server

Emmanuelle__Bustos — Fri, 25 Oct 2013 16:33:43 GMT

Hi orsh_ so can you tell me if there is a way to do the extraction from the cube? So what driver we need to use?

Re: How to connect to an SQL Server

Tue, 29 Oct 2013 08:19:24 GMT

read my post..