Version 26.2.9623

• Add the JSON Connector
• Authenticate to JSON
• Complete Your Connection
• More Information

You can use the JSON connector from the CData Sync application to capture data from JSON and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Add the JSON Connector

To enable Sync to use data from JSON, you first must add the connector, as follows:

1. Open the Connections page of the Sync dashboard.

2. Click Add Connection to open the Select Connectors page.

3. Click the Sources tab and locate the JSON row.

4. Click the Configure Connection icon at the end of that row to open the New Connection page. This action opens the Add Connection dialog box.

   Note: If the Configure Connection icon is not available, click the Download Connector icon to install the JSON connector.

5. Enter a name for your connection in the Add Connection dialog box.

6. Click Add to open the Settings tab for your connector.

For more information about installing new connectors, see Connections.

Authenticate to JSON

After you add the connector, you need to set the required properties.

• URI: Enter the Uniform Resource Identifier (URI) for your JSON resource location.

• Connection Type: Select the type of connection that you want to use.

• Data Model: Select the data model that you want to use for parsing JSON documents and generating the database metadata.

• JSON Path: Enter the JSON path of an array element that defines the separation of rows.

• JSON Format: Select the format of the JSON document. The default value is JSON.

Complete Your Connection

To complete your connection:

1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

2. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and JSON, see JSON Connector for CData Sync.