cancel
Showing results for 
Search instead for 
Did you mean: 

Importing JSON string from SQL Server datatabase

interservshane
7 - Data Storage
7 - Data Storage

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 and parse it into a table and fields?  If so, how can this be done?  We do have the JDBC Connector drivers installed.  Not sure if we can use this some how and create a customer query using SQL.

1 ACCEPTED SOLUTION

Liliia_DevX
Sisense Team Member
Sisense Team Member

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

Best Regards,
Lily

View solution in original post

1 REPLY 1

Liliia_DevX
Sisense Team Member
Sisense Team Member

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

Best Regards,
Lily
Community Toolbox

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]