Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Simple information

Please can i have any informations of Qlikview ? What's a platform architecture needed ? Characteristic of Workstation, ram, disk and other What's a price ? what's the political licensing ? What are the possible connections, is possible to connenct SQL SERVER (and which version ?) is possible to connect at OLAP Cube in Analysis Services ? And is possible to have quantification of stress test (How many row elaborated ?)

I could testing the connection to SQL Analysis Services with downloaded version ?

Thanks

Tags (2)
6 Replies
hector
Valued Contributor

Simple information

Hi, answering your questions


frankmed wrote:
Please can i have any informations of Qlikview ?


Sure, check this community, www.qliktech.com or get in touch with your local distributor/partner


frankmed wrote:
What's a platform architecture needed ? Characteristic of Workstation, ram, disk and other


To develop, Windows based machines (XP, Vista, Seven, Server 2003, Server 2008 etc)
To deploy, Windows based server (2003, 2008 etc)
To view/analyze, Windows based machines just if you want to use the ActiveX for IE, if you don't, the ajax client works in any platform/browser

The characteristic of the PC, depends about the size of your models, number of records etc....


frankmed wrote:
What's a price ? what's the political licensing ?


Ask for commercial support, but a small server with 10 users (CALS), it's around 10.000 USD


frankmed wrote:
What are the possible connections, is possible to connenct SQL SERVER (and which version ?) is possible to connect at OLAP Cube in Analysis Services ? And is possible to have quantification of stress test (How many row elaborated ?)


You can connect to any database if you have the right driver (by ODBC or OLEDB), but also can retrieve information from XLS, CSV, XML, HTML etc etc... any file with a defined structure


frankmed wrote:
I could testing the connection to SQL Analysis Services with downloaded version ?


Yes, Personal Edition (P.E) only has restrictions about open QlikView Files (qvw), from other P.E or a licensed user, and some other functionalities like import layout

Check the online courses (there are some free ones), to start with the software, that will help you a lot.

Hope this helps

Rgds

Not applicable

Simple information

Thanks for all, perhaps Qlikview gain a new fans if i to be able to configure in the downloaded version the connection to MSSQL OLAP Cube.

And sorry, if i search server in the possibilities "OPEN FROM SERVER" how do configuring a driver MSOLAP ?

Another thank

hector
Valued Contributor

Simple information

Hi

The steps are:

  • Create a black document (New File, save as..)
  • Go to the script editor (Ctrl + E)
  • At the bottom left you will se a radio option, ODBC/OLEDB choose one option
  • Press the Connect button and choose the source/driver for your connection
  • Then, pressing the Select button, the wizard will appear and you can select the tables/views (this can be achieved also typing the query by yourself)
  • Press the Reload button or Ctrl + R
  • Then, the records will be retrieved and you can start make the objects

Hope this helps

Rgds

Not applicable

Simple information

Thanks so much, now is simple.

Best Regard

suniljain
Honored Contributor

Simple information

you can also connect to SAP R/3,SAP BW,Salesforce system.

Not applicable

Simple information

Hi Hector,

I am trying exactly the same thing loading a MSOLAP into QlikView. The test connection is success and able to select data... but I am not able to retrieve the records. I get "script error".

My script as follows:

OLEDB CONNECT TO [Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Altius MIS Cube;Data Source=mis;Location=aclappserve1];

SQL SELECT *
FROM [Altius MIS Cube].[$Date];

When I do reload I get the Script Error.

Kindly guide me to sort this out. I am using QlikView 10 (32 bit version) and drivers with same versions