Access and update Zoho SalesIQ using standard SQL — powered by the Zoho SalesIQ Connector for the ZappySys API Driver.

Connect from SQL Server, Power BI, Excel, SSIS, and any ODBC-compatible tool. Read and write conversations, visits, operators, departments, and feedback-related data. Target https://salesiq.zoho.com/api/v2/[$Compnay$] (company screen name per the connector UI — placeholder spelling matches the product) and authenticate with OAuth [OAuth] using a Zoho API Console server-based application with redirect URI aligned to the driver (for example https://zappysys.com/oauth).
Part of ZappySys ODBC PowerPack (30+ drivers).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Configure one Zoho SalesIQ DSN once, then reuse it across Power BI, Excel, SQL Server linked servers, and SSIS without hand-written SalesIQ REST calls per app.

Compatibility: Windows ODBC (32/64-bit) | Works with Visual Studio, .NET, BI tools | Data Gateway for SQL Server, JDBC, and non-Windows access

⚡ Key Benefits

SQL over Zoho SalesIQ APIs — Query operators, conversations, departments, feedback, and visits using the actions listed on the connector hub
Zoho API Console OAuth — Server-based client, matching redirect URI, and Generate Token flow documented on the hub page
DSN wizard workflow — Pick Zoho SalesIQ from Popular Connectors or use Search Online when the package is not embedded
Query Builder previews — Generate SQL such as SELECT * FROM Departments and preview rows before you run workloads in downstream tools
Throttle-friendly retries — Configure RetryMode and HTTP status lists (examples include 429) with counts and multiply-wait options from the UI
Gateway-ready sharing — Publish the DSN through ZappySys Data Gateway for JDBC or remote clients without local driver installs

Learn more about Data Gateway

📸 Visual Overview & Setup

1. Pick Zoho SalesIQ Connector 🔍 View Full Size	2. Search Online if Needed Zoho SalesIQ connector page	3. Build & Preview SQL 🔍 View Full Size
4. Load SalesIQ Rows into Excel 🔍 View Full Size	5. Connect from Power BI 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

Works with REST, OData, files, and databases

-- List departments via SQL (Zoho SalesIQ)
SELECT *
FROM Departments

✔ Query APIs like a database
✔ No ETL or custom scripts needed
✔ Works inside SQL Server, Power BI, Excel

🔧 Key Features

Read & query

Select tables such as Departments in Query Builder; use parameters where the UI passes filters to the SalesIQ API for server-side filtering
Keep requests scoped to https://salesiq.zoho.com/api/v2/[$Compnay$] with your company screen name as described in the setup article
Ad-hoc WHERE and LIMIT without Query Builder parameters may run client-side after a full fetch, as noted in the setup article

Write & automation

Use INSERT/UPDATE and dynamic endpoints illustrated under Explore supported Zoho SalesIQ Connector actions on the hub
Issue generic REST requests when you need a path not wrapped as a named table or action

Authentication

OAuth [OAuth] — Register a server-based application in Zoho API Console; set Authorized Redirect URI to match the connector (for example https://zappysys.com/oauth); copy Client ID and Secret; use Generate Token in the driver UI
Example scopes from the hub include SalesIQ.operators.READ, SalesIQ.conversations.READ, SalesIQ.feedbacks.READ, and SalesIQ.departments.READ
Set AccountUrl to your Zoho accounts endpoint (for example https://accounts.zoho.com) for the correct data center

Platform fit

Standard ODBC 3.x for Power BI, Excel, SQL Server, SSIS, and custom apps
Centralized access through ZappySys Data Gateway when JDBC or non-Windows clients consume the same DSN

💡 Common Use Cases

Typical engagement analytics scenarios for the Zoho SalesIQ ODBC Driver:

Conversation exports: Land chat threads in SQL Server for NLP or QA sampling.
Example: Nightly ODBC pull into a staging table.
Visitor metrics in Power BI: Model visit and engagement KPIs from a shared DSN.
Example: Refresh semantic model on schedule.
Operator roster sync: Keep operator and department dimensions aligned with HR or routing tools.
Example: MERGE into a reference table.
Feedback aggregation: Consolidate feedback endpoints for CSAT reporting.
Example: ODBC extract to Excel for executives.
SSIS ODBC ETL: Reuse the DSN inside SSIS Execute SQL or ODBC sources.
Example: Incremental load by modified time.
Gateway-only access: Host the driver on a secure VM while JDBC clients use Data Gateway.
Example: Central DSN without per-desktop API Driver installs.

🎯 Summary

Query Zoho SalesIQ API resources with SQL instead of bespoke REST clients.
Configure OAuth once in the DSN, generate SQL from the Query Builder, and run the same statements across BI, databases, and ETL tools.

Trusted by Developers & IT Teams Worldwide

Built for ODBC Workloads: One driver model across BI, ETL, databases, and custom code.
Expert Technical Support: Engineers help with DSN setup, Zoho API Console settings, and query tuning.
Proven Enterprise Scale: Thousands of teams worldwide rely on ZappySys for API and cloud connectivity.

ODBC PowerPack

Includes Zoho SalesIQ ODBC Driver