Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
Have you managed to connect lucanet with qliksense? If, yes please let me know the process.
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
Hi 👋
Thanks for your response. Currently we are exporting data manually into csv files then into qlik.
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...
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
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 🙂