Importing data from Elasticsearch

Zoho Analytics enables data import from Elasticsearch, allowing you to create visualizations that reveal trends and generate valuable insights. Additionally, you can schedule imports and cross-blend data from other data sources for comprehensive analysis.

• Import data from Elasticsearch
• Manage data import configuration
• Logs
  • Audit history
  • Sync history
• Import rollback
• Resolve synchronization failure
• Data blending
  • Import into existing workspace
  • Import into existing table

Import data

Manage data import configuration

Logs

Audit history

Zoho Analytics provides a detailed record of all actions performed with respect to data synchronization from various sources. The history captures the type of action performed along with the timestamp and information about the administrator who performed it.

The following are the user and system actions that are logged in Zoho Analytics.

Sync history

Zoho Analytics' sync history delivers a comprehensive log of data synchronization activities with color-coded indicators, allowing administrators to track the status of each sync. Successful data syncs are indicated in green, signaling that the data sync is completed without any issues. Failed data syncs are marked in red with the reasons for failure along with the necessary action to be taken.

Import rollback

Import rollback allows users with administrator privileges to revert datasets to a previously stable configuration by undoing any changes made during recent sync cycles. This feature helps correct errors in the data without interrupting operations and reduces the risk of data loss. It is useful in collaborative environments where multiple users access the data and make changes.

Note:

• Data can be reverted to its previous state within 4 hours of the import.
• Deleted columns will not be reverted during the import rollback.
• Any actions, such as adding a new column, creating formulas, formatting columns, and having lookups defined, will be preserved during the import rollback.

Follow the below steps to revert the data import to the previous version,

1. Open the data table, which needs to be reverted.

2. Click Import Data > Last Import Details.

   

3. Click Rollback to revert to the previous instance.

   

4. Import rollback will be initiated, displaying the status along with the details of the admin who performed the action and the time of execution.

   

Resolve synchronization failure

The import or synchronization process can sometimes fail due to a variety of reasons. To understand the reason behind the failure and to resolve the synchronization failure, follow the below steps.

1. Click Data Sources from the side panel, and navigate to the Elasticsearch data source detail page. 
2. Navigate to the table where the data sync failed. 
3. Hover over the table name, and click the View Last Import Details icon. This opens the Import Details page, which provides detailed insight on the reason for the synchronization failure.

You can also view the Import Details page by opening the required table and selecting the Import Data > Last Import Details option.

Data Blending

Zoho Analytics lets you import data from various data sources, such as Files, Feeds, Cloud storage, Databases, and Business applications, and relate them using lookup relationships or query tables for in-depth analysis. 

Import data into an existing workspace

Follow the below steps to import data into an existing workspace:

1. Open the required workspace. 

2. Click + Create from the side panel, and select the New Table / Import Data option.

   

3. Click the Elasticsearch tile, and follow the steps detailed in the import data section.

Import data into an existing table

1. Open the desired table.

2. Click Import Data > Import Data into this Table option.

   

3. Click the Elasticsearch tile, and follow the steps detailed in the import data section.

Note: To import data into an existing table, at least one column header should match the data that is set to import.