Lucanet - QlikSense Connector

[amineennar]

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 

[amineennar]

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]

Hi,

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

[amineennar]

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)

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]

Hi 👋 

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

[SamKng]

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]

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]

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]

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.

Reagrds.