StarfishETL Features

View ETL process data via reports and visualizations like charts and graphs.

Record ETL historical data for auditing and potential data correction needs.

Offer backup and/or recovery options for data being migrated to the cloud.

Integrates with a variety of sources and/or migration targets.

Maintain user access and security features associated with pre-migrated data in the post-migration environment.

Real-time view and status of every component in the cloud environment.

Extract data from the designated source(s) like relational databases, JSON files, and XML files.

Cleanse and re-format extracted data to the needed target format.

Load reformatted data into target database, data warehouse, or other storage location.

Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).

Capable of scaling processing power up or down based on ETL volume.

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Migrate data from on-premises or cloud solutions to a separate cloud environment or solution.

Be compatible with a variety of data types for migration.

Send alerts for migration failures, and log migration processes to show possible root causes for failures.

Copy and store the same data in multiple locations.

Transform or encode data before being moved to the cloud.

Employs data encryption both at rest and in transit.

Comply to key industry standards like SOC 2, ISO 27001, PCI DSS, HIPAA etc to protect and safeguard data.

Supports secure communication protocols like FTPS, SFTP etc

Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access

Supports event or transaction based integrations that react to changes in real-time

Provides a web-based interface for designing, documenting, and testing APIs.

Allows for integration development through the visual development of integration logic flows with the help od a drag and drop user interface.

Facilitiates API development and integrations with prebuilt connectors, templates, and examples.

Provides the ability to create connectors from existing services and APIs in catalog.

Provides prebuilt, reusable connectors and workflows for all user integration requirements.

Enables multiple tenants (customers) to securely share physical computing resources.

Connect to big data sources

Integrates with QuickBooks

Integrates with Active Directory

Integrating data specifically through the cloud

Integrate with existing ERP systems

Set up connections to third-party platforms to improve business processes

Integrate with social media platforms such as Facebook, Twitter, LinkedIn, etc.

Integrate with a third-party accounting system

Seamlessly integrates with 3rd party websites

Console for monitoring resource utilization, system health, ability to start and stop processes, etc.

Enables data routing on configuration basis and management of complex workflows through an orchestration engine.

Facilitates to and fro data map according to the data model between applications/web services.

Provides standard tools and functions to convert data values from the data format of a source system into the data format of a destination system.

Supports and oversees the management of API products across their full lifecycle

Ability to handle large datasets

Store, manage, and track all electronic documents in a centralized location

Create, design and manage workflows for repetitive tasks

Track, manage and store the applications of potential future members, customers or candidates

Manage, record and track all business exchanges in form of money and its related interactions in the system

Collect and maintain structured information that describes data or content

Identify which applications need to exchange data and enable these data connections

Manage and store data in a database

Manage user accounts, profiles, roles, permissions, and other details across applications, devices or networks

Manage employee salary processes, data, taxes, and records administration efficiently

Manage, store and organize emails within the system or via third-party apps

Identify which applications need to exchange data and enable these data connections

Managing service requests, incidents, IT issues & support with a ticketing system

Automates core HR functions such as talent management, employee evaluation and learning management

Has a built-in eCommerce system or integrates with third-party systems to manage online sale of products

Managing activities & processes related to planning, coordination, implementation, control, and evaluation of sales performance.

Active monitoring of systems, applications, or networks

Notifications that are delivered to users as soon as an event occurs

Integrates data from disparate sources, without physical data movement

Provides one or more methods to securely transfer data from one location to another through a network

Provides integration to BigData sources such as Hadoop and other NoSQL sources (MongoDB, Cassandra and HBase)

Provides Integrations to EDI service providers.

Receive data and information in real time

Import, collect, and capture data from multiple sources

Supports deployment of integration apps both on-premisis and cloud environments/

Supports deployment of integration apps to a managed cloud environment

Capability to perform complex tasks without constant human input

Ability to break down and plan multi-step processes

Makes informed choices based on available data and objectives

Receive system updates as soon as any changes are made

Search and filter data across systems to locate required information by entering keywords or certain criteria

View and track pertinent metrics to find patterns and gain insights from data

Data vault where data is aggregated for later distribution to applications.

Import and export data to and from software applications

Process of extracting, transforming, and loading data

Use AI to generate content in the form of text, images, videos, etc.

Graphical representation of data

Define levels of authorization for access to specific files or systems

Supports common databases such as MySQL and Oracle

System alerts about the need to escalate an issue or request

A chronological record of actions or occurrences within a network, software, or process

Assembly of graphs and charts for visualizing and tracking statistics/metrics

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

Observe and track the demand, usage, progress or quality of a system, product, or user

An extended application or connector that enables users to perform additional services with their current set of tools

Active reporting of data and metrics

Application programming interface that allows for integration with other systems/databases

Allows users to manage data from a number of sources

Track and document all activities across devices, networks, and other systems

Assemble applications and processes by dragging over and arranging pre-built components

Automatically create schedules based on business needs or employee availability and qualifications

Configure existing workflows to meet your organization's needs

Assemble data from multiple sources

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Access software remotely via mobile devices

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Allows the integration of data between different web services

Analyze and gain insights into data in real-time

Send messages via SMS

Accept and process customer payments for products or services using hardware and software

Built-in customer relationship management (CRM) capabilities or integration with a third-party CRM system

Creation and customization of dashboards

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Software program that continuously adjusts its behavior based on observed data

Establish guidelines about how much and what kind of data can be stored in the repository

Built-in accounting to manage ledger, accounts payable/receivable, financial reports, etc.

Generate one-off reports that meet information requirements

Track the management and flow of data throughout the organization

Observe and track the demand, usage, progress or quality of a system, product, or user

Manage patient documentation describing all clinical interactions, diagnoses, procedures, medications, etc.

Identify which applications need to exchange data and enable these data connections

View and track pertinent metrics to find patterns and gain insights from data

Define levels of authorization for access to specific files or systems

Application programming interface that allows for integration with other systems/databases

Looking at data from different sources and finding possible duplicates, or identical matches

Active monitoring of systems, applications, or networks

Collect and maintain structured information that describes data or content

Track the progress of long term goals, campaigns, and opportunities, for sales, projects, business ventures etc.

Planning and managing the execution of tasks or jobs within a computer system, network, or other automated environments

Creation and customization of dashboards

Manage and store data in a database

Allows users to manage data from a number of sources

Import and export data to and from software applications

Use AI to generate content in the form of text, images, videos, etc.

Establish guidelines about how much and what kind of data can be stored in the repository

Connect to big data sources

Alter the layout and content of reports

Allow users to access multiple services after entering their login credentials once

Track revisions and updates made to files and navigate between different versions

Interact with data visualization elements, such as charts and graphs, to drill down into data

Integrate with a third-party accounting system

Receive data and information in real time

Has a built-in eCommerce system or integrates with third-party systems to manage online sale of products

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Built-in customer relationship management (CRM) capabilities or integration with a third-party CRM system

Graphical representation of data

Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access

Search and filter data across systems to locate required information by entering keywords or certain criteria

Analyze and gain insights into data in real-time

Import, collect, and capture data from multiple sources

Provides a channel for team members to share media files, communicate, and work together

Organize and manage the accomplishments and development of employees or performance of applications or systems

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

Assemble applications and processes by dragging over and arranging pre-built components

Process of copying and storing data in more than one site or node

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Supports common databases such as MySQL and Oracle

Create, design and manage workflows for repetitive tasks

Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges

Predict future data based on historical data sets

Move from one database to another, or upgrade the version of database software being used

Set up connections to third-party platforms to improve business processes

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Analyze survey results via statistical testing or crosstabs directly within the software