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 ago and the original files were not documented/saved outside of Sisense. Version 7.1.3.15004 does not have an export cube option, even for the admin. Anyone have any thoughts on how to get this custom data out of version 7.1.3.15004 to import into version L2021.12.0.170. 

dashboards & reporting

3 Replies

Replies have been turned off for this discussion
  • 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