Zoho Analytics has introduced support for integration with two more Microsoft products: SharePoint and Azure Data Lake. This new addition expands Zoho Analytics' existing integration capabilities with various Microsoft products, providing customers with enhanced data visualization, analysis, and insights.
Microsoft SharePoint
SharePoint is an online document management and storage platform, which falls into the cloud storage/drive category. Zoho Analytics users can now seamlessly integrate with SharePoint and import stored data for analysis.
Key highlights
- Import CSV, XLS, XLSX, HTML, Tabular text files, JSON, and XML file formats
- Schedule data import at select intervals
- Blend data from SharePoint into an existing table in Zoho Analytics
For a detailed guide on connecting SharePoint with Zoho Analytics, scheduling imports, and creating visualizations, refer to our help article.
Microsoft Azure Data Lake
Microsoft Azure Data Lake is fully managed data storage that enables you to store all your data in one place, which comes under the cloud database category. Zoho Analytics users can now integrate with Azure Data Lake and import the data stored there, for analysis.
Key highlights
- Import data from single or multiple tables, custom queries, and standard procedures
- Schedule data import at select intervals, starting from 15 minutes
- Create unlimited custom reports and dashboards
- Get AI-generated insights and make better decisions
To learn how to connect Azure Data Lake with Zoho Analytics, schedule import, and create visualizations, refer to our help article.
Other Microsoft product integrations
In addition to SharePoint and Azure Data Lake, Zoho Analytics already supports integration with other Microsoft products across five categories:
- Business apps
- Microsoft Dynamics CRM
- Cloud storage/drive
- Microsoft OneDrive
- Local database
- Microsoft SQL Server
- Cloud database
- Microsoft Azure SQL Database
- Microsoft Azure MySQL
- Microsoft Azure PostgreSQL
- Microsoft Azure Maria DB
- Azure SQL Data Warehouse
- Microsoft Azure Cosmos DB
- Private cloud
- Installing on Azure
Business apps
Zoho Analytics supports integration with over 100 business apps, including Microsoft Dynamics CRM.
Microsoft Dynamics CRM
With advanced analytics for Microsoft Dynamics CRM, you can analyze and track your key sales metrics.
Key highlights
- Access 100+ pregenerated reports and dashboards
- Create unlimited custom reports and dashboards
- Get AI-generated insights and make better decisions
Here's a sample dashboard for Microsoft Dynamics CRM:
(Access more sample interactive dashboards here)
To learn how to connect your Microsoft Dynamics CRM with Zoho Analytics, schedule import, and create visualizations, refer to our help article.
Cloud storage/drive
Apart from SharePoint, Zoho Analytics also integrates with Microsoft OneDrive.
OneDrive
By importing your data from OneDrive into Zoho Analytics, you can analyze your data efficiently and gain meaningful insights.
Key highlights
- Import CSV, XLS, XLSX, HTML, Tabular text files, JSON, and XML file formats
- Schedule data import at select intervals
- Blend data from OneDrive into an existing table in Zoho Analytics
To learn how to connect OneDrive with Zoho Analytics, schedule import, and create visualizations, refer to our help article.
Local database
Zoho Analytics supports integration with multiple local databases for easy and real-time analysis, which includes Microsoft SQL Server and Microsoft Azure Cosmos DB.
Microsoft SQL Server
If you want to analyze your data on a local SQL database, Zoho Analytics is the perfect solution. You can either import data into Zoho Analytics or connect live to the Microsoft SQL server without storing data in Zoho Analytics.
Zoho Databridge: Connect your local database with Zoho Analytics
To import data or connect with the database live, you'll need to install Zoho Databridge. It's a lightweight app that acts as a bridge between your SQL server and Zoho Analytics, enabling smooth connection.
Key highlights
- Import data from single or multiple tables, custom queries, and standard procedures
- Schedule data import at select intervals, if using Data Import
- Access real-time data when opting in to Live Connect
- Blend data from the SQL server into an existing table in Zoho Analytics
- Create unlimited custom reports and dashboards
- Get AI-generated insights and make better decisions
To learn how to connect a Microsoft SQL server with Zoho Analytics, schedule import, and create visualizations, refer to our help article.
Cloud database
Zoho Analytics supports integration with multiple cloud databases for easy and real-time analysis. Under Microsoft Azure, Zoho Analytics offers integration with five databases:
- Microsoft Azure SQL Database
- Microsoft Azure MySQL
- Microsoft Azure PostgreSQL
- Microsoft Azure Maria DB
- Azure SQL Data Warehouse
- Microsoft Azure Cosmos DB (Requires Zoho Databridge to connect)
If you have data in any of these cloud databases listed above and want to analyze your data, you can use Zoho Analytics. To get started, first, you'll need to allowlist Zoho Analytics IP addresses in order to access your data.
Key highlights
- Import data from single or multiple tables, custom queries, and standard procedures
- Schedule data import at select intervals
- Create unlimited custom reports and dashboards
- Get AI-generated insights and make better decisions
Private cloud
Zoho Analytics can be installed on Azure public and private cloud environments for seamless integration and analysis.
Installing on Azure
Installing Zoho Analytics in a private cloud environment provides organizations with increased data security, compliance adherence, customization, performance, integration capabilities, and control over their analytics infrastructure. These benefits enable organizations to leverage advanced analytics while meeting their specific requirements and maintaining a high level of data governance and privacy.
To learn how to deploy Zoho Analytics On-Premise on Azure and get started with your analytics journey on your private cloud, refer to our help article.
Note: Support for Data Lake and SharePoint will be added to Zoho Analytics On-Premise starting in the third quarter of 2023.
Analyze data in Microsoft products with Zoho Analytics
By supporting integration with a wide range of Microsoft products, Zoho Analytics empowers users to leverage their data efficiently. If you're already using any of the products mentioned above to store data, and are thinking of a better way to put that data to efficient use, Zoho Analytics is the perfect solution.
With Zoho Analytics as your BI and data analytics platform, you can visually analyze your data, create unlimited reports and dashboards, get automated AI insights, and collaborate with your teams—all in one place.
For those still considering the ideal business intelligence and analytics platform, you can sign up with Zoho Analytics for a 15-day free trial and explore the platform's ease of use and data analysis capabilities.
Comments