A JSON connection contains relational data which is transformed from a JSON data source.
Designer can parse JSON data to extract the schema including JSON metadata (JSON objects and the relation between the objects), then transform the schema to logic RDBMS tables, namely, map JSON object classes to tables, and the relation to primary/foreign key columns in tables. You can then added the tables to the JSON connection from the transformed relational tables.
In the following example, we will connect to the JSON data via REST web service.
Please sign in to leave a comment.