Compare All Data Preparation Products

 Open Studio for Data QualityOpen Studio for Data IntegrationData Integration Entry-LevelData Management Platform
Product Details Product Details Product Details Product Details 

License

Free Open SourceFree Open SourceUser-based subscriptionUser-based subscription
Free open source Apache license
Subscription license with warranty and indemnification

Design and Productivity Tools

Eclipse-based developer tooling and job designer
Team collaboration with shared repository
Continuous integration / Continous delivery
Audit, job compare, impact analysis, testing, debugging, and tuning
Metadata bridge for metadata import/export, and centralized metadata management
Distant run and parallelization
Dynamic schema, re-usable joblets, and reference projects
Repository manager
ETL and ELT support
Wizards and interactive data viewer
Versioning
Export and execute standalone jobs in runtime environments
Change data capture (CDC)
Drools business rule management system
Automatic documentation
Customizable assessment
Pattern library
Analytics with graphical charts and drilldown data

Components

File management: open, move, compress, decompress without scripting
Control and orchestrate data flows and data integrations with master jobs
Map, aggregate, sort, enrich, and merge data

Connectors

Cloud: AWS, Microsoft Azure, Google Cloud Platform, and more
RDBMS: Oracle, Teradata, Microsoft SQL server, and more
SaaS: Marketo, Salesforce, NetSuite, and more
Packaged Apps: SAP, Microsoft Dynamics, Sugar CRM, and more
Technologies: Dropbox, Box, SMTP, FTP/SFTP, LDAP, and more
Cleansing, masking and error resolution
Optional 3rd-party address validation services

Management and Monitoring

High availability, load balancing, failover for jobs
Deployment manager and team collaboration
Manage users, groups, roles, projects, and licenses
Amazon EC2 lifecycle control
Execution plan, time, and event-based scheduler
Check points, error recovery
Context management (dev, QA, prod)
Activity monitoring
Log server with dashboard

Data Quality and Governance

Data profiling and analytics with graphical charts and drilldown data
Automate data quality error resolution and enforce rules
Data cleansing and masking
Data quality portal with monitoring, reporting, and dashboards
Semantic discovery with automatic detection of patterns
Comprehensive survivorship
Data sampling
Enrichment, harmonization, fuzzy matching, and de-duplication

Advanced Data Profiling

Fraud pattern detection using Benford Law
Advanced statistics with indicator thresholds
Column set analysis
Advanced matching analysis
Time column correlation analysis

Data Preparation and Stewardship

Import, export, and combine data from any database, Excel or CSV file
Import, export, and combine CSV, Parquet and AVRO files
Export to Tableau
Self-service on-demand access to sanctioned datasets
Share data preparations and datasets
Operationalize preparations into any data or big data integration flow
Run preparations on Apache Beam
Auto-discovery, profiling, smart suggestions, and data visualization
Auto-discovery and auto-profiling of custom semantic types
Smart and selective sampling and full-runs
Data tracking and masking with role-based security
Cleansing and enrichment functions
Data Stewardship App for data curation and certification

Support

Self-serviceSelf-serviceWeb, emailWeb, email, phone

Contact Sales

For information about our collection and use of your personal information, our privacy and security practices and your data protection rights, please see our privacy policy.