View Source

is an online sales CRM software that manages your sales, marketing, and support in one CRM platform. For more information, see https://www.zoho.com/in/crm/.

Limitations and Requirements

OAuth 2.0 authentication is required.
- You have to create an OAuth 2.0 client in and register the created OAuth 2.0 client in the .
- For more information, see OAuth 2.0 for Zoho CRM.
- You cannot create OAuth 2.0 connections via API.
If your account resides in a different location, then the domain should be changed accordingly (.eu, .in, .com, .au, and so on).
You cannot fetch data from Activities and Tasks tables. This is a known issue with the driver.

Create Connection

via

When you create the connection, please review the following properties and specify them accordingly:

Connection Property Description

APIDomain The region of the URL of the API domain. For example, https://www.zohoapis.in. The APIDomain may vary based on the region.

AccountsServer

The region of the full Account Server URL.For example, https://accounts.zoho.in/. The AccountsServer may vary based on the region.

Connect String options

The following default value sets the connection timeout in seconds:

Timeout=0;

Setting this value to 0 disables timeouts.

OAuth 2.0

The client is displayed.

NOTE: After you have specified the connection to use OAuth 2.0, click Authenticate to validate the connection with the target datastore . If you have modified the connection, click Re-authenticate to validate the new connection definition. You must re-authenticate if you receive an expired code message. This step is required. For more information, see Enable OAuth 2.0 Authentication.

For more information, see OAuth 2.0 for Zoho CRM.

Default Column Data Type Inference Leave this value as Enabled.

For more information, see the driver documentation https://cdn.cdata.com/help/CZG/jdbc/default.htm.

Data Type Conversions

For more information, see the driver documentation https://cdn.cdata.com/help/CZG/jdbc/default.htm.