Skip to main content

Accessing TDS Service from Zoho Analytics

info

Available for: Flex (SSIS) and Gems (Pre-built)

Overview​

Zoho Analytics can connect to the COZYROC Cloud TDS service using its Microsoft SQL Server (MSSQL) connector.

To establish a connection, you must provide:

  • TDS endpoint details
  • Your COZYROC credentials

This guide walks you through preparing your COZYROC account and importing data into Zoho Analytics.

Prerequisites​

Before you begin, ensure you have:

Step 1 — Open Import Data​

  1. Log into Zoho Analytics
  2. Click Import Data or Create New Table

Step 2 — Choose MSSQL Connector​

  1. In the Import Data screen, search for MSSQL
  2. Select the Microsoft SQL Server connector

Select MSSQL connector

Step 3 — Fill Connection Properties​

Enter the following connection details:

  • Endpoint / Host: tds.cozyroc.cloud
  • SQL Server Instance: COZYROC
  • Port: 14333
  • Username: Your COZYROC Cloud account email
  • Password: Your Personal Access Token generated in COZYROC Cloud
  • Database Name: COZYROC

Connection properties

note

Enable Use SSL to ensure secure communication with the TDS service.

Step 4 — Select Data to Import​

  1. Choose Single Table
    • (Or Multiple Tables if needed)
  2. Select your Reporting Datasource table
  3. Click Next

Select data to import

Step 5 — Confirm Import Settings​

  1. Review detected column types
  2. Adjust column names or data types if necessary
  3. Click Create

Data preview

Step 6 — Import Initiation​

Zoho Analytics will begin importing data from your TDS service.

You should see a confirmation message such as:

Cloud Database Import Initiated

Import initiated

Step 7 — Monitor Sync Status​

  1. Navigate to Data Sources
  2. Locate your MSSQL connection
  3. Check the status — it will show Sync in Progress

Sync in progress

Step 8 — Data Availability​

Once synchronization completes:

  • The table appears in your workspace
  • Data becomes available for reporting and dashboards
  • TDS packages and definitions are accessible

Data imported

Troubleshooting Connection Issues​

If the connection fails, verify:

  • Endpoint and port are correct
  • Access token is valid and not expired
  • SSL is enabled
  • IP allow-listing is configured if required

Next Steps​

You are now ready to build reports and dashboards in Zoho Analytics using your COZYROC Cloud TDS data.