# Connect with Zoho Analytics

You can import data from tables, views, stored procedures, etc. from your SingleStore Helios databases in Zoho Analytics and perform analytical operations. You can also use custom queries to import your data. To sync your databases in Zoho Analytics, you can either set up a periodic synchronization schedule or synchronize data on-demand. Refer to [Import data from SingleStore](https://www.zoho.com/analytics/help/cloud-database/singlestore.html) for related information.

You can load your SingleStore data into Zoho Analytics, as:

* [Import SingleStore Helios databases into Zoho Analytics](https://docs.singlestore.com/#section-idm4544915270022433718928210803.md)
* [Connect using Zoho Analytics Live](https://docs.singlestore.com/#section-idm4506154351604833718935536661.md)

## Prerequisites

* Access to Zoho Analytics
* An active SingleStore Helios workspace
* Add the IP address for Zoho Analytics to the IP Allowlist (go to **Cloud Portal > your\_workspace > Firewall > IP Allowlist > Edit**).

## Import SingleStore Helios databases into Zoho Analytics

## Import from a New Data Source

To import your SingleStore Helios databases into Zoho Analytics from a new data source:

1. On the Zoho Analytics home page, select **Import Your Data > Databases > SingleStore**.

2. On the **Connect to Cloud Database** page, enter or select the following information, and then select **Next**.

   * **Cloud Service Name**: Select **SingleStore** from the list.
   * **Endpoint**: Enter the hostname or IP address of your SingleStore Helios workspace.

     Refer to [SingleStore Helios Endpoints](https://docs.singlestore.com/cloud/connect-to-singlestore/singlestore-helios-endpoints.md) to determine the endpoint (`host:port`) of your deployment.
   * **Port**: Use the default value, `3306`.
   * **Username**: Enter the username of the SingleStore Helios database user that is used to access the database.
   * **Password**: Enter the password for the SingleStore Helios database user.
   * **Database Name**: Enter the name of the SingleStore Helios database to import.
   * **Use SSL**: Select this checkbox if the SingleStore Helios workspace is configured to accept only SSL-enabled connections.
   * **Connection Type**: Select **Data Import**.

3. On the **Select Data to Import** page, select the data to import, and then select **Next**. Select one of the available options, and perform the required actions.

   * **Single Table**

     1. Select the table (or view) to import from the **Select Table** list, and select **Next**.

     2. On the **Import Settings and Preview** page, specify a name for the workspace and table to create in Zoho Analytics. You can also select the columns to import and modify the column names and data types. Continue from step 4.
   * **Multiple Tables**

     1. Select the table(s) (or views) to import from the list, and select **Next**.

     2. On the **Import Settings** page, specify a name for the workspace to create in Zoho Analytics. You can also rename the selected tables. Continue from step 4.
   * **Custom Query**: Enter the query in the box, and select **Next**. Here's a sample query:
     ```sql
     SELECT OrderID, Quantity FROM dbTest.Stock LIMIT 1000;
     ```
     Continue from step 4.
   * **Stored Procedure**: Specify the stored procedure in the box, and select **Next**. Here's a sample:
     ```
     CALL{ stored_procedure_name } ()
     ```

4. On the **Import Settings** page, from the **On Import Errors** list, select the action to take in the event of import errors. Select **Next**. Here are the available options:

   * Set Empty Value for the Column
   * Skip Corresponding Rows
   * Don't Import the Data

5. On the **Schedule this Import Periodically** page, configure the import schedule. You can also configure the import behavior using the **How do you want to Import** list.

6. Select **Create**. The **Cloud Database Import Initiated** page notifies you that the import process has started. You may not access the tables before the import task is complete. Select **OK**.

You can now create reports and dashboards using the imported data.

## Import from an Existing Data Source

To import more tables (or views) into Zoho Analytics from an existing data source:

1. Open your Zoho Analytics workspace configured to import data from a SingleStore Helios database.

2. Select **+ Create > Create New Table > New Table / Import Data > Cloud Databases**.

3. On the **Connect to Cloud Database** page, select the existing **SingleStore** connection for your SingleStore Helios workspace.

4. Select **Next**, and then continue from step 3 of the [Import from a New Data Source](https://docs.singlestore.com/#section-idm4570299554608033718928761305.md) process.

## Connect using Zoho Analytics Live

To connect with Zoho Analytics Live:

1. On the Zoho Analytics home page, select **Import Your Data > Cloud Databases**.

2. On the **Connect to Cloud Database** page, enter or select the connection configuration information. Refer to [Import from a New Data Source - Step 2](https://docs.singlestore.com/#section-idm4570299554608033718928761305.md) for related information.

3. Under **Connection Type**, select **Live Connect**, and then select **Next**.

4. On the **Connect Live to Cloud Database** page, select the tables, and then select **Create**.

For each selected table from the SingleStore Helios database, a table is created in Zoho Analytics. You can rename the tables in Zoho Analytics, if needed. When you access a table, the data is loaded in real-time from the SingleStore Helios database.

## Update Connection Settings

To configure your existing connection's settings:

1. Open your Zoho Analytics workspace.

2. On the left navigation pane, select **Data Sources**.

3. From the list of data sources, select the **SingleStore** data source to update.

4. On the **Data Sources** page, under **SingleStore**, select **Edit Connection**.

5. On the **Cloud Database - Edit Connection** dialog, update the connection settings, and select **Save**.

The connection settings are updated to the specified values.

## FAQs

* **Can I import data from Views created in a SingleStore Helios database?**

  Yes, you can import your tables as well as views created in a SingleStore Helios database into your Zoho Analytics workspace.
* **Are the foreign keys defined between tables in the SingleStore Helios database available/linked in Zoho Analytics on import?**

  Yes, when you import multiple tables from a SingleStore Helios database, the foreign keys defined between them are linked in Zoho Analytics as well. The foreign keys are created as Lookup columns in Zoho Analytics.

  Although, if you import data from a single table at a time (using the Single Table option), the foreign keys are not linked in Zoho Analytics. In such cases, you can manually link the tables using Lookup columns. Refer to [Joining Tables](https://www.zoho.com/analytics/help/table/joining-tables.html) for more information.



***

Modified at: May 11, 2026

Source: [/cloud/query-data/connect-with-analytics-and-bi-tools/connect-with-zoho-analytics/](https://docs.singlestore.com/cloud/query-data/connect-with-analytics-and-bi-tools/connect-with-zoho-analytics/)

(An index of the documentation is available at /llms.txt)