Good afternoon,
We have a dsa table with data in one of it's columns in json structure. Can I translate this with a new data source or are there any other solutions?
Thanks for contributing ideas.
Kind regards, Heleen
Solved
JSON in dsa table
Best answer by Christian Hauggaard
Please also see the below post which might be relevant:
+7Hi
if the structure of the json inside the column is the same for all records and you are loading this through CData you can easily decompose the JSON. If the structure is more varied it will involve .rsd scripting.
If the data does not come in through CData but is simply JSON inside SQL, you can use SQL Server's JSON data capabilities: https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver16
+5Hi
+5Please also see the below post which might be relevant:
Dear Christian Hauggaard, I indeed saw your post in the community. Ultimately this will be the best solution. Thanks for your responses.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
