Boomi Data Integration Features
Functionality (37)
-
Diverse Extraction Points
Pull any required data from a variety of sources, including email, web pages, PDFs, and other documents.
-
Data Structuring
Organize extracted data into a more easily digestible structure.
-
Consolidation
Amass extracted data in a variety of data formats like spreadsheets and .csv.
-
Data Cleaning
Clean extracted data by removing duplicates, clearing excess characters, grouping by characteristic, and more.
-
Cloud Extraction
Stores data in cloud storage for access at any point.
-
Visualization
Generate visual data representations from extracted data.
Data Extraction
Automatically retrieve and pull information from documents, websites, images, data sets, and other sources
Real-Time Data
Receive data and information in real time
Image Extraction
Extract images and image data from multiple data sources
IP Address Extraction
Extract IP addresses from multiple data sources
Email Address Extraction
Extract email addresses from multiple data sources
Metadata Extraction
Retrieval of embedded metadata that is present within a file
Document Extraction
Extract documents and document data from data sources
Phone Number Extraction
Extract pricing data from multiple data sources.
Auto Extraction
Automatically capture data from documents, records, or other online sources
IP Address Extraction
Extract IP addresses from multiple data sources
Email Address Extraction
Extract email addresses from multiple data sources
Image Extraction
Extract images and image data from multiple data sources
Web Data Extraction
Extract data from any online source.
-
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
-
Data Migration
Migrate data from on-premises or cloud solutions to a separate cloud environment or solution.
-
Data Variety
Be compatible with a variety of data types for migration.
-
Alerts and Logging
Send alerts for migration failures, and log migration processes to show possible root causes for failures.
-
Data Replication
Copy and store the same data in multiple locations.
Debugging
Ensures live debugging to alert if any failure during data sync.
Workflow Automations
Supports the creation of automated workflows and data pipelines.
Notifications
Supports notifications in messaging applications such as Slack, and even in workflows.
API Integrations
Provides several pre-built connectors and API integrations to build data workflows.
Programmed trigger of data sync
Programmatic trigger of syncs via public APIs
Incremental data sync
Native support for incremental syncing
Data audit
Move sync logs back into warehouse for auditing
Management (10)
-
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.
-
Backup and Recovery
Offer backup and/or recovery options for data being migrated to the cloud.
-
Integration Variety
Integrates with a variety of sources and/or migration targets.
-
Access and Security
Maintain user access and security features associated with pre-migrated data in the post-migration environment.
-
Real time Monitoring
Real-time view and status of every component in the cloud environment.
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
Solution Provision (3)
System Failover
Provide as-before failover capabilities for cloud environments.
Pay by Usage
Services are offered under a pay-as-you-go or utilization-based purchase model.
Service Provision
Offer disaster recovery capabilities as a third-party provider.
Security (3)
-
Data Protection
Transform or encode data before being moved to the cloud.
Security Compliance
Supports industry standards (GDPR, CCPA etc) before, during, and after the reverse ETL process.
Data Encryption
Ensures data encryption across multiple levels of the reverse ETL process.
Data Management (5)
Data Modeling
Supports the creation of SQL models to query any data warehouse.
Auditing
Detailed logging for auditing needs.
Observability
Real-time visibility into the reverse ETL process.
Data mapping
Configures data mapping from data warehouse to target tools.
Reporting
View the reverse ETL data via reports and charts through data viz and sync progress.
Diverse Extraction Points (1)
-
Diverse Extraction Points
Pull any required data from a variety of sources, including email, web pages, PDFs, and other documents.
Generative AI (1)
AI Text Generation
Allows users to generate text based on a text prompt.
Agentic AI - Cloud Migration (3)
Autonomous Task Execution
Capability to perform complex tasks without constant human input
Multi-step Planning
Ability to break down and plan multi-step processes
Decision Making
Makes informed choices based on available data and objectives
Additional Functionality (117)
Data Storage Management
Manage and store data in a database
Customizable Templates
Pre-designed layouts that can be customized to match preferences and requirements
Multiple Data Sources
Allows users to manage data from a number of sources
Forecasting
Form predictions based on past and present data/trends
Reminders
Timed notification for any upcoming task, deadline, appointment, or activity
Multi-Language
Manage and support multiple languages
Visual Discovery
Process of visually navigating data and applying analytics to detect patterns, gain insight, and answer specific business queries.
Mobile Access
Access software remotely via mobile devices
Rules-Based Workflow
Automates and streamlines business processes by creating a sequence of predefined rules and actions that govern the flow of work
API
Application programming interface that allows for integration with other systems/databases
Customizable Forms
Customize contracts and forms to collect specific information
Drag & Drop
Assemble applications and processes by dragging over and arranging pre-built components
Third-Party Integrations
Set up connections to third-party platforms to improve business processes
Workflow Management
Create, design and manage workflows for repetitive tasks
Data Mapping
Track the management and flow of data throughout the organization
Trend Analysis
Review data from past periods to reveal recurring tendencies and predict future performance
Compliance Management
Track and manage adherence to policies for any service, product, process, or supplier
Data Connectors
Connect to big data sources
Multi-Channel Distribution
Multiple channels (email, web link, or social media) to distribute products, services, or surveys to customers
Search/Filter
Search and filter data across systems to locate required information by entering keywords or certain criteria
Data Transformation
Translate EDI formats into data suitable for use with company applications.
Data Import/Export
Import and export data to and from software applications
Data Synchronization
Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency
Reporting/Analytics
View and track pertinent metrics to find patterns and gain insights from data
Surveys & Feedback
Gauge satisfaction and receive information for improvement and success
Customizable Fields
Customize data fields to support various needs and use cases
Forms Management
Store, manage and track all forms in a centralized location
Multi-Channel Data Collection
Collect information from multiple sources
HIPAA Compliant
Compliant with HIPAA, which sets standards for sensitive patient data protection
Metadata Management
Collect and maintain structured information that describes data or content
Secure Data Storage
Securely stores data to prevent data loss or breaches
Generative AI
Use AI to generate content in the form of text, images, videos, etc.
Access Controls/Permissions
Define levels of authorization for access to specific files or systems
Multi-Device Support
Support multiple types of devices
AI Copilot
A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
Visual Analytics
Interact with data visualization elements, such as charts and graphs, to drill down into data
Audience Targeting
Identify a particular segment of population based on specific criteria and customize your efforts to attract their attention
Offline Response Collection
Practice of collecting data and responses for market research/surveys without an internet connection
Data Capture and Transfer
Import, collect, and capture data from multiple sources
Customizable Reports
Alter the layout and content of reports
Activity Dashboard
Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Dashboard Creation
Creation and customization of dashboards
Version Control
Track revisions and updates made to files and navigate between different versions
Query Builder
Tool that allows users to create and execute database queries without needing to know the underlying syntax of the database
IP Rotation
Automatically changes IP addresses to avoid website IP restrictions.
AI/Machine Learning
Software program that continuously adjusts its behavior based on observed data
Data Verification
Process of checking different types of data for accuracy to avoid errors or inconsistencies
Optical Character Recognition
Ability to recognize printed or written text within digital images or scanned documents
Batch Processing
Software's ability to perform similar action on multiple similar files simultaneously
Data Aggregation and Publishing
Assemble data from multiple sources
Job Scheduling
Planning and managing the execution of tasks or jobs within a computer system, network, or other automated environments
Data Mining
AI method of discovering or extracting data patterns from larger volumes of data
Proxy Rotation
Rotating through a series of proxy servers to conceal IP addresses during internet activities
Geotargeting
Geographic location of visitors determines behavior of the software
Data Aggregation
Collect, process and structure data from multiple sources for further analysis
JavaScript Rendering
Converting JavaScript code into visual elements on web pages for user interaction
HTML Parsing
Extract structured data from HTML documents for analysis or manipulation
Multiple File Format Support
Supports multiple file formats, such as Doc, Docx, PDF, HTML, etc.
Data Cleansing
Removes data that is incomplete, inaccurate, or irrelevant from a dataset
Reporting & Statistics
Collection, analysis, and representation of numerical data and generation of reports to understand various patterns
Natural Language Processing
Process and analyze human language in text or audio form
CAPTCHA Solving
Automatically identify and input CAPTCHA characters to bypass security measures
Integration Management
Identify which applications need to exchange data and enable these data connections
Website Crawling
Crawling and indexing web pages
Scheduling
Plan availability and assign specific time slots for tasks and resources
Bot Mitigation
Reduce or block bot traffic
User Management
Manage user accounts, profiles, roles, permissions, and other details across applications, devices or networks
Customization
Create labels for products that contain required information such as colors, sizes, dates, etc.
Proactive Error Detection
Managing and resolving errors that occur during program execution to maintain stability
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


