Estuary Features

Functionality (7)

Extraction: Extract data from the designated source(s) like relational databases, JSON files, and XML files.
Transformation: Cleanse and re-format extracted data to the needed target format.
Loading: Load reformatted data into target database, data warehouse, or other storage location.
Automation: Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).
Scalability: Capable of scaling processing power up or down based on ETL volume.
Non-Relational Transformations
Data Extraction: Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Management (6)

Reporting: View ETL process data via reports and visualizations like charts and graphs.
Auditing: Record ETL historical data for auditing and potential data correction needs.
Real-Time Analytics: Track data and system backups, replication, and failover events.
Solution Integration: Integrate with other management, resilience, or backup solutions
Infrastructure Compatibility: Be compatible with a variety of cloud and/or virtual infrastructure.
Monitoring: Monitor replication environment via GUI

Analytics (1)

Additional Functionality (48)

Data Mapping: Track the management and flow of data throughout the organization
Monitoring: Observe and track the demand, usage, progress or quality of a system, product, or user
Charting: Manage patient documentation describing all clinical interactions, diagnoses, procedures, medications, etc.
Integration Management: Identify which applications need to exchange data and enable these data connections
Reporting/Analytics: View and track pertinent metrics to find patterns and gain insights from data
Ad hoc Analysis
Access Controls/Permissions: Define levels of authorization for access to specific files or systems
API: Application programming interface that allows for integration with other systems/databases
Match & Merge: Looking at data from different sources and finding possible duplicates, or identical matches
Real-Time Monitoring: Active monitoring of systems, applications, or networks
Metadata Management: Collect and maintain structured information that describes data or content
Pipeline Management: Track the progress of long term goals, campaigns, and opportunities, for sales, projects, business ventures etc.
Job Scheduling: Planning and managing the execution of tasks or jobs within a computer system, network, or other automated environments
Dashboard Creation: Creation and customization of dashboards
Data Storage Management: Manage and store data in a database
Multiple Data Sources: Allows users to manage data from a number of sources
Data Import/Export: Import and export data to and from software applications
Generative AI: Use AI to generate content in the form of text, images, videos, etc.
Data Quality Control: Establish guidelines about how much and what kind of data can be stored in the repository
Data Connectors: Connect to big data sources
Customizable Reports: Alter the layout and content of reports
Single Sign On: Allow users to access multiple services after entering their login credentials once
Version Control: Track revisions and updates made to files and navigate between different versions
Visual Analytics: Interact with data visualization elements, such as charts and graphs, to drill down into data
Accounting Integration: Integrate with a third-party accounting system
Real-Time Data: Receive data and information in real time
eCommerce Management: Has a built-in eCommerce system or integrates with third-party systems to manage online sale of products
AI Copilot: A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
CRM: Built-in customer relationship management (CRM) capabilities or integration with a third-party CRM system
Data Visualization: Graphical representation of data
SSL Security: Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access
Search/Filter: Search and filter data across systems to locate required information by entering keywords or certain criteria
Real-Time Analytics: Analyze and gain insights into data in real-time
Data Capture and Transfer: Import, collect, and capture data from multiple sources
Collaboration Tools: Provides a channel for team members to share media files, communicate, and work together
Performance Management: Organize and manage the accomplishments and development of employees or performance of applications or systems
Data Synchronization: Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency
Drag & Drop: Assemble applications and processes by dragging over and arranging pre-built components
Data Replication: Process of copying and storing data in more than one site or node
Activity Dashboard: Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Database Support: Supports common databases such as MySQL and Oracle
Workflow Management: Create, design and manage workflows for repetitive tasks
Alerts/Notifications: Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges
Predictive Analytics: Predict future data based on historical data sets
Data Migration: Move from one database to another, or upgrade the version of database software being used
Third-Party Integrations: Set up connections to third-party platforms to improve business processes
Reporting & Statistics: Collection, analysis, and representation of numerical data and generation of reports to understand various patterns
Data Analysis Tools: Analyze survey results via statistical testing or crosstabs directly within the software