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
Best answer by Christian Hauggaard
View original
+7
Hi
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
+5
Hi
+5
Please 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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
