## JSON connections

A JSON connection contains relational data which is transformed from a JSON data source.

JReport 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. The tables can then be added to the current connection from the transformed relational tables.

This section describes the following tasks:

- Extract metadata from JSON data
- Transforming a JSON schema to a relational schema
- Setting up a JSON connection
- Managing tables in a JSON connection