Solved

qlik sense and timextender

  • 3 April 2024
  • 2 replies
  • 28 views

Hi all,

We have a prospect who uses TimeXtender for data management, with Qlik Sense providing the Visualizations. They have purchased TimeXtender in a bundle with Qlik Sense and NPrinting and Checkpro which is and android App.

Data Structure is created in TimeXtender along with calculated fields and filters and aggregated tables and it is taken from there into Qlik Sense via MSSQL. TimeXtender also loads the data.

Data is coming in to Qlik Sense from Excel.

The company would like to get rid of TimeXtender and use Qlik Sense exclusively by utilising everything as is, but without TimeXtender. They are not familiar with the SQL scripts in TimeXtender because it is not visible for them. In TimeXtender they just had to drag and drop all the tables to create the data structure, but with Qlik Sense they will have to rewrite all the scripts manually to recreate the same structure.

My question is does anybody have any similar experience or any idea? To migrate everything from one system into another without knowing the code but not having to rewrite it and still being able to recreate the same business logic? I know its a bit of a stretch to ask this here, but I haven’t got any other ideas so far.

Thank you in advance,

 Gábor

icon

Best answer by rory.smith 3 April 2024, 12:22

View original

2 replies

Userlevel 5
Badge +7

Hi @Bakos Gábor ,

 

I don't know of any convertors or cross-compilers between T-SQL and Qlik's BNF script. I don't think it would make sense to make something like that as Qlik's engine is a completely different thing compared to a relational DBMS like SQL Server - there is no market.

In theory you could build a grammar for T-SQL and Qlik script and attempt to convert between them using something like ANTLR, but it would require an enormous effort and scarce expertise for little gain.

Hi @rory.smith,

 

thank you for the quick response. Yeah, I thought so, and we tried to explain this to our contact, but to no avail so far. We must go around this then, and see what happens.

 

Best wishes

Reply