Forum Discussion

melanie_w's avatar
melanie_w
Data Storage
02-10-2022

Sisense V1 to V2 Conversion - Custom Data

We are transitioning from version 7.1.3.15004 to version L2021.12.0.170 but are running into an issue with some historical custom data that was uploaded into Sisense. This was done at least two years...
dashboards & reporting
HamzaJ's avatar
HamzaJ
Data Integration
02-11-2022

Hi,

I dont know exactly what you mean with V1 and V2. If you want to export data from a cube directly, then you could try to use the sql-runner:

It's admin-only:

https://domain/app/sqleditor#/datasource=name_cube/

you can write a query which will give you an result that you can export.

Hope this helps

melanie_w's avatar
melanie_w
Data Storage
02-11-2022

HamzaJ Apologies, V1 to us internally is version 7.1.3.15004 while V2 is version L2021.12.0.170. I updated the post. 

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    02-12-2022

    melanie_w 

    I cannot find any docs regarding v7.1.3. However I do think the sqleditor should work. Although back then I think it was named sqlrunner instead of sqleditor. Unfortunately I cannot find any docs from back then. You could also try to send an API Get-request:

    /api/datasources/<datasource>/sql?query={query}

     

    Hope this helps. Otherwise perhaps someone from Sisense can help you out