Flow Analytics Data Integration Overview

What Is The Flow Integration Framework?

The Flow Integration Framework is a powerful data integration engine born out of the need to have a single universal system which can adapt to and consume data from any source, structure or format.

Flow can access and integrate data from any source and consolidate this data for analysis, reporting, and other autonomous tasks.

No matter where your data resides, Flow can connect and adapt it into it's universal generic data. This rapidly accelerates the development of analysis and reporting workflows, letting you focus on implementation and result delivery instead of the bottlenecks of data access.

Flow can be used to interface with any data source, structure or api, synchronize disconnected systems, consolidate data from distributed sources into dashboards and reports, automate analysis workflows, and much more.

Any data integration workflow, no matter how complex, can be developed with no code using Flow. The framework can scale to solve even the most advanced data integration challenges with ease.

Flow's Data Integration Framework allows you to:

  • Integrate bi-directionally with any data source
  • Deploy agents for scaleable computation
  • Interface with any API
  • Access all critical data for analysis
  • Connect to any web-based source
  • Join and merge data from different sources
  • Transform and cleanse data
  • Design integrated analysis workflows
  • Consolidate all of your business data
  • Connect to and consume unstructured sources
  • Enrich internal data with external data
  • Leverage AI in integration workflows
  • Combine data into dashboards and reports
  • Synchronize disconnected systems
  • Automate the movement of data
  • Connect distributed data into hypercubes
  • Perform integrated multidimensional analysis
  • Compute new data points
  • Design advanced control structures
  • Automate the delivery of results
  • Automate any business process
  • Embed machine learning into integrations
  • Connect to tens of thousands of data sources
  • Distribute integrations across agents

Connect to Thousands of Data Sources

Traditionally, the best practice approach to integration was to code fixed connectors or adapters which understand how to parse data coming from a specific source.

While Flow does provide many pre-built adapters to common data formats, it also presents a new generic data approach to integration. Flow's generic data can adapt to any external data source or structure without requiring any knowledge of the data format ahead of time.

This generic data approach allows Flow to connect to tens of thousands of data sources on demand. Flow can connect to any form of API and consume data objects directly into structured tabular data with minimal configuration and zero code.

To see some of the data adapters Flow provides, check out the list below.

Agent-based Automation

Flow operates on a distributed agent architecture which allows for the deployment of powerful automations. Agents are autonomous computing nodes which execute workflows on a schedule or in response to an event. Agents are deployed to wherever data resides, and communicate with the Flow server to orchestrate the coordinated execution of jobs.

Flow enables you to design and develop solutions to the most advanced integration challenges. Once integration workflows are developed - they can be deployed onto autonomous agents for continuous execution on a schedule or in response to an event.

Agent-based Automation allows you to:

  • Automate the collection of data
  • Automate the transfer of data
  • Automate data cleansing tasks
  • Automate data transformation tasks
  • Automate the monitoring of data
  • Automate hypercube computation
  • Automate statistical analysis
  • Automate report generation
  • Automate cognitive computation
  • Automate machine learning
  • Automate multidimensional analysis
  • Automate the distribution of data
  • Automate the delivery of results
  • Automate anomaly detection tasks
  • Automate text data analytics
  • Automate systems synchronization
  • Automate any business process
  • Automate forecasting and prediction
  • Automate clustering and classification
  • Automate computing new data points
  • Automate distributed computation
  • Automate notifications and alerts
  • Automate data summarization
  • Monitor automations through the cloud

Cloud-based Orchestration

Integration workflows are deployed and managed from the cloud. Flow's powerful distributed agent and cloud monitoring technology allows you to monitor all autonomous processes from a central point of control.

Cloud-based Orchestration allows you to:

  • Monitor all deloyed integrations
  • Schedule integrations for automated execution
  • Manage distributed agents from the cloud
  • Orchestrate tasks across environments
  • Scale computation using local and cloud agents
  • Automate the secure transfer of data
  • Drill into all aspects of your agent cloud
  • Access your workflows anywhere
  • Share and collaborate on integrations
  • Execute agent computation ad-hoc
  • Monitor the heartbeats of agents
  • Synchronize local and remote environments
  • Audit all tasks performed by agents
  • Process datasets of any size
  • Perform multidimensional integration
  • Connect your entire organization's data
  • Manage autonomous analytical tasks
  • Trigger workflows in response to an event
  • Automate complex integrations with ease
  • Eliminate manual time-consuming tasks
  • Automate data science across your business
  • Easily communicate and share workflows
  • Create dashboards to monitor your business
  • Automate the movement of data

Cleanse, Transform, and Prepare Data

Flow's high powered configure-not-code workflow editor environment allows you to design rules to transform and cleanse data, and perform any type of advanced calculation as part of the integration workflow.

