topic Re: Lucanet - QlikSense Connector in Connectivity & Data Prep

Lucanet - QlikSense Connector

amineennar — Thu, 23 Dec 2021 14:44:45 GMT

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

Re: Lucanet - QlikSense Connector

amineennar — Thu, 01 Jul 2021 15:40:37 GMT

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.

Re: Lucanet - QlikSense Connector

suneethagandham86 — Mon, 23 May 2022 19:19:31 GMT

Hi,

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

Re: Lucanet - QlikSense Connector

amineennar — Tue, 24 May 2022 08:46:13 GMT

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

Re: Lucanet - QlikSense Connector

suneethagandham86 — Tue, 21 Jun 2022 11:39:38 GMT

Hi 👋

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

Re: Lucanet - QlikSense Connector

SamKng — Tue, 05 Mar 2024 20:15:56 GMT

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...

Re: Lucanet - QlikSense Connector

Enno86 — Thu, 06 Jun 2024 08:30:49 GMT

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

Re: Lucanet - QlikSense Connector

SamKng — Thu, 06 Jun 2024 08:35:33 GMT

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 🙂

Re: Lucanet - QlikSense Connector

amineennar — Mon, 10 Jun 2024 08:19:54 GMT

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.