AnsweredAssumed Answered

JSON columns in ArcSDE (Oracle)

Question asked by nicole79 on Sep 2, 2019
Latest reply on Sep 3, 2019 by nicole79

Are there any recommendations about using JSON columns in ArcSDE  (Oracle)? 


In Oracle Database, JSON data is stored using the common SQL data types VARCHAR2, CLOB, and BLOB.

With the check constraint is json on this column you tell Oracle that you will store json.


I guess that you can create a featureclass in Oracle with python, and add this check constraint afterwards. Would that work?


I am aware that there are lots of issues with storing and querying json in relational databases as you can read here:

Why JSON fields shouldn’t be used in relational databases – Thomas Cerqueus 


But are there any issues concerning ArcSDE which would make ArcSDE slower or reducing functionality? 


bye, Nicole