Integrated Dashboards and Reports

Flow's integration framework feeds directly into it's data analytics, reporting and dashboards engine. Flow allows you to combine all business critical data sources into consolidated dashboards and reports.

HyperCube Integration Framework

Flow's multidimensional hypercube computing framework allows for the most advanced analytical tasks to be automated as part of integration workflows. Integration workflows can pull data from any number of disconnected sources and unify the data using multidimensional analysis objects.

Flow's HyperCube Integration Framework allows you to:

  • Connect data into powerful hypercubes
  • Denormalize and flatten data for analytics
  • Perform multidimensional computation
  • Aggregate data across any number of sources
  • Create multidimensional reports and views
  • Perform multidimenisonal optimization
  • Integrate data into drill-down reports
  • Summarize the entirety of your business data
  • Harness AI and hypercubes for intelligence
  • Push hypercubes to the cloud
  • Pivot, rotate, and share hypercubes
  • Feed automated integrated dashboards
  • Perform any type of analysis
  • Automate multidimensional decision making
  • Integrate data for jagged computation
  • Automate any analytical workflow
  • Perform integrated forecasting and prediction
  • Restructure data to any source or format
  • Compute all critical business metrics
  • Distribute computation across agents
  • Build and evaluate hypercube expressions
  • Eliminate the need for code
  • Link disparate or distributed data
  • Solving any data analytics problem

Embed AI Into Integration Workflows

Flow provides a powerful artificial intelligence and machine learning engine. AI and ML actions can be embedded directly into workflow logic to create intelligent autonomous integrations.

Generic Data Engine

Flow's generic data engine allows the framework to automatically adapt to data from any source, structure or format.

Pre-built Data Adapters

Flow provides many pre-built data adapters. Flow also provides a generic data integration engine which allows the framework to consume any data source or structure not listed below.

