Best On-Premise Data Integration Software

On-premise data integration software allows businesses to unify data from disparate on-premise sources within a company in various formats. On-premise data integration products provide standard connectors to other on-premise software, and also include functionality to cleanse, monitor, and transform data. On-premise data integration products are sold as a standalone product and can be installed locally or in a private cloud environment. Integration of on-premise resources is typically done with pre-built connectors, and vendors of these products will update connectors as necessary for new programs and data sources. On-premise data integration tools act as a communication hub for data being passed between applications so they commonly integrate with most all on-premise categories.

To qualify for inclusion in the On-Premise Data Integration category, a product must:

  • Synchronize business data and applications through an installed local network
  • Allow users to access and extract data from a centralized interface
  • Have tools or logic to be able to manipulate data as it passes between applications
G2 Grid® for On-Premise Data Integration
High Performers
Market Presence
Star Rating

On-Premise Data Integration reviews by real, verified users. Find unbiased ratings on user satisfaction, features, and price based on the most reviews available anywhere.

Compare On-Premise Data Integration Software

Results: 72
G2 takes pride in showing unbiased ratings on user satisfaction. G2 does not allow for paid placement in any of our ratings.
Results: 72
Filter Results
Filter by:
Sort by
Star Rating
Sort By:

    SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using their preferred language and environment. Experience industry-leading performance, rest assured with innovative security features, transform your business with AI built-in, and deliver insights wherever your users are with mobile BI.

    Cleo Integration Cloud
    (26)4.4 out of 5
    Optimized for quick response
    Optimized for quick response

    Compared with other software companies, Cleo is different – for one big reason: We genuinely appreciate our customers and the integration technology challenges they’re facing. We always put their interests first, and never quit until their problems are solved. That’s why we say Cleo … never stops. We give our customers a strategic, “outside-in” visibility into the critical end-to-end business flows happening across their ecosystems of partners and customers, marketplaces, and internal cloud and on-premise applications. Cleo empowers teams to drive business agility, accelerate onboarding, facilitate modernization of key business processes, and capture new revenue streams by reimagining and remastering their digital ecosystem through robust application, B2B, and data integration technologies. Our flagship offering, Cleo Integration Cloud, is a single, hybrid ecosystem integration platform available as a service in cloud and on-premise deployment options. Its flexible architecture lets you choose between a blend of self-service and managed service models, enabling you to connect, transform, integrate, orchestrate, and analyze end-to-end application, B2B, and data integrations for improved visibility across your business ecosystems. The platform empowers technical and business personas to make better decisions, create stronger relationships with your trading partners, drive business continuity and accelerate growth as integration requirements change. No matter the integration, Cleo’s got you covered.

    Data Integration The fastest, most cost effective way to connect data. Talend offers robust data integration in an open and scalable architecture to maximize its value to your business. As part of the Talend Data Fabric, Talend Data Integration provides the unified tools to integrate, cleanse, mask and profile all of your data, enabling you to turn data into decisions. -Develop and deploy 10 times faster -Increase trust in data -Lower cost of ownership

    Atlas for Microsoft Dynamics 365/AX allows users to create powerful reports with drill-down in Excel using live ERP data. Atlas provides one platform to consolidate data from key business systems into a single report, eliminating the need for manual re-keying or downloading of data into Excel. Users can seamlessly access Microsoft Dynamics data in the cloud or on-premise. Take advantage of integration features that enable you to design, build, and share real-time reporting in Excel spreadsheets, and visualize the data using Power BI or customizable Atlas dashboards.

    Riva syncs a dozen of the world's best CRM systems – Salesforce, Microsoft Dynamics CRM, SAP C4C, Oracle Sales Cloud, Infor CRM, NetSuite, SugarCRM, and others – directly to Microsoft Exchange, Office 365, Gmail and Google Apps, IBM Notes and Domino, Novell GroupWise, and Marketo. With Riva, you can seamlessly sync contacts, calendars, tasks, email, opportunities, cases, custom fields and custom objects between your CRM and email systems. Because Riva syncs server-side, it means there are no Outlook or IBM Notes plug-ins to install, configure, or manage on users' desktops, laptops, and mobile devices. Plus, we're not limited to just syncing to Windows Outlook. Riva syncs CRM to all email clients and mobile devices – Windows Outlook (64-bit, 32-bit), Outlook Web App, Outlook for Mac, Outlook on Citrix, Apple Mail, IBM Notes, Novell GroupWise, iPad, iPhone, Android, BlackBerry, Windows Phone, and Surface tablets. Join tens of thousands of CRM users – from Fortune 500 companies to SMBs – who use Riva to sell more, sync more, and save more time. Visit us at for more information. Social channels:

    AWS Server Migration Service (SMS) is an agentless service designed to make it easier and faster for users to migrate thousands of on-premises workloads to AWS.

    Relational Junction
    (9)4.4 out of 5
    Optimized for quick response
    Optimized for quick response

    Protect and integrate your valuable corporate data with Sesame Software’s Relational Junction suite of Enterprise Application Integration products. Sesame Software provides solutions for over 125 different SaaS applications including Salesforce, MS Dynamics, NetSuite, Marketo, Pardot, as well as any relational database. For corporations worldwide, this suite delivers scalable database ETL, information warehouse, on-premise and cloud integration, as well as complete backup and recovery capabilities to reduce business risk, eliminate data loss and ensure regulatory compliance for your data. The Relational Junction suite offers a unique approach to integration that: - Leverages existing database skills. Learn the entire product in an hour. - Supports best practices for development and testing of complex systems. - Provides a high performance, low footprint, fault-tolerant runtime environment.

    INTEGRATION: Quickly connect all systems and applications—no matter where they are—using the webMethods Integration Platform. Leverage IT investments and adopt new technologies quickly and with less risk and redundancy. Capabilities are extensive in our platform, featuring a best-of-breed Enterprise Service Bus (ESB). Along with application, B2B and cloud integration, the webMethods BigData Gateway provides connectivity for the ingestion, orchestration, consumption and governance of IoT BigData, Cloud Computing and On-Premises. systems. Solutions: *B2B Integration*: Eliminate the extra hardware and EDI software licenses and maintenance fees that come with multiple B2B systems. Consolidate your transactions on a scalable B2B gateway. *Cloud Integration*: Quickly and securely link SaaS apps and on-premise systems. Rapidly build custom integrations with other cloud-based applications. Then, monitor and manage these integrations. *BigData Gateway*: A Hadoop strategy for connecting any enterprise data from IoT, the Cloud or on-premises. *Managed File Transfer*: Exchange files of any size—even big data files—up to 25 times faster. Managed file transfer via webMethods is ideal for managing an ever-increasing volume of enterprise file transfers. *Master Data Management*: Reconcile, cleanse and synchronize any master data—on customers, products, suppliers, any category. Eliminate redundancies and errors by using a true multi-domain Master Data Management (MDM) platform. API MANAGEMENT: Companies getting on board the API economy require an API management platform to ensure efficient operations. webMethods brings it all together for you—design, development, deployment, security, publishing and monitoring of your APIs and services—a complete end-to-end API management platform. Solutions: *webMethods API-Portal*: Promote and document your REST and SOAP APIs. Manage access to your APIs. Collect analytics to better understand your visitors and how they are using your APIs. With webMethods API Cloud, Software AG's API portal is now available as a hosted service. *CentraSite*: Catalog all assets, from services to APIs and their related assets. Provides asset governance. *webMethods Mediator*: Enforce policies, monitor SLAs, perform traffic management, collect analytics, and product alerts and events for downstream processing. *webMethods Enterprise Gateway*: Provide DMZ security for back-end services and APIs. Authentication, flexible security rules and threat protection at the network edge. *webMethods Insight*: Gain real-time visibility into service transactions. Easily find root-cause location of SLA violations, exceptions and other service processing problems.

    Centerprise Data Integrator
    (7)4.4 out of 5
    Optimized for quick response
    Optimized for quick response

    Centerprise Data Integrator provides a powerful, scalable, high-performance, and affordable integration platform designed for ease of use by your business information experts, yet robust enough to overcome even the biggest and most complex data integration challenges. Centerprise is a complete data integration solution that includes data integration, data transformation, data quality, and data profiling in a flexible environment that enables users to choose from multiple integration scenarios.

    FME is the data integration software with the best support for spatial data - no coding required. Use FME to connect hundreds of applications, transform data structure and content, and automate tasks.

    InaPlex is a specialist in integration and migration products and services for mid market CRM systems.

    Neuron ESB
    (6)4.5 out of 5
    Optimized for quick response
    Optimized for quick response

    Neuron ESB is an easy-to-use enterprise service bus that simplifies messaging, system integration and Web service enablement. It facilitates quick integration of disparate applications and speeds up the adoption of service-oriented architecture. Built on Microsoft .NET, Neuron ESB enables clients to leverage existing in-house developer skills and tools to deploy projects in a matter of weeks rather than months.

    AWS Snowball Edge is a 100TB data transfer device with on-board storage and compute capabilities.

    StarfishETL for Integration: StarfishETL provides seamless data integration from one database to another - whether hosted, on-premises, or in the Cloud. It links multiple databases and systems with extreme flexibility, power, and speed, and delivers the insights to engage your customers and prospects on a whole new level. StarfishETL can integrate your CRM with email, ERP, social media, marketing automation systems, and even specialized databases. StarfishETL for Migration: StarfishETL is loaded with pre-built capabilities, but it's not limited by them. You have the power to set up your project any way you desire to get the data results that fit your business. Add custom fields in our Cloud wizard, or use the on-premises tool for more advanced personalization.

    SharePlex is the complete enterprise solution for Oracle database replication, including high availability, scalability, data integration and reporting use cases.

    ImportOmatic is fast and easy data integration for Blackbaud's Raiser's Edge and Raiser's Edge NXT. Whether you want to drill down or set up a scheduled import, ImportOmatic redefines efficiencies with baked-in intelligence to clean data, smart profiles for tailored processing, and an expanding catalog of connectors that make import and export a one-step process. With ImportOmatic you can say goodbye to messy imports and hello to clean, standardized data. That means: - Import and export data from any source, quickly and easily. - No more workarounds, no more keying in of data, and no more duplicates. - Save time, and lots of it, by cleaning and standardizing data as you import into Raiser's Edge. - Stay on top of every detail or not, while ImportOmatic does the work for you. ImportOmatic Connectors make it possible to move data to and from 3rd party tools like Classy, DonorDrive, Luminate Online, MailChimp, TeamRaiser, VolunteerHub, WealthEngine and more – in a single step, no spreadsheet required! If you're looking to spend less time manipulating your data and more time leveraging it, ImportOmatic is the answer.

    The Informatica enterprise data integration product family is scalable, high-performance enterprise data integration software. These products access and integrate data from virtually any business system, in any format, and deliver that data throughout the enterprise at any speed.

    Omni-Gen Master Data Management (MDM) Edition provides a single platform for generating applications that combine data integration, data quality, and master data management – in a fraction of the time such projects used to require. The benefits are huge – typical project times can be reduced from a year-and-a-half to six months or less. (NOTE: Other iWay components, such as iWay Service Manager, are included as part of the Omni-Gen platform.)

    (3)4.5 out of 5
    Optimized for quick response
    Optimized for quick response

    Astera ReportMiner data extraction software provides a complete solution for end-to-end data ingestion and integration for unstructured data sources. ReportMiner enables you to liberate business data trapped in documents such as PDFs, PDF forms, PRN, TXT, RTF, DOC,DOCX, XLS, and XLSX. With features for data cleansing/scrubbing, business rules-based data quality verification, data transformation (merging, splitting, normalizing, denormalizing, and more), and loading into high-end database platforms, the perfect integration flow can be designed to extract, transform, and load data into the final destination for operations and business intelligence applications. ReportMiner Enterprise Edition also provides a built-in scheduler with real-time scheduling features, so not only is the extract/transform/load process automated, but also job scheduling and maintenance. ReportMiner Enterprise Edition ensures you get the best out of the automation process.

    Scribe Insight
    (3)4.2 out of 5
    Optimized for quick response
    Optimized for quick response

    Business applications and the data stored in them are the life blood of your company, but if disconnected they can limit your sales efforts, hurt profitability, and erode customer relationships. Scribe Insight is the powerful data and application integration platform that keeps data seamlessly flowing between your most critical business systems. Uniquely suited for today’s fast-paced businesses, Scribe Insight allows you to configure enterprise-class integrations with limited budgets and small IT staff. Thousands of large and mid-sized businesses, public sector organizations, VARs, and systems integrators rely on Scribe Insight for: • Front office / back office integration • Real-time synchronization between cloud and on-premises applications • Data replication - transform and combine data from multiple sources for on-going analytics • One-time data migrations

    Data Virtuality provides data integration solutions that help companies to easily connect and manage their data from multiple data sources such as APIs, databases and flat files. The revolutionary single source of data truth platform combines data virtualization and automated ETL. In this way not only is data management simplified but data integration efforts are significantly reduced – by up to 80%. Imprint:

    Optimized for quick response

    Better understand your data and cleanse, monitor, transform and deliver it. Build confidence in your data Delivers clean, consistent and timely information for your data warehouses or big data projects and applications. Create a flexible governance strategy Helps you adapt a data governance strategy to suit your organizational objectives, while shaping business information in unique ways to meet your needs. Modernize and consolidate your systems Enables you to consolidate applications, retire outdated databases and modernize your infrastructure, as well as automate business processes for improved cost savings. Connect business and IT Provides a unified platform that enables collaboration, which can help you bridge the gap between business and IT and align objectives.

    Oracle GoldenGate (on-premises & Cloud Service) products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables: -Real-time business intelligence and stream analytics for improved business insight -Query offloading to maximize OLTP performance -Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability Link - Datasheet - Datasheet (Stream Analytics) - Analyst whitepaper -

    You cannot afford to run your business on questionable data. With SAP® Data Services software, you can access, transform, and connect data to fuel your critical business processes. Together, these enterprise-class solutions enable data integration and data quality, providing the right level of insight across your business so you can make better decisions and operate more effectively.

    The SSIS Integration Toolkit leverages Microsoft SQL Server Integration Services (SSIS) as the ETL integration platform. The SSIS Integration Toolkit is composed of SSIS components to enable integration with various enterprise applications and additional SSIS components to achieve more within SSIS without custom scripting. The SSIS Integration Toolkit includes data integration solutions for over 50 applications and services including Microsoft Dynamics 365, Salesforce, NetSuite, Microsoft SharePoint, Marketo, HubSpot, Active Directory, Jira, and many more. The SSIS Integration Toolkit also includes dozens of unique components to assist with data integration development to make your job easier including tools for working with virtually any web service or API, advance transformations. Our solutions eliminate the needs of writing custom scripts for some commonly-encountered complex requirements in SSIS/ETL development. SSIS Integration Toolkit solutions can be run on SQL Server or on the cloud using Azure-SSIS IR (ADFv2)

    Apache Synapse is a lightweight and high-performance Enterprise Service Bus (ESB). Apache Synapse provides exceptional support for XML, Web Services and REST.

    Devart SSIS Data Flow Components allow you to integrate database and cloud data via SQL Server Integration Services (SSIS). Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features. For now the list of supported data sources includes: *Oracle *MySQL *PostgreSQL *DB2 *Amazon Redshift *Azure SQL Data Warehouse *Google BigQuery *Salesforce *Dynamics CRM *Zoho CRM *SugarCRM *QuickBooks *FreshBooks *MailChimp *Salesforce Marketing Cloud *Marketo *BigCommerce *Magento

    The Syncfusion Data Integration Platform allows you to easily bring data from a wide array of sources together. Its intuitive, drag-and-drop visual interface allows for integrating and transforming data from disparate sources into analytics-ready data – with no coding needed. The transformed data can then be easily used for data warehousing, creating reports and dashboards, or for business intelligence analysis purposes. Several built-in data processors are available for working with popular data sources, including JDBC connections (SQLServer, MySQL, Oracle, etc.); Rest API; Social feeds (Twitter, Google Analytics, etc.); Amazon; No SQL (Cassandra, Mongo, HBase, Elasticsearch, etc.); File Formats (JSON, XML, CSV, etc.); and Big data (HDFS, HBase, Flume). The extensible platform features enterprise-grade encryption to ensure secure data flow and user-management capabilities. It easily integrates with the Syncfusion Big Data and Dashboard Platforms – creating an end-to-end solution from a single vendor. All that functionality comes with the backing of an experienced team providing samples and support that quickly get users up, running, and making the most of their data.

    Talend delivers a unified platform for application integration and data integration allowing firms to increase business productivity, deliver projects faster, and lower operating costs. As part of the Talend Data Fabric, Talend Application Integration provides a high-speed services backbone and enables you to build a service-oriented architecture to connect, mediate and manage services in real-time. Based on best-in-class and extensible open source ESB and Data Integration technology, Talend empowers organizations to take advantage of more applications and data resources than ever before.

    TMate SubGit is a tool for teams that migrate from SVN to Git. It converts SVN repositories to Git and allows you to work with both systems simultaneously.

    Allows migration of DL/1 and VSAM data to Adabas without changing the original applications. Available for Adabas on mainframe.

    APIANT offers Data Integration Software Solutions for Citizen Integrators, Integration Specialists, IT Managers, SaaS Companies and Enterprises. On the cloud or self-hosted, the APIANT platform empowers non-developers (no code) and developers (low-code) to build sophisticated multi-directional integrations visually and quickly. Integrations can be deployed in minutes with thousands of pre-built and modular connectors in the Automation Editor. Business specific requirements can also be met by customizing integration endpoints with a powerful low-code development tool called the Assembly Editor. APIANT’s assembly editor is designed to help more advanced users customize their integrations. With the assembly editor, users can create custom data integration solutions easily without coding knowledge. Even more complex integrations can be connected and assembled directly by APIANT’s dev team. Users can monitor the progress of any custom-built integration from the central integration development project portal. APIANT offers a number of powerful features including: - Integration templates (1 automation) and collections (multiple automations) - Bi-directional syncing for all apps (two-way sync) - A visual decision logic action routine - Multiple triggers and actions - Custom business logic - Flexible scheduling - Automation sharing and duplication - Local backup of integration (small xml file) Other important features include history and activity logs, pre-built assemblies and nested diagrams, as well as web services, batch jobs and advanced debugging. APIANT’s testing tools allow users to test and confirm that automations work properly before they go live.

    APIWorx is a fully managed service that makes it easy to create, publish, maintain, monitor, and secure APIs at any scale. APIWorx handles all the tasks involved in accepting and processing up to hundreds of thousands of concurrent API calls, including traffic management, authorization and access control, monitoring, and API version management.

    AWS Application Discovery Service helps enterprise customers plan migration projects by gathering information about their on-premises data centers.

    The AWS Snowmobile moves up to 100PB of data (equivalent to 1,250 AWS Snowball devices) in a 45-foot long ruggedized shipping container and is ideal for multi-petabyte or Exabyte-scale digital media migrations and datacenter shutdowns. A Snowmobile arrives at the customer site and appears as a network-attached data store for more secure, high-speed data transfer. After data is transferred to Snowmobile, it is driven back to an AWS Region where the data is loaded into Amazon S3. Snowmobile is tamper-resistant, waterproof, and temperature controlled with multiple layers of logical and physical security -- including encryption, fire suppression, dedicated security personnel, GPS tracking, alarm monitoring, 24/7 video surveillance, and an escort security vehicle during transit.

    The demand for secure, reliable B2B exchange is continually growing. Enterprises are compelled to engage with more and more partners to move expanding volumes and types of data automatically using less time and resources. As a result, companies are challenged to find new ways to modernize their B2B integration infrastructure and gain the capabilities that are essential to competing and succeeding in the digital era. This includes B2B Cloud Managed services. As a strategic tool for creating new business, a managed cloud service brings APIs into the B2B/EDI equation to streamline partner collaboration and expand services to customers using powerful mobile apps. It lets you delegate the mundane tasks of platform management to a dedicated outside team, so you stay focused on SLAs. A managed cloud is pliable – adapting to tightening security standards such as GDPR and others faster and cheaper. It’s also reversible, meaning you can switch back to ground-based, on-premises B2B anytime if necessary.

    AMPLIFY MFT enables the exchange of files securely with ever-expanding partner and customer ecosystems by supporting real-time engagement and on-demand consumption of services through APIs. Acknowledging new IT paradigms such as microservices, DevOps, ITSEM and more generally IT-as-a-service, Axway MFT scales to handle increasing volumes and on-demand interactions with an organization's exploding environment of apps using APIs in order to engage in new ways and develop and exploit new business models. AMPLIFY SecureTransport is a multi-protocol MFT gateway for securing, managing, and tracking file flows among people and applications inside your enterprise, and beyond your firewall to your user communities, the cloud and mobile devices. AMPLIFY Transfer CFT is a powerful file transfer controller that provides file exchange services between disparate hardware and software platforms using open protocols, within or beyond the boundaries of your enterprise. AMPLIFY Central Governance is a single solution for governing the flow of data between the entities involved in a business process. It centralizes and unifies the governance features responsible for leveraging data, metadata and events handled by the AMPLIFY Managed File Transfer solution and products

    BI Connector offers a simple, secure connection from Tableau to OBIEE for business users, enabling powerful visualization and blending of OBIEE data.

    BridgeGate offers a comprehensive software platform that integrates data quickly and inexpensively, with virtually no code.

    CA RC/Migrator for DB2 for z/OS to automate administrative tasks to increase database availability and decrease human error. It helps to automate the migration of DB2 objects from one environment to another with features designed to simplify administration tasks, reduce database downtime and increase DBA productivity.

    CloverDX Data Integration Platform is help mid to large organizations to design, automate and operate data intensive jobs at scale.

    eprentise, established in 2006, provides transformation software products that allow companies to make their Oracle E-Business Suite systems agile enough to support changing business requirements, avoid a reimplementation and lower the total cost of ownership of ERP while also enabling real-time access to complete, consistent and correct data across the enterprise.

    COZYROC SSIS+ Components Suite for fast and easy ETL. COZYROC SSIS+ is a comprehensive suite of 200+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. Our easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages. COZYROC SSIS+ Components Suite has been successfully used by thousands of businesses, in more than 140 countries around the world.

    Devart ODBC Drivers is a connectivity solutions for ODBC-based applications to access popular databases directly from Windows, MacOS, Linux, both 32-bit and 64-bit, that support standard ODBC API functions and data types, multiple server data types and features it has direct access to databases and clouds, which eliminates the use of database client libraries, simplifies the deployment process, and extends application capabilities.

    DSYNC is a live integration platform for connecting applications.

    eIntegrator is a Windows based application that runs on your workstation or server with QuickBooks. For QuickBooks Online it does need a Windows environment either on your system or rented service (ask about our Windows rentals). QuickBooks For MAC is not supported but QuickBooks for Windows can be supported via Parallels or similar tool running on your MAC.

    Hybrid Data Pipeline (HDP) is our self-hostable hybrid connectivity solution that you can run in the cloud or on-premises. With HDP, you can access data in the cloud or on-premises behind a firewall. Connect through a standard interface SQL (ODBC, JDBC) or REST (OData 2, OData 4).

    Integrate your IBM i data with PC applications and documents