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

On-Premise Data Integration Software Grid® Overview

The best On-Premise Data Integration Software products are determined by customer satisfaction (based on user reviews) and market presence (based on products’ scale, focus, and influence) and placed into four categories on the Grid®:
G2 Crowd Grid® for On-Premise Data Integration
Leaders
High Performers
Contenders
Niche
Market Presence
Satisfaction
Compare On-Premise Data Integration Software
    Results: 56

    Filters
    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.

    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.


    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.


    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 www.rivacrmintegration.com for more information. Social channels: http://www.rivacrmintegration.com/twitter/ http://www.rivacrmintegration.com/youtube/ http://www.rivacrmintegration.com/googleplus/ http://www.rivacrmintegration.com/linkedin/ http://www.rivacrmintegration.com/facebook/ http://www.rivacrmintegration.com/flickr/ http://www.rivacrmintegration.com/news/



    The Cleo Integration Cloud accelerates the way you can build, automate and manage B2B, application, cloud, and big data integrations. Built on trusted Cleo solutions that are scalable, easy to use, and require no custom code or specialized skillsets to manage daily integration operations.


    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.


    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.


    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.


    Protect and integrate your corporate data with Sesame Software’s Relational Junction suite of Enterprise Application Integration products, including best of breed solutions for Salesforce, NetSuite, and QuickBooks that leverage each platform’s specific technical requirements without the limitations of plug-ins to general purpose ETL Manager. Relational Junction provides data warehouse reporting capabilities for Cloud applications, protects valuable corporate data with recoverable backups, and enables simple or complex integration between on-premise, Cloud, and custom applications. 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. Products include: - Relational Junction ETL Manager -- SQL-based Extract-Transform-Load for databases, flat files, XML, and a variety of other data sources. - Relational Junction for Salesforce -- The fastest and most scalable bi-directional data replication for Salesforce.com to an on-premise database. - Relational Junction for NETSUITE -- Data replication for NETSUITE to an on-premise database. - Relational Junction Special Edition for QuickBooks -- Integration platform for Salesforce.com to QuickBooks customer & invoice creation with amazing flexibility and customization.


    TIBCO ActiveMatrix BusinessWorks is a platform for developing new services and integrating applications with minimal code required.


    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


    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.


    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.


    SAP Data Services allows you to deliver information to all your business functions with the ability to integrate, transform, and manage your data at the project or enterprise level.


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



    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


    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.


    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.


    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.)


    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.


    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.


    Heterogeneous database replication for on-premises, cloud or hybrid environments. SharePlex replicates data from Oracle or SQL Server to more than a dozen other platforms, including Amazon RDS, AuroraDB, Azure SQL Database service, EDB Postgres Advanced Server, Java Message Service (JMS), Kafka, MySQL, PostgreSQL, SAP ASE, SAP HANA, Oracle, Microsoft SQL Server, EDB Postgres Advanced Server, Teradata, Kafka, and flat, SQL and XML files. With no vendor lock, you can easily implement a single solution across both Oracle and SQL Server databases.


    Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.


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


    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.


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


    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.


    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.


    Talend simplifies big data integration with graphical tools and wizards that generate native code so you can start working with Apache Hadoop, Apache Spark, Spark Streaming and NoSQL databases today. Talend Big Data Integration platform delivers high-scale, in-memory fast data processing, as part of the Talend Data Fabric solution, so your enterprise can turn more and more data into real-time decisions.


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


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


    AWS Storage Gateway is a service that connect an on-premises software appliance with cloud-based storage to provide seamless and secure integration between an organizations on-premises IT environment and AWS's storage infrastructure.


    More4Apps offers a broad selection of Excel-based data integration products to process information with superior speed and accuracy.



    SmartConnect makes migrating, integrating and generating new data an easy exercise. SmartConnect is a tool dedicated to simplifying the integration process for customers that base their business around Microsoft Dynamics GP, CRM and SalesForce.com.


    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: CRM: Salesforce, Dynamics CRM, Zoho CRM, SugarCRM Accounting: QuickBooks, FreshBooks Marketing: MailChimp, ExactTarget Ecommerce: Bigcommerce, Magento Database: Oracle, MySQL,PostgreSQL, DB2


    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: Microsoft Dynamics (365, CRM, AX, NAV, GP, SL, and Marketing), Salesforce, NetSuite, Microsoft SharePoint, Marketo, HubSpot, Active Directory, Magento, Xero, QuickBooks, Oracle CRM On Demand, Microsoft Project Server, Team Foundation Server, Oracle Marketing Cloud, and Parature. The SSIS Integration Toolkit also includes the SSIS Productivity Pack with over six dozen unique and premium components such as Premium Derived Column, email components, components for integrating with any web API, JSON & XML components, Premium ADO.NET Source and Destination, Data Quality and Comparison, components for integration with cloud storage and message queues, and many more.


    Voxility's Data Centers are made to allow clients to connect easily to hundreds of other ISP, cloud providers and customers.


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


    AWS Snowmobile is an Exabyte-scale data transfer service used to move extremely large amounts of data to AWS.


    To adapt and grow in the digital economy, you need to be able to integrate, secure, manage and measure all of the data flows — new and old — that drive your business processes and interactions, both inside your organization and beyond your firewall. Axway 5 Suite delivers enterprise solutions to help you do just that.



    DataVirtuality Platform connects any data source with all Business Intelligence tools. The software accesses, manages and integrates any database and cloud service in real-time. All, by using SQL. Combining data virtualization and Extract-Load-Transform (ELT) processes, DataVirtuality is the only solution that both enlarges and accelerates complex analyses with a minimum effort. Imprint: https://datavirtuality.com/imprint/


    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.


    Iguana has everything you need to build, test, monitor and troubleshoot any healthcare interface - all in a single platform.


    Kovair Omnibus Integration Platform is an ESB based software tool integration product that enables software development in a well-connected tools setup. Kovair Omnibus allows organizations to set up an integrated platform for the entire application development lifecycle. It has the capability of integrating with all different types of legacy, open source, COTS, as well as home-grown tools irrespective of the vendor and technology. This leverages better collaboration among distributed software teams and allows organizations to maintain a single data repository for multiple ALM/SDLC phases and artifacts. Kovair currently has more than 70 integrations with third party tools that are available off-the-shelf. The company has partnered with leading technology brands like Microsoft, IBM, CA, BMC and more to provide customers a wide range of integration solutions. This integration is achieved using Omnibus process engine and Kovair Adapters & Plug-ins for respective tools. Users can also configure Omnibus adapters as per tool specifications and apply custom business rules to meet their integration needs. Kovair Omnibus does not force replacing tried and tested tools with new ones, but allows organizations to maximize the value of their existing tools in their current development setup. Product Highlights: 1. Integration with in-house tools of any organization 2. Integration with both on-premise and cloud based tools 3. Cross-tool data based reports, dashboards in real-time 4. Cross-tool data based traceability for better release predictability 5. Built-in data validation, real-time monitoring of data routing


    LANSA’s data integration software simplifies exchanging data between applications and transferring files and documents between businesses. It enables bi-directional flows of data and/or files in almost any format including XML, text, image, email, PDF, Microsoft Excel, EDI X12 and EDIFACT.


    Mail Attachment Downloader PRO Server adds the ability to run on a Windows Server OS and the ability to run unattended 24x7 as a Windows Service.


    MetaDex is a metadata integration platform which provides end-to-end data lineage. Extend the built-in capabilities of target metadata repositories, i.e., IBM, Informatica, Ab Initio, with ready-to-use lineage extractors for complex multi-vendor environments: Databases (including SQL and Views), ETL, BI, Big Data, and Data Virtualization tools. Customize solution quickly & cost-effectively to extract metadata from additional source technologies whenever necessary.


    OpenLegacy’s iSuite offering is made specifically for IBM System i / AS400 systems. It allows you to extend your system and expose it as REST APIs, web services, a cloud service or even a completely auto-generated single page web application or mobile app.


    QXchange is a flexible, easy to use, data integration software. It can quickly and easily transfer data between many standard data formats and applications, including MS Access, Excel, Comma delimited flat file, MS SQL Server, MySQL, QuickBooks, Salesforce.com and others.


    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.


    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.


    Integrates existing applications, such as SAP and .NET, without coding. Used with webMethods Integration Server. Read more


    Zimbra Converter is a tool designed to convert Zimbra emails, address book, calendar, briefcase from TGZ Files.


    Kate from G2 Crowd

    Learning about On-Premise Data Integration?

    I can help.
    Get FREE professional recommendations in just a few minutes.