Below are some of the out-of-the-box integration interfaces Flow provides:

  • SQL Server
  • PostgreSQL
  • DB2
  • Oracle
  • MySQL
  • SQLite
  • MariaDB
  • Terradata
  • HDFS
  • MongoDB
  • SalesForce CRM
  • Pipedrive CRM
  • Zoho CRM
  • Redtail CRM
  • MS Dynamics CRM
  • FTP Servers
  • Buffer
  • Windows Powershell
  • AWS Migration Hub
  • AWS Schema Conversion Tool
  • AWS Snowball
  • Amazon CloudFront
  • AWS Direct Connect
  • AWS Auto Scaling
  • AWS CloudFormation
  • AWS CloudTrail
  • AWS OpsWorks
  • AWS Service Catalog
  • AWS Systems Manager
  • AWS Health
  • Amazon SageMaker
  • Amazon Comprehend
  • Amazon Lex
  • Amazon Polly
  • Amazon Rekognition
  • Amazon Machine Learning
  • Apache MXNet on AWS
  • Amazon Translate
  • Amazon Transcribe
  • AWS DeepLens
  • Amazon Athena
  • Amazon CloudSearch
  • AWS Data Pipeline
  • Amazon Elasticsearch Service
  • Amazon EMR
  • AWS Glue
  • Amazon Kinesis
  • Amazon QuickSight
  • Amazon Redshift
  • Amazon SWF
  • Amazon SQS
  • Amazon SNS
  • Amazon MQ
  • Amazon Connect
  • Amazon SES
  • Alexa for Business
  • Amazon Chime
  • Amazon WorkDocs
  • Amazon WorkMail
  • AWS IoT Core
  • Google Cloud Monitor
  • Google Cloud Pub/Sub
  • Google Cloud Resource Manager
  • Google Cloud Runtime Config
  • Google Cloud Spanner
  • Google Cloud Speech
  • Google Cloud SQL
  • Google Cloud Storage
  • Google Cloud Tool
  • Google Cloud Vision
  • Google Compute Engine
  • Google Compute Instance Groups
  • Google Cloud Machine Learning Engine
  • Delimited Files
  • Positional Files
  • Excel Files
  • IIS Logs
  • JSON Files
  • XML Files
  • Access Databases
  • Unstructured Text Documents
  • HTML
  • Mailchimp
  • Mandrill
  • NY Times
  • Watson Discovery
  • Open Exchange
  • Paypal
  • Paylocity
  • E-money
  • TD Ameritrade
  • Charles Schwab
  • Postmark
  • Web Transfers
  • Poloniex
  • Heroku
  • SFTP Servers
  • Wordpress
  • Google Enterprise Apps
  • Google Firebase Dynamic Links
  • Google Firebase Rules
  • Google Fusion Tables
  • Google Groups Migrations
  • Google Groups Settings
  • Google GSuite Activity
  • Google Genomics
  • Google Knowledgegraph
  • Google Manufacturer Center
  • Google Mirror (Glass)
  • Google Pagespeed Insights
  • Google Partners API
  • Google People
  • Google Play EMM
  • Google Play Developer
  • Google Play Game Services
  • Google Play Movies Partner API
  • Google Plus Domains
  • Google Proximity Beacons
  • Google Search Console
  • Google Service Control
  • Google Sheets
  • Google Shopping
  • Google Sites
  • Google Site Verification API
  • Google Spectrum Database
  • Google Stack Driver Debugging
  • Google Stack Driver Reporting
  • Google Stack Driver Tracing
  • Google Storage Transfers
  • Google Surveys
  • Google Sheets
  • Google Tag Manager
  • Google Task Queue
  • Google Tasks
  • Google Tracing
  • Google BigQuery
  • Gmail
  • Google Cloud Natural Language
  • Google Consumer Surveys
  • Google Custom Search
  • Google Data Flow
  • Google Discovery
  • Google Doubleclick Bid Manager
  • Google Doubleclick Search
  • Google Drive
  • Google Enterprise Apps Reseller
  • Google Cloud Deployment Manager
  • Twitter
  • Twitter Ads
  • Facebook Graph
  • Facebook Ads
  • Google+
  • LinkedIn
  • FourSquare
  • Instagram
  • Pintrest
  • Reddit
  • Youtube
  • Shopify
  • Magento
  • 500px
  • App Figures
  • Bit.ly
  • Constant Contact
  • Pivotal Tracker
  • Ebay
  • EventBrite
  • Etsy
  • FourSquare
  • Fitbit
  • Flickr
  • Coinbase
  • Bittrex
  • Quandl
  • RSS Feeds
  • Atom Feeds
  • Ruby Gems
  • Github
  • Marketo
  • Hubspot
  • Shipstation
  • Sparkpost
  • Spotify
  • Square
  • TradeGecko
  • TradeKing
  • Wunderlist
  • Yahoo Finance
  • Yahoo Quotes
  • Quickbooks
  • Sage
  • Sharepoint
  • Onedrive
  • Dropbox
  • Basecamp
  • Blogger
  • Buffer
  • MS Outlook
  • Vimeo
  • Trello
  • Twilio
  • Slack
  • Freshbooks
  • NopCommerce
  • Opencart
  • Zoho Reports
  • Stripe
  • SMTP
  • Box Storage
  • Blogger
  • Google Adexchange Buyer
  • Google Adexchange Seller
  • Google Adsense
  • Google App Engine
  • Google App State
  • Google Books
  • Google Calender
  • Google Civic Information
  • Google Classroom
  • Google Cloud Billing
  • Google Cloud Container Builder
  • Google Cloud Data Store
  • HTML
  • Any RESTful API
  • Generic HTTP Request
  • Generic JSON Adapter
  • Amazon Products
  • Google Analytics
  • E-trade
  • Google Ads
  • Microsoft Graph
  • Zendesk
  • JIRA
  • Amazon MWS
  • Yellow Pages
  • Azure Advisor
  • Azure Analysis Services
  • Azure Advisor
  • Azure API Management
  • Azure Application Gateway
  • Azure App Service
  • Azure Batch Management
  • Azure Batch Service
  • Azure CDN
  • Azure Cognitive Services
  • Azure Compute
  • Azure Container Registry
  • Azure Data Catalog
  • Azure Data Factory
  • Azure Data Lake Analytics
  • Azure Data Lake Store
  • Azure Dev Test Labs
  • Azure DocumentDB
  • Azure Event Hub
  • Azure Graph RBAC
  • Azure HD Insights
  • Azure HD Insights Spark
  • Azure Intune
  • Azure IoT Hub
  • Azure Log Analytics
  • Azure Logic Apps
  • Azure Machine Learning
  • Azure Monitor
  • Azure Network Gateway
  • Azure Network API
  • Azure Network Watcher
  • Azure Notification Hubs
  • Azure Scheduler
  • Azure Search Management
  • Azure Server Management
  • Azure Service Bus
  • Azure Storage Import/Export
  • Azure CosmosDB
  • Bing Search
  • Amazon EC2
  • Amazon Elastic Container Registry
  • Amazon Elastic Container Service
  • Amazon Lightsail
  • AWS Elastic Beanstalk
  • AWS Lambda
  • Amazon S3
  • Amazon EBS
  • Amazon EFS
  • Amazon Glacier
  • AWS Snowball
  • AWS Storage Gateway
  • Amazon RDS
  • Amazon DynamoDB
  • Amazon ElastiCache
  • Amazon Redshift
  • Amazon Neptune
  • AWS Application Discovery Service
  • AWS Database Migration Service
  • AWS Import/Export