Azure Data Lake

Azure Data Lake

Zoho Analytics allows you to connect to the data stored in Data Lake. Zoho Analytics enables you to create data visualizations that help in identifying the underlying trends  and optimize operational efficiency. You can also schedule imports and import data from different sources to effectively analyze your data.

Data Import

1. What are the storage types in Azure Data Lake from which I can import data into Zoho Analytics? 

Zoho Analytics supports data import from the following Azure Data Lake storage types
  1. Containers
  2. File share
  3. Tables

2. How to import data from Azure Data Lake?    



Note: The connection details will be saved, and you can use them later to import files or tables from the same storage types.

3. How long does it take for the data to be imported into Zoho Analytics?

After setup, you might have to wait sometime for the initial fetch to happen. This depends upon the amount of data imported into Zoho Analytics and also the response time of your Azure Data Lake server. You will receive an email notification once the import is complete. Please note that, if you access the workspace before the initial fetch, it will not display any data.

Import Settings

1. How to set custom date format?

Zoho Analytics intelligently identifies the format of the date column while importing but if there's any difference in the identified format you can change it using the Format Date option while importing. Refer to this link to know more about constructing custom date format.


2. Can I change the data type of the columns imported in Zoho Analytics?

Yes, you can change the data type of the columns imported into Zoho Analytics. However, it is necessary that the data type of your column is compatible with the data type of the column in Azure Datalake for successful data synchronizations. It is always recommended that you change the data type in both your Azure datalake as well as your Zoho Analytics workspace.
To change the data type, click the drop-down icon of the column and select the data type from the list.


3. Will I be notified of Import failures?

Yes, you can be notified after consecutive import failures, in case it occurs. To get notified of import failures, you need to set the number of consecutive import failures after which you need to be notified in the Notify me after every Sync Failure(s) option of the schedule import.Yes, you can be notified after consecutive import failures, in case it occurs. To get notified of import failures, you need to set the number of consecutive import failures after which you need to be notified in the Notify me after every Sync Failure(s) option of the schedule import.

4. Can I save my import settings? 

Yes, Zoho Analytics saves the import details and you can view the import details and make changes if needed.
To view the import details,
  1. Click Import Data.
  2. Select Refetch/Schedule Import  option from the drop-down.

  3. The Schedule Import Details dialog will open. You can view the following details
    1. Schedule: Provides the timing and the interval of when the data will be synced.
    2. Next Fetch : Provides the details of when the next sync is due.
    3. Last Fetch : Provides the details of when the data was last synced.


Data Blending

1. Can I import data into an existing table?

Yes, Zoho Analytics allows you to import data into an existing table. You can import data from the same source (Azure Data Lake) or from a different source.
Note: To import data into an existing table, at least one column header should match the data that is set to import.

To import data into an existing table,
  1. From the required table, click Import Data > Import Data into this Table.



  2. The Import Your Data tab will open listing the relevant data sources. Choose  Azure Data Lake from the listed data sources.



  3. The Import Data tab will open. Select How do you want to Import from the drop-down menu.



  4. You can configure a new connection as mentioned in this presentation or use the existing connection to import data. Select the file to import and click Next.



  5. The Import settings tab will open.By default, Zoho Analytics will map the corresponding column headers of the existing table with the table that is set for import. It also allows you to import data as a new column.
  6. Click Import.


2. Can I import data into an existing workspace?

Yes, Zoho Analytics allows you to import data into an existing workspace. You can join tables right at the time of import. Click here to learn about joining tables .  You can import data from the same source (Azure Data Lake) or from a different source.

Follow the below steps to import data into an existing workspace
  1. Open the workspace into which you intend to import the data.
  2. Click Create > New Table/Import Data.
  3. Choose Azure Data Lake from the listed sources.
  4. You can configure a new connection as mentioned in the setup presentation or use the existing connection details to import data.
  5. To import data using existing connection details,
    1. Click the drop-down icon of the  Connection Name  field.
    2. Select the storage type (connection) from which you intend to import.
    3. The connection string/credentials will be auto filled. Click Browse and choose the file to import.
    4. Click Next.



  6. The Create Table (Import) page will open. Click Join Tables to define lookups.
  7. The Join Tables - Combine the new tables with existing tables dialog will open.
  8. Select the columns and specify the relation to be defined.
  9. Click Save and Close.

Manage Data Sources

1. How to edit the import setup?

Zoho Analytics allows you to make changes to the import setup anytime during your analysis.

Follow the below steps to edit the setup,
  1. Open the workspace for which you intend to edit the setup.
  2. Click the Data Sources tab from the Navigation bar.
  3. The Data Sources page will open. All the data sources in that workspace will be listed.
  4. Click Edit Setup to make the changes.
  5. Modify the settings as required and click Save.


2.How to synchronize data instantly?

If the data has been modified in the data source, you can immediately update Zoho Analytics using Refetch Now option without having to wait till the next schedule interval.
  1. Open the required workspace .
  2. Click the Data Sources tab from the left navigation bar.
  3. In the Data Sources page that opens, click Refetch Now.


3. How to remove the setup?

To remove the setup,
  1. Open the required workspace.
  2. Click the Data Sources tab from the navigation bar.
  3. All the data sources for this workspace will be listed. Click the data source that you want to remove.
  4. In the Data Sources tab that opens, click the Settings icon inline to the data source name on the right.
  5. Select Remove Data Source option from the drop-down menu.