Sisense V1 to V2 Conversion - Custom Data

[melanie_w]

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. 

[HamzaJ]

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]

@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]

@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