Connectivity & Data Prep

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