| FreeTry For FreeTry Now | STANDARDTry For FreeTry Now | ENTERPRISEGet QuoteGet Quote |
---|
|
PRICING |
Billed Annually | - | /month | Get quote |
Billed Monthly | - | | - |
Rows processed per monthThe total number of data rows processed in your organization in a month. | 20K | 2M to 100M | Starts above 100M |
Essentials |
Users- The number of users you can have in your organization.
- Anyone with whom you privately share your workspace, datasets, connections, and ruleset templates for collaboration is considered a user in Zoho DataPrep. A user is identified by their unique email address using which their Zoho DataPrep account was created.
- All users will get a separate account for login.
- You (Account admin) can control users access to the workspaces, datasets, ruleset templates, and the user's permission to handle other operations.
| 1 | 3 | Custom |
Data sources- Data sources
- You can choose from 50+ data sources including local databases, cloud databases, FTP servers, cloud storage services, and business applications.
- You can schedule more data sources by purchasing add-ons.
| - | 5 | Unlimited |
Data destinations- Data destinations
- You can choose from 30+ destinations including files, cloud storage services, cloud databases, and BI tools.
- You can schedule more data destinations by purchasing add-ons.
| - | 2 | Unlimited |
Audit retentionStore the raw and processed data of the previous months for audit purposes. | 1 month | 2 months | 6 months |
50+ Data Sources |
Files: CSV, JSON, XLS, etc.Import files of various formats including CSV, TSV, JSON, HTML, XLS, XLSX and XML. | Yes | Yes | Yes |
URLs- Import data from URLs and REST APIs.
- Import data of various formats such as CSV, TSV, JSON, HTML, XLS, XLSX, and XML files.
| Yes | Yes | Yes |
FTP serversImport data files from FTP servers. | - | Yes | Yes |
Local databases- Import data from a wide range of databases
- Databases can be in your local network.
- Import data from databases like MS SQL Server, Oracle, PostgreSQL, My SQL, DB2, and more.
| - | Yes | Yes |
Cloud databases- Import data from popular databases on the cloud
- DataPrep supports data import from cloud databases such as Amazon Redshift, Amazon RDS, Snowflake, Microsoft Azure, Google Cloud SQL, Amazon Athena, Oracle Cloud, IBM Cloud, Heroku, Rackspace Cloud, Panoply, and more.
| - | Yes | Yes |
Cloud storage services- Import data from cloud drive vendors
- DataPrep supports cloud storage services such as Google Drive, Dropbox, Microsoft OneDrive, and Amazon S3.
| Yes | Yes | Yes |
Zoho AnalyticsTighter integration with Zoho Analytics enables seamless import of data into your organization in Zoho DataPrep. | - | Yes | Yes |
Zoho CRMUsing the Zoho CRM connector, bring data from Zoho CRM to DataPrep for cleansing, transformation and enrichment of your sales data. | - | Yes | Yes |
Zoho CreatorUsing the Zoho Creator connector, bring data from Zoho Creator to DataPrep for cleansing, transformation and enrichment of your application data. | - | Yes | Yes |
Zoho BiginUsing the Zoho Bigin connector, bring data from Zoho Bigin to DataPrep for cleansing, transformation and enrichment of your sales data. | - | Yes | Yes |
Salesforce Using the Salesforce connector, bring data from Salesforce to DataPrep for cleansing, transformation and enrichment of your sales data. | - | Yes | Yes |
Data Modeling |
Automatic data modelingAutomatically identify data types and data patterns in your data. | Yes | Yes | Yes |
Outlier and anomaly detectionAutomatically identify outliers and anomalies in your data. | Yes | Yes | Yes |
Pattern analysisIdentify data patterns and analyze them using Zoho DataPrep's own pattern language. | Yes | Yes | Yes |
Data profilingDataPrep analyzes your data during import and profiles data using histograms, charts, and other data visual representations. | Yes | Yes | Yes |
Custom data types- Custom data types are used to validate organization-specific data
- Includes examples such as employee ID, invoice ID, shipment tracking ID, or asset ID.
- Creating custom data types lets you set a standard for your organization-specific columns in your data.
| - | Yes | Yes |
Data Transformation & Blending |
Join and unionJoin and append data from multiple sources based on common columns. | Yes | Yes | Yes |
Data quality analysisMeasure and improve the quality of your data with real-time data quality shown for each column and for the dataset as a whole. | Yes | Yes | Yes |
Formula engineUse 250+ functions and formulas in Zoho DataPrep for advanced data transformation. | - | Yes | Yes |
Data deduplication- DataPrep helps you identify and remove duplicate records in your data.
- You can remove specific duplicate rows using advanced matching conditions.
| Basic | Yes | Yes |
Pivot- Pivot
- Pivot operation distributes data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows into columns.
| Yes | Yes | Yes |
Unpivot- Unpivot
- Unpivot converts columns to rows. Unpivot is useful in reshaping data and exporting to analytics software for creating reports and dashboards.
| Yes | Yes | Yes |
Fill empty cellsFill empty cells using different options including most frequent value, custom values, and custom-written formulas and functions. | Basic | Yes | Yes |
Full text searchDataPrep supports full-text search on your data across columns in your dataset. | Yes | Yes | Yes |
Intelligent suggestionsDataPrep auto-suggests operations based on the imported data and enables effective data preparation. This includes column-specific and filter-specific advanced suggestions. | Yes | Yes | Yes |
Data lineage- Track every change made to your data
- Each transform applied on the dataset is tracked as a rule and can be rolled back, or edited at any point in time.
- You can even save rules as a template and share them with other users, or apply them across stages.
| Yes | Yes | Yes |
AI-powered dataprepApply AI-powered transformations seamlessly using Ask Zia, find public datasets and apply complex formulas using natural language, use ML models to perform sentiment analysis, keyword extraction, language detection, and more to enrich your data. |
Ask ZiaSimply input your data preparation needs in natural language, and Ask Zia - the data preparation copilot, will generate the required data transforms instantly. | - | Yes | Yes |
Transform by exampleTransform by example allows you to easily modify data in any column by providing output examples. It handles text, date, and numerical data with complex extractions, formatting, and calculations. | - | Yes | Yes |
Chat formula builderSimplify formula creation with natural language, quickly derive columns without needing to learn functions or syntax, and save time for analysis and other tasks. | - | Yes | Yes |
Dataset FinderEasily discover public datasets and generate sample data by request. Use Dataset Finder to create datasets tailored to your needs, blend them with first-party data, and leverage synthetic data for analysis or experimentation. | - | Yes | Yes |
Sentiment analysisAnalyze the sentiment of the text values in your data using the sentiment analysis transform powered by our machine learning engine. | - | Yes | Yes |
Language detectionDetect the language of the text in your data using the language detection transform powered by our machine learning engine. | - | Yes | Yes |
Keyword extractionExtract keywords from text data using the keyword extraction transform powered by our machine learning engine. | - | Yes | Yes |
30+ Data Destinations |
Files: CSV, JSON, XLS etc.- Export data files in various formats
- Formats include CSV, TSV, JSON, HTML, XLS, XLSX, and XML files.
| Yes | Yes | Yes |
Cloud databases- Export data to popular data warehouses on the cloud
- Export to various cloud databases including Amazon Redshift, Amazon RDS, Snowflake, Microsoft Azure, Google Cloud SQL, Amazon Athena, Oracle Cloud, IBM Cloud, Heroku, Rackspace Cloud, Panoply, and more.
- You can also setup automated data export schedules to these destinations.
| - | Yes | Yes |
Cloud storage services- Export data to cloud storage services
- Export to cloud storage services such as Google Drive, Zoho WorkDrive, Dropbox, Microsoft OneDrive, and Amazon S3.
- You can also setup automated data export schedules to these destinations.
| - | Yes | Yes |
Zoho AnalyticsTighter integration with Zoho Analytics enables seamless export of data from Zoho DataPrep to your organization in Zoho Analytics. | - | Yes | Yes |
Zoho CRMSeamlessly export prepared data from Zoho DataPrep to your organization in Zoho CRM. | - | Yes | Yes |
Zoho CreatorSeamlessly export prepared data from Zoho DataPrep to your organization in Zoho Creator. | - | Yes | Yes |
Target matching- Set target to your data pipeline
- Target matching allows you to set a target and align the prepared data to match with your target before running data pipelines.
- You can match the column structure, formats, and data types of the data prepared with the target.
- This helps you ensure high data quality and seamless exporting of data to your destination.
| - | Yes | Yes |
Audit & Scheduling |
Automated data pipelines- Setup automated data pipelines
- Create unlimited end-to-end automated pipelines from multiple data sources to BI tools, databases, cloud storage services, and business applications.
| - | Yes | Yes |
Monitoring data syncAdvanced monitoring of data flow using data pipeline views. | - | Yes | Yes |
Job history- DataPrep maintains audit for all changes on your data during pipeline schedules
- You can view audits in a timeline fashion along with user information, the changes made to your data, and the timestamp.
| - | Yes | Yes |
Sharing & Collaboration |
Sharing and access control- Share data assets such as workspaces, pipelines, pipeline templates, and ruleset templates with users and groups in your organization securely.
| - | Yes | Yes |
User groups- Create user groups
- Each group can consist of multiple users from your organization.
- Groups make it easy to share and collaborate with multiple users in your organization.
| - | Yes | Yes |
Organization Admins- Organization admins
- An organization can have multiple Organization admins. You (Account admin) can add Organization admins to your Zoho DataPrep organization to create workspaces and manage your organization.
- The organization admin role has almost all the privileges as that of the Account Admin except subscription-related permissions for your organization.
- Organization admins cannot delete or rename your organization; and cannot add, activate, or deactivate other Organization admins.
| - | Yes | Yes |
Data Catalog- Data catalog enables you to effectively manage your data assets.
- Certify data readiness for consumption.
- Organize for easy findability using tags, global faceted search, and more.
|
Mark data as ready-to-useMark pipelines ready for use after they are prepared and available for consumption. | - | Yes | Yes |
TagsYou can associate tags to entities such as workspaces and pipelines to identify, classify, or group them. You can also use tags as labels to quickly search for your entities in DataPrep. | - | Yes | Yes |
System-wide search powered by ZiaZia, Zoho's AI assistant for business is integrated with Zoho DataPrep to perform a global faceted system-wide search on your data. | Yes | Yes | Yes |
Extensibility |
Logo rebrandingRebrand your organization in Zoho DataPrep with your own logo. | - | - | Yes |
Support |
Basic (Email)Support through email and user forums. Access to the knowledge base, community forum, and more. | Yes | Yes | Yes |
Classic (8x5, Email and Phone)Support (8 hours x 5 days) through phone, email, remote assistance, and user forums. Access to the knowledge base, community forum, and more. | - | Yes | Yes |
Premium (24x5 Email and Phone)Support (24 hours x 5 days) through phone, email, chat, remote assistance, and user forums. Access to escalation, phone contact, knowledge base, community forums, and more. | - | Paid | Paid |