Forum Discussion

interservshane's avatar
interservshane
Data Storage
11-01-2023
Solved

Importing JSON string from SQL Server datatabase

We have data fields in our SQL Server database that are in JSON format that we would like to bring into Sisense and report on some of the fields.  Is Sisense able to bring in the JSON formatted data ...
Developers
  • Liliia_DevX's avatar
    Liliia_DevX
    11-06-2023

    Hi,

    The easiest way to parse the JSON data stored within a column is to parse it on the SQL database side. There are native SQL functions that are capable of parsing json objects and flattening them into individual fields. Alternatively, you can try the import sql query editor feature in Sisense but it might impact the ElastiCube build time. Both approaches are described in the community article "Flattening JSON Objects in SQL Server".

    If you like to connect to JSON files as a datasource, it also might be possible to achieve that with the help of JDBC driver. Please reach out to our Support Team to get more details on this option. 

    Hope it helps!

    Regards, Lily

Liliia_DevX's avatar
Liliia_DevX
Sisense Employee
11-06-2023

Hi,

The easiest way to parse the JSON data stored within a column is to parse it on the SQL database side. There are native SQL functions that are capable of parsing json objects and flattening them into individual fields. Alternatively, you can try the import sql query editor feature in Sisense but it might impact the ElastiCube build time. Both approaches are described in the community article "Flattening JSON Objects in SQL Server".

If you like to connect to JSON files as a datasource, it also might be possible to achieve that with the help of JDBC driver. Please reach out to our Support Team to get more details on this option. 

Hope it helps!

Regards, Lily