Connect with 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.

   • 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

     Copy

     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:

     Copy

     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 process.