Welcome to Portal
Integrate Druid data with Zoho Analytics and create powerful reports and dashboards. Deploy advanced analytical models to predict future outcomes and identify anomalies. Utilize AI driven analytics to get the most out of the raw data.
Importing data from Druid comprises of three steps:
Zoho Analytics offers flexible sync schedules to ensure that the data is always up-to-date for effective analysis. It also allows you to configure which data should be fetched in each schedule.You can choose to import All the records in each schedule or the New or modified records based on the requirement.
You can choose to import all the records in each schedule or only the new records, configuring which data should be fetched.
Incremental fetch imports only the new and updated or modified records into Zoho Analytics.This method is beneficial when the database contains transactional records. that get updated frequently. Refer to the Incremental Fetch article to learn more.
Note: Import will take a few minutes to hours depending on the volume of the data. Please note, if you access the Workspace before the initial fetch is completed, you may find the tables empty (with no data).
Import rollback reverts the most recent data import to the previous version. Users with administrator privileges and custom role users with permission to create tables can perform this action. Rollback facilitates the correction of errors in data without disrupting operations and also minimizes data loss. It is useful in collaborative environments where multiple users access the data and make changes.
Note:
Follow the below steps to revert the data import to the previous version,
The Data Sources tab is the central hub that helps manage all the connection settings of the data sources in the workspace. It also helps keep tabs on the data sync status and notifies in the case of data sync failures. User with the Administrator Privilege can access the data sources tab and make necessary changes when needed.
Edit Connection: Enables admins to re-authenticate and update the connection details such as credentials or configuration settings without causing any interruption to the existing data flow.
Sync Settings: Helps modify the frequency of data synchronization (e.g., change from daily to hourly syncs) based on the current needs of your analysis. In case of a sync failure, you can specify which users should be notified. You can manage the periodic fetch settings for the tables where only the newly added records are imported. Refer to the Schedule Import section to learn more.
Audit History: Audit logs are crucial for maintaining security and troubleshooting issues. They provide a comprehensive record of User and System Actions, including details of the time when the action occurred and information about the administrator who performed the action. Audit logs are maintained for each data source in the workspace.
The following are the User Actions and the System Actions that are logged in Zoho Analytics
Type | Action | Description |
User Action | Data Source Creation | Provides the details of the admin who configured the connection with the application |
Table Creation | Provides the details of the New Tables added to the workspace. | |
Remove Table from Data source | Provides details of the tables that are deleted. | |
Edit Setup | Provides the details about the Configuration changes like re-authentication, enabling or disabling SSH. | |
Import Settings | Changes in data fetch settings | |
Sync Settings | Changes in data synchronization settings | |
Table-level Sync now | Provides the details of what records are fetched when the sync now option is used | |
System Activities | Schedule Import | Fetching data at the scheduled intervals. |
Sync History: Provides a detailed record of data synchronization activities, making it easy for the administrators to track the status of each data sync. The sync operations are color-coded for immediate recognition. 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.
Zoho Analytics provides flexible data fetch options like full data and incremental fetch, which imports only the new records. Each table can have different data fetch configurations. All the tables imported from the database will be listed with the Table and Source Table Name, What data is fetched in each sync, Last Fetch Time, and its Sync status.
Data synchronization can fail if the credential provided is invalid or expired, or if the data type mismatches. Zoho Analytics sends an email to the workspace admin and also sends an in-app notification with the reason for failure along with the necessary action to be taken to resolve the issue. Access the Data Sources tab to resolve sync failure. Refer to the Edit Setup section for more details.
Combine data from various data sources, such as Files, Feeds, Cloud storage Databases, and Business applications, for in-depth analysis. While importing data in an existing workspace, Zoho Analytics auto identifies columns of the same data type and provides suggestions for lookup. With Query Tables, you can combine data from different tables in the workspace. Use query tables to import data
To import data into an existing workspace, Click the Create icon on the side navigation panel and choose New Table/Import Data from the drop-down menu. Successive steps are similar to the steps mentioned in this section.
Import Data into an existing table
Subscribe to receive notifications from this article.