Datatific Review Help & User Guide
Everything you need to get started and master Datatific Review
Quick Start Guide
Get up and running with Datatific Review in just a few minutes:
1Installation
- Download from Microsoft Store
- Install and launch the application
- Accept the EULA and configure initial settings
2First Connection
- Click "New Connection" to add a data source
- Choose from Access, Excel, MySQL, Oracle, or SQL Server
- Enter connection details and test the connection
3Explore Your Data
- Browse the data tree to view tables and views
- Double-click any table to open it in the Data Explorer
- Use filters and search to find specific data
4Compare Data
- Open two tables or data sources
- Click "Compare" to analyze differences
- Use AI Auto Map for automatic column alignment
Basic Features & Operations
Data Explorer
View and navigate your data with powerful filtering and search capabilities.
- Tree navigation for databases and tables
- Column filtering and sorting
- Regular expression search
- Row and column metadata
Data Comparison
Compare tables from different sources with intelligent column mapping.
- Cross-database comparisons
- AI-powered Auto Map feature
- Visual difference highlighting
- Export comparison results
Copy & Export
Extract data in multiple formats for use in other applications.
- Copy to clipboard with headers
- Export to Excel, XML, Text
- Customizable export options
- Preserve formatting and filters
SQL Editor
Execute SQL queries and manage database objects directly.
- Syntax highlighting
- Query result viewing
- DDL and DML operations
- Transaction management
Advanced Features
AI Auto Map
Intelligent column mapping for data comparison between different schemas.
- Automatically matches columns with different names but similar data
- Handles data type conversions intelligently
- Learns from user corrections to improve accuracy
- Supports fuzzy matching for similar column names
Expression Builder
Create virtual columns using expressions and calculations.
- Mathematical operations: +, -, *, /, %
- String functions: CONCAT, SUBSTRING, UPPER, LOWER
- Date functions: YEAR, MONTH, DAY, DATEDIFF
- Conditional logic: IF, CASE, WHEN
- Aggregate functions: SUM, COUNT, AVG, MIN, MAX
Advanced Filtering
Sophisticated data filtering and search capabilities.
- Regular expression pattern matching
- Multiple column filters with AND/OR logic
- Date range filtering
- Numeric range filters
- Custom filter expressions
Data Synchronization
Import and synchronize data between different systems.
- Insert new records based on comparison results
- Update existing records with differences
- Delete records not present in source
- Batch operations with transaction support
Common Issues & Solutions
Problem: Cannot connect to database
Solutions:
- Verify server name and port number
- Check username and password
- Ensure database service is running
- Test network connectivity
- Check firewall settings
- For SQL Server: Enable TCP/IP protocol
- For MySQL: Verify user has remote access permissions
Problem: Slow data loading or comparison
Solutions:
- Use filters to limit data before comparison
- Index key columns in your database
- Increase memory allocation in Options
- Close unnecessary data views
- Consider upgrading to Premium for performance optimizations
Problem: Auto Map not working correctly
Solutions:
- Manually map columns that Auto Map missed
- Ensure column data types are compatible
- Use column formats to standardize data
- Check for null values that might affect mapping
- Verify unique key columns are properly selected
Tips & Best Practices
Data Exploration Tips
- Use the Data Navigator to quickly understand your data structure
- Right-click columns for quick access to common operations
- Use Ctrl+F to open the advanced search dialog
- Save frequently used table layouts for quick access
- Use the Row Data panel to view vertical data layouts
Comparison Best Practices
- Always define proper unique key columns
- Use filters to compare subsets of large tables
- Apply column formats to standardize data before comparison
- Save comparison configurations for repeated use
- Export results to Excel for further analysis
Keyboard Shortcuts
- Ctrl + N - New Connection
- Ctrl + O - Open Table
- Ctrl + F - Advanced Search
- Ctrl + C - Copy Selected Data
- F5 - Refresh Data
- Ctrl + E - Export Data
- Ctrl + M - Compare Tables
Configuration Tips
- Set up connection profiles for frequently used databases
- Configure default export formats in Options
- Customize the interface theme for better visibility
- Set memory limits based on your system capabilities
- Enable auto-save for comparison configurations
Need More Help?
Video Tutorial
Watch our comprehensive getting started video to see Datatific Review in action: