Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik sense enterprise : questions about database connectivity

Hi,

My company is looking forward to get a license for enterprise version of qlik sense ,, and I'm using qlik sense desktop to build a prototype.

I want to ask some questions ,, we are integrating qlik sense to our multi tenancy app. we will take the approach of creating an app per tenant ,, but the question is

1 - would it be better to create a database per tenant ?? or should we create one database and each app access part of it using a key like tenant id ?

2 - what would happen if the database scheme changed after a while of using qlik sense ?

3 - what is the best way to connect to SOLR ? and how can we sync data between sql data base and SOLR though an itemId ??

Thanks in advance

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Qlik sense enterprise : questions about database connectivity

Hi, Ahmed.

1. In my opinion, should we create one database and each app access part of it using a key like tenant ID.

2. You will need to re-load the data with the changes and you can not change part of the diagrams.

3. Unfortunately, I was not working directly with a SOLR, it is better to wait for the expert answer. In any case it is necessary to compare the cost of data exchange between SOLR and Qlik Sense through the discharge in the file and a direct connection to one.

Regards

A. Kh.

5 Replies
ahaahaaha
Honored Contributor

Re: Qlik sense enterprise : questions about database connectivity

Hi, Ahmed.

1. In my opinion, should we create one database and each app access part of it using a key like tenant ID.

2. You will need to re-load the data with the changes and you can not change part of the diagrams.

3. Unfortunately, I was not working directly with a SOLR, it is better to wait for the expert answer. In any case it is necessary to compare the cost of data exchange between SOLR and Qlik Sense through the discharge in the file and a direct connection to one.

Regards

A. Kh.

kkkumar82
Valued Contributor III

Re: Qlik sense enterprise : questions about database connectivity

If I understand correctly you are trying to build a mash up project using Qliksense by integrating charts into a web application.

I have a similar experience with Qlikview mashups where we used to have multiple customers with different customizations and data, what we have done is we use MYSQL as database and we had multiple databases for each customer.

As per your doubt you can even have a single database instance for all of them by have a ID to seperate the rows but if the structure keeps changing when a new customer comes it would be challenging.

We had a some experiences where customers used to come with different tables , columns and these customizations

are only for that , so we thought of having different databases for individual customers.

Hope it helps you.


Regards

Kiran kumar

Not applicable

Re: Qlik sense enterprise : questions about database connectivity

Thanks for your reply ,, I'll take that as an answer as I've managed to the SOLR thing through the rest connector

but can you elaborate more why should we go with the single database option ??

Not applicable

Re: Qlik sense enterprise : questions about database connectivity

Thanks for your help

ahaahaaha
Honored Contributor

Re: Qlik sense enterprise : questions about database connectivity

When a single database, you can always obtain data samples on individual elements and see the whole picture. If you have multiple databases you will need them again combine to produce a consolidated analysis.

The only obstacle to a single database option only be too complex data structure in the binding table.