Forum

General discussion on using the Kognitio Analytical Platform.
Contributor
Offline
User avatar
Posts: 22
Joined: Tue Dec 10, 2013 6:59 am

Documents

by vishwasjione » Wed Dec 18, 2013 12:05 pm

Hi,

Can somebody provide me kognitio installation instructions on Redhat linux and also how can I connect to Kognitio using microstrategy?

Thanks
Vishwas
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Documents

by markc » Wed Dec 18, 2013 12:15 pm

Vishwas,

http://www.kognitio.com/forums/viewtopic.php?f=4&t=26 has a Kognitio installation guide attached, and the installation should be the same whether on RHEL/SLES/CentOS/...

Once you have this setup, you can connect using MSTR as you would with other databases - MSTR has specific Kognitio support, so make sure you select Kognitio as the database to get best performance. When setting up the DSN to be used by Kognitio, use one or more Kognitio server addresses with the relevant server port (6550 by default).

Let us know if you have any further questions.

Regards,
Mark.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 22
Joined: Tue Dec 10, 2013 6:59 am

Re: Documents

by vishwasjione » Wed Dec 18, 2013 12:26 pm

Thanks Mark,

For POC purpose I downloaded following -

1) Win 32 Client [ File Name - wx2clients-32-80100s131114 ]
2) Analytical Platform [ File Name - latest_810_sfx.tar ]

Am I good to go ?


Thanks
Vishwas
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Documents

by markc » Wed Dec 18, 2013 1:15 pm

Yes, you can use the win32 client to install on Windows (it includes the Kognitio ODBC driver which tools like MSTR will need to be able to connect). If MSTR is running on Windows, that should be all you need.

Then follow the instructions to install the server software from the untarred sfx file.

Regards,
Mark
Reply with quote Top
Contributor
Offline
User avatar
Posts: 22
Joined: Tue Dec 10, 2013 6:59 am

Re: Documents

by vishwasjione » Wed Dec 18, 2013 6:22 pm

Thanks Mark as always you came for rescue...
just one doubt Kognitio cliams that it does not have any head node concept it is just
linear , if it is so than which machine i should connect to for reporting purpose
?? There must be main gate to enter from ..isnt it?
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Documents

by markc » Wed Dec 18, 2013 7:48 pm

Kognitio really is a massively parallel system, so you can connect to ANY of the nodes in the system - there is no head node. Each node can support up to 58 connections currently, and can forward some number of connections above that to other nodes in the system. Typically people set up DSNs with multiple nodes specified (i.e. IP addresses for several nodes in the system), and the ODBC driver then defaults to choosing the node to connect to at random from that list.

Regards,
Mark.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 22
Joined: Tue Dec 10, 2013 6:59 am

Re: Documents

by vishwasjione » Thu Dec 19, 2013 3:54 am

Thanks Mark,

How can we setup a single DSN pointing to multiple IP's?

Thanks
Vishwas
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Documents

by markc » Thu Dec 19, 2013 7:39 am

When you start up Console and go to connect to a machine, you can define a new DSN (or use the normal interface under Control Panel for setting them up - you should find this by searching for ODBC in Control Panel). When you choose the Kognitio ODBC driver for the new DSN it will show a window with space to enter multiple IP addresses for that DSN.

Regards,
Mark.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 22
Joined: Tue Dec 10, 2013 6:59 am

Re: Documents

by vishwasjione » Thu Jan 02, 2014 1:43 pm

Mark,

Kognitio DSN will appear as system DSN or user DSN in windows control panel?

Thanks
Vishwas
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Documents

by markc » Thu Jan 02, 2014 1:57 pm

Vishwas,

You specify whether it is a User DSN or System DSN when you create it.

If you do this via the Console, you select the File menu, then Connect, then click on the "..." box to the right hand side of the dropdown list of existing DSNs. That starts the ODBC Data Source Administrator, which has separate tabs for User DSN and System DSN. Whichever tab is selected when you add the new DSN, that is the set it will stay in.

Regards,
Mark.
Reply with quote Top
Multiple Poster
Offline
User avatar
Posts: 2
Joined: Wed Jun 14, 2017 10:42 am
Website: https://tekslate.com/
Location: Frisco

Re: Documents

by madisonquinn » Fri Jun 23, 2017 7:57 am

Hello Vishwas

Microstrategy provided connector to connect kognito, here you go

Kognitio has been a partner of Microstrategy for many years with large scale implementations on both sides of the Atlantic. Microstrategy supplies an out-of-the-box database connector for Kognitio Analytical Platform. This connector is configured to exploit the high-concurrency ultra-fast SQL capabilities that enterprise users require when deploying dashboards and complex reports to thousands of users.

Hope this helps, Thanks.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron