A JSON connection contains relational data that is transformed from a JSON data source.
Designer can parse JSON data to extract the JSON schema including JSON metadata (JSON objects and the relation between the objects), transform the JSON schema to relational schema and build relational tables during the transformation, namely, map the JSON object classes to tables and table columns, and set up relations between the primary and foreign keys in the tables. You can access the transformed tables in the same way as with JDBC supplied tables.
In the following example, we connect a catalog to a JSON data source via REST Web Service.
Please sign in to leave a comment.