Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
amineennar
Contributor II
Contributor II

Lucanet - QlikSense Connector

Dear All,

I need  to connect Lucanet cubes with Qliksense.  Is there any dedicated connector to do that  ?   Or I have to connect directly to the database  ?

Thank ou for your help 

Labels (1)
8 Replies
amineennar
Contributor II
Contributor II
Author

There is no a dedicated connector to QlikSense.

But we can use an app to export all Lucanet Data from a "financial warehouse" to a database like SQL Server. And then build our QS dashboard.

suneethagandham86
Contributor
Contributor

Hi,

Have you managed to connect lucanet with qliksense? If, yes please let me know the process.

amineennar
Contributor II
Contributor II
Author

Hello,

Yes there is two ways to do that:

1- Bought a dedicated connector (#4042 - Exporting LucaNet Values for BI Tools ) from Lucanet : It allows you to extract a ready datamodel from Lucanet to a sql database or other DB. Then, extract values frol SQL DB to QlikSense.  ( So it's a paid solution)

amineennar_0-1653381864943.png

 

2- The second solution is more difficult : use the Lucanrt excel Addin functions to get values from Lucanet. Then import data from excel to QlikSense. This way could take time to implement, automate and maintain ( it's a free solution)

 

Don't hesitate if further information is needed.

BR.

Amine

suneethagandham86
Contributor
Contributor

Hi 👋 

Thanks for your response. Currently we are exporting data manually into csv files then into qlik.

SamKng
Contributor II
Contributor II

I'm not sure whether it's still relevant, but we've managed to realize another free approach:

- Established a connection over OLEDB-connector: OLEDB CONNECT TO [Provider=MSOLAP;Data Source=https://xxxxxxxxxxxxx/xmla/database=xxx;Initial Catalog=xxxxxxxxxx;]

- Fetch the data directly over the data load editor (example): 

Load
"[BSAccount].[Level_00].[MEMBER_CAPTION]" as %Account,
"[Measures].[Measures.Sorter]" as AccountSorter;
SQL
WITH
MEMBER Measures.Sorter as [BSAccount].CurrentMember.Properties("Sorter")
SELECT
{Measures.Sorter}
ON COLUMNS,
[BSAccount].[Level_00]
ON ROWS
FROM [BalanceSheet];

We're now fighting with implementing something similar out of QlikCloud...

 

Enno86
Contributor III
Contributor III

Hi @SamKng, did you manage to retrieve the data you were looking for yet? Is it suitable for what you were expecting?

Hi @amineennar , we are currently investigation option 1 (#4042), but i haven't yet understood what needs to be done in qlik to get the visualizations. Did you get the overall ETL result including an application, or do you "just" use the SQL db to build an qlik app from scratch? Is it then sufficient to use this data provided by the lucanet SQL only, or did you still enrich the data with other information from your ERP?

 

Looking forward to your inputs 🙂

Thanks

 

Hi @amineennar, we are currently investigating option 1 (#4042). Could you pls explain what to get from this solution? Th

SamKng
Contributor II
Contributor II

Hi Enno,

We have also switched to option 1 under Qlik Cloud --> is working fine. 

The visualizations you have to build yourself in Qlik. The Lucanet app just pushes the data into an SQL database (according to the structure in the screenshot above) from where you can then pull the data out of Qlik Cloud (we do that with Qlik DataTransfer, since our Lucanet installation is still on-prem). 

Works quite well 🙂

 

amineennar
Contributor II
Contributor II
Author

Hi @Enno86 

I confirm what  @SamKng  said, you need to build your own flow. The data coming from Lucanet is stored in a DB ( sql server, Oracle  ... ). Once done you will pull data from the DB to Qlik.

Attached a graph which explains the flow very well.

Lucanet_BI.png

Reagrds.