Download Buy

How to compare two Oracle tables using dbForge Tools?

This tutorial describes database diff tool for Oracle table data. Read and make sure how easy you can compare Oracle tables with dbForge Data Compare for Oracle. Click the screenshots for details.

1. Opening Data Comparison Wizard

Click New Data Comparison on the Start page to launch Data Comparison Wizard. You can also start other common tasks in one click without searching a required command in the menu.

Tip: To open previous comparison projects, double-click them.

2. Selecting database connections

To create a database connection, click the New button in the wizard. The Database Connection Properties window appears. You can use either a direct or Oracle client connection.

Select the Direct check box to connect directly. Specify host, SID, port, user and password to connect to the Oracle server. Click OK to finish the creation. Now you can select this connection in the drop-down list of the Connection field on Data Comparison Wizard.

3. Selecting Source and Target for comparison

Source is the database which contents is inserted to Target after synchronization. Target is the database which contents you compare and synchronize with Source. Click the Connection fields and select required connections for Source and Target from the drop-down list.

Tip: To swap Source and Target, click the swap button. To set up custom mapping, click the Next button. To start the comparison, click Compare.

4. Selecting comparison options

You can customize comparison behavior, e.g., to ignore some objects or properties. Go to the Options wizard page and select required check boxes.

Tip: Save the comparison settings as a command line arguments file by clicking the link at the top. Later you can use this file for automatic comparison and synchronization through command line.

Tip: To save the current selection of options as your defaults, click the Save As My Defaults button.

5. Custom objects mapping

dbForge Data Compare offers both automatic and manual (custom) mapping. Use custom mapping to map tables, columns, and views that cannot be mapped automatically.

Tip: To discard custom mapping and restore to the default one, click the Reset button.

Mapping tables and views

Map tables and views with a different data structure manually in several clicks.

Click the Map Objects button and select Source and Target objects in the open window, then click OK. The selected pair of objects will appear in the grid on the Mapping wizard page and be compared.

Tip: To map multiple pairs of Source and Target objects without closing and opening the window many times, click the Map button after the first selected pair of objects. When you manually select all required objects, click OK to see them in the grid on the Mapping wizard page.

Mapping columns

See how many columns of each object can be compared in the Columns in Comparison field of the grid.

Click the ellipsis button for the required object. The open window will show all the columns (and their details) of the selected object.

Automatically mapped columns are marked with the green icon. Incompatible columns are marked with the red icon. Select required Target columns from the drop-down list and click OK.

Mapping custom queries

Map the results of custom queries.

Click the Custom Query button and write the needed queries for Source and Target in the corresponding SQL fields. You can select to map query result with a table. Click Map to perform mapping and OK to close the window.

Tip: To validate queries, click the Validate button or select the Validate item from the context menu in the needed SQL field.

6. Analyzing comparison results

See the full info about compared objects in the data comparison document. The top grid shows all the compared objects. The bottom grid shows the records of the selected object, automatically grouped by status - Identical, Different, Only in Source, and Only in Target.

Select required objects or separate records of objects to synchronize.

Tip: For better understanding, filter the objects in the top grid, e.g., to see Only in Source objects.

7. Synchronizing data

Use Data Synchronization Wizard to generate a standards-driven synchronization script and tune the synchronization result based on your needs. Click the Synchronize button to immediately generate the synchronization script.

Tip: To customize synchronization, click Next and move to other wizard pages.

On the Options wizard page, customize the synchronization by applying various options.

To see the synchronization actions and the list of warnings generated during mapping, move to the Summary wizard page.

On the Summary wizard page, check the synchronization action plan and the list of warnings generated during mapping.

After Data Synchronization Wizard work is completed, the synchronization script will be opened. Click the Execute button on the toolbar to execute it.

8. SQL script management

Use SQL editor to view and edit synchronization scripts, create queries and execute them against the selected database.

Click the New SQL button to open SQL editor.

Tip: When the query is executed, see the query results in the Data window that opens. Find rich data management options in the right-click menu.

Summary

This tutorial has shown how you can easily compare data in Oracle tables and see differences. Go through individual records or group them together. Create errorless SQL scripts to deploy data modifications between your environments.

Products
Support
Company
  • FREE Products

    FREE Products

    A set of tools distributed free of charge

  • SQL Server Tools

    SQL Server Tools

    Must-have tools for SQL Server database development, management and administration.

  • SSMS Add-ins

    SSMS Add-ins

    Plugins that add missing features to SQL Server Management Studio and improve your productivity while working with Microsoft SQL Server.

  • MySQL Tools

    MySQL Tools

    Must-have tools for MySQL database development, management and administration.

  • Oracle Tools

    Oracle Tools

    Must-have tools for Oracle database development, management and administration.

  • PostgreSQL Tools

    PostgreSQL Tools

    Must-have tools for PostgreSQL database development, management and administration.

  • ADO.NET Providers for Databases

    ADO.NET Providers for Databases

    An enhanced data connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.

  • ADO.NET Providers for Clouds

    ADO.NET Providers for Clouds

    The fastest way to create .NET applications, working with cloud data.

  • ODBC Drivers for Databases

    ODBC Drivers for Databases

    Drivers provide the Direct access to custom databases, which eliminates the use of database client libraries, simplifies the deployment process, and extends your application capabilities

  • ODBC Drivers for Clouds

    ODBC Drivers for Clouds

    Drivers provide the Direct access to custom cloud databases, which eliminates the use of database client libraries, simplifies the deployment process, and extends your application capabilities

  • SSIS Data Flow Components

    SSIS Data Flow Components

    A set of components for SQL Server Integration Services (SSIS) packages that provides easy to set up cost-effective data integration using SSIS ETL engine. Our components offer high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.

  • Excel Add-ins for Databases

    Excel Add-ins for Databases

    Excel add-ins that allow you to work with database data in Microsoft Excel as with usual Excel spreadsheets.

  • Excel Add-ins for Cloud Apps

    Excel Add-ins for Cloud Apps

    Excel add-ins that allow you to work with cloud data in Microsoft Excel as with usual Excel spreadsheets.

  • Delphi Data Access Components

    Delphi Data Access Components

    Data Access Components for Delphi, C++Builder, and Lazarus

  • dbExpress Drivers

    dbExpress Drivers

    A database-independent layer that defines common interface to provide fast access to SQL database servers from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms

  • Productivity Tools

    Productivity Tools

    A set of tools that help developers to write code, conduct code reviews, compare sources, track the working hours with the web application and much more.

  • ORM Solutions

    ORM Solutions

    A set of tools that are dedicated to producing software targeting the Object-Role Modelling methodology

  • Data Services

    Data Services

    All-in-one cloud service that allows you to integrate, back up, access, and manage your cloud data.

  • SQL Decryptor

    SQL Decryptor

    A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.

    Download
  • Event Profiler for SQL Server

    Event Profiler for SQL Server

    Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.

    Download
  • Search

    Search

    A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.

    Download
  • SQL Formatter

    SQL Formatter

    Free on-line tool for SQL code formatting.

    Learn more
  • T4 Editor

    T4 Editor

    An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.

    Download
  • dbMonitor

    dbMonitor

    The tool provides visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components etc.

    Download
  • dbForge Studio for SQL Server

    dbForge Studio for SQL Server

    A powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, speed up routine tasks, as well, as to make complex database changes.

    Buy Download
  • Developer Bundle for SQL Server

    Developer Bundle for SQL Server

    Take a full control over database development and management with dbForge Developer Bundle for SQL Server with sensational discount in comparison with bying tools separately.

    Buy Download
  • Compare Bundle for SQL Server

    Compare Bundle for SQL Server

    Grab the full power to handle changes in your databases with dbForge Compare Bundle for SQL Server. It will save you hours of work comparing and deploying SQL Server databases.

    Buy Download
  • Schema Compare for SQL Server

    Schema Compare for SQL Server

    Tool for quick and safe schema comparison and synchronization, easy analysis of database structure differences, and deployment of changes to a required SQL Server.

    Buy Download
  • Data Compare for SQL Server

    Data Compare for SQL Server

    Tune your SQL database comparison, quickly analyze differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard.

    Buy Download
  • Data Generator for SQL Server

    Data Generator for SQL Server

    Convenient and easy-to-use GUI tool for a fast generation of large volumes of SQL Server test table data. The tool includes a huge collection of predefined generators with sensible configuration options.

    Buy Download
  • Documenter for SQL Server

    Documenter for SQL Server

    A tool for automatic generation of documentation for SQL Server databases. The tool supports HTML and PDF formats and allows configuring generation on multiple levels.

    Buy Download
  • Query Builder for SQL Server

    Query Builder for SQL Server

    Tool for visual creation of any queries without code typing. Includes lots of innovative options for extended query results management.

    Buy Download
  • Event Profiler for SQL Server

    Event Profiler for SQL Server

    Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.

    Download
  • SQL Decryptor

    SQL Decryptor

    A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.

    Download
  • dbForge Fusion for SQL Server

    dbForge Fusion for SQL Server

    Visual Studio plugin for database development and administration tasks. Explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different ways.

    Buy Download
  • SQL Formatter

    SQL Formatter

    Free on-line tool for SQL code formatting.

    Learn more
  • Developer Bundle for SQL Server

    Developer Bundle for SQL Server

    Take a full control over database development and management with dbForge Developer Bundle for SQL Server with sensational discount in comparison with bying tools separately.

    Buy Download
  • SQL Complete

    SQL Complete

    An add-in for SSMS and Visual Studio. The tool includes a wide range of code completion, formatting, and refactoring features for quick and high-quality coding.

    Buy Download
  • Source Control

    Source Control

    A powerful SSMS add-in for managing SQL Server database changes in popular source control systems, delivering smooth workflow in a familiar interface.

    Buy Download
  • Unit Test

    Unit Test

    An intuitive and convenient GUI for implementing automated unit testing based on the open-source tSQLt framework in SQL Server Management Studio.

    Buy Download
  • Data Pump

    Data Pump

    An SSMS add-in for filling SQL databases with external source data and migrating data between systems, supporting 10+ widely used data formats.

    Buy Download
  • Index Manager

    Index Manager

    A handy SSMS add-in for analyzing the status of SQL indexes, fixing issues with index fragmentation, and detecting databases that require maintanance.

    Buy Download
  • Search

    Search

    A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.

    Download
  • dbForge Studio for MySQL

    dbForge Studio for MySQL

    MySQL and Maria DB management tool with well-designed GUI for easy database development and administration. Get the basic functionality of the MySQL and MariaDB front end management tool for free.

    Buy Download
  • Compare Bundle for MySQL

    Compare Bundle for MySQL

    Set of tools for comparison and deployment of any MySQL and MariaDB schema or data changes. Get dbForge Schema Compare for MySQL and Maria DB, and dbForge Data Compare for MySQL products and save about 25%.

    Buy Download
  • Schema Compare for MySQL

    Schema Compare for MySQL

    GUI tool for quick and easy MySQL and MariaDB database schema comparison and synchronization. It will help you analyze database structure differences, and effectively propagate changes to a required MySQL Server.

    Buy Download
  • Data Compare for MySQL

    Data Compare for MySQL

    MySQL and MariaDB GUI tool for quick and easy data comparison and synchronization. Get a convenient way to manage data differences in a well-designed user interface, and customize synchronization.

    Buy Download
  • Data Generator for MySQL

    Data Generator for MySQL

    A powerful GUI tool for generation of massive volumes of test data to populate MySQL database tables. The tool provides a great choice of meaningful generators that yield real-word data.

    Buy Download
  • Query Builder for MySQL

    Query Builder for MySQL

    Visual tool for creating queries of any complexity without code typing. The tool provides a great amount of options to extend query results management.

    Buy Download
  • dbForge Fusion for MySQL

    dbForge Fusion for MySQL

    Microsoft Visual Studio plugin for simplifying all MySQL and MariaDB database development and administration tasks in your favorite IDE.

    Buy Download
  • dbForge Studio for Oracle

    dbForge Studio for Oracle

    IDE for easy development and maintenance of Oracle databases. The tool provides capabilities to browse and edit database objects, debug PL/SQL statements, run SQL statements, edit and export table data, and sync databases.

    Buy Download
  • Compare Bundle for Oracle

    Compare Bundle for Oracle

    Set of tools for comparison and deployment of any Oracle schema or data changes. Get dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle products and save about 25%.

    Buy Download
  • Schema Compare for Oracle

    Schema Compare for Oracle

    Tool for safe comparison and synchronization of database schemas, easy analysis of database structure differences and deployment of changes to a required Oracle server.

    Buy Download
  • Data Compare for Oracle

    Data Compare for Oracle

    Tool for safe and efficient comparison and synchronization of Oracle data, convenient data differences management in a well-designed interface. Get the basic functionality for free.

    Buy Download
  • Data Generator for Oracle

    Data Generator for Oracle

    A GUI tool for populating Oracle schemas with tons of meaningful test data. The tool includes a vast collection of meaningful generators and supports all Oracle versions.

    Buy Download
  • dbForge Fusion for Oracle

    dbForge Fusion for Oracle

    Microsoft Visual Studio plugin that allows you to accomplish all database development and administration tasks in your favorite IDE easily.

    Buy Download
  • Data Compare for PostgreSQL

    Data Compare for PostgreSQL

    The tool for PostgreSQL is intended for quick and safe data comparison and synchronization, convenient management of data differences in a well-designed user interface, and customizable synchronization.

    Buy Download
  • dotConnect for Oracle

    dotConnect for Oracle

    An enhanced ORM enabled data provider for Oracle with Direct connection mode (no need for OCI) and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for MySQL

    dotConnect for MySQL

    An enhanced enhanced ORM enabled data provider MySQL built over ADO.NET architecture. It supports Entity Framework and LinqConnect ORMs and includes its own ORM model designer – Entity Developer.

    Buy Download
  • dotConnect for PostgreSQL

    dotConnect for PostgreSQL

    An enhanced database connectivity solution for PostgreSQL built over ADO.NET architecture and a development framework with a number of innovative technologies and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for SQLite

    dotConnect for SQLite

    An enhanced database connectivity solution for SQLite built over ADO.NET architecture and a development framework with a number of innovative technologies and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for DB2

    dotConnect for DB2

    An enhanced data provider built on ADO.NET technology and IBM DB2 .NET Data Provider, that provides advanced Entity Framework support along with it's own ORM Model designer, and other useful tools and features.

    Buy Download
  • dotConnect for SQL Server

    dotConnect for SQL Server

    A database connectivity solution for SQL Server built over ADO.NET architecture and a development framework with number of innovative technologies.

    Buy Download
  • dotConnect Universal

    dotConnect Universal

    A universal ADO.NET provider for access to data of different databases for the Microsoft .NET Framework.

    Buy Download
  • ODBC Driver for SQL Server

    ODBC Driver for SQL Server

    Devart ODBC Driver for SQL Server provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Server databases directly, avoiding SQL Server Native Client, from Windows, MacOS, Linux, both 32-bit and 64-bit.

    Buy Download
  • ODBC Driver for SQL Azure

    ODBC Driver for SQL Azure

    Devart ODBC Driver for SQL Azure provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Azure databases directly, avoiding SQL Azure native client software, from Windows, MacOS, Linux, both 32-bit and 64-bit, directly via TCP/IP avoiding SQL Server Native Client

    Buy Download
  • ODBC Driver for Oracle

    ODBC Driver for Oracle

    Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases directly, avoiding Oracle Client, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MySQL

    ODBC Driver for MySQL

    Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases directly, avoiding MySQL client library, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for PostgreSQL

    ODBC Driver for PostgreSQL

    Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases directly, avoiding PostgreSQL native client software, from from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Firebird

    ODBC Driver for Firebird

    Devart ODBC Driver for Firebird provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Firebird databases from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for InterBase

    ODBC Driver for InterBase

    Devart ODBC Driver for InterBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access InterBase databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for SQLite

    ODBC Driver for SQLite

    Devart ODBC Driver for SQLite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQLite databases directly, by linking SQLite library statically into application, from Windows, MacOS, Linux, both 32-bit and 64-bit. ODBC Driver for SQLite also provides SQLite DB encryption to protect your data from unauthorized access.

    Buy Download
  • ODBC Driver for ASE

    ODBC Driver for ASE

    Devart ODBC Driver for SAP Sybase Adaptive Server Enterprise provides high-performance and feature-rich connectivity solution for ODBC-based applications to access ASE databases directly, avoiding ASE client software, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MongoDB

    ODBC Driver for MongoDB

    Devart ODBC Driver for MongoDB provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MongoDB databases from Windows, MacOS, Linux. ODBC Driver for MongoDB fully supports MongoDB data types and allows using SQL queries to manipulate MongoDB data.

    Buy Download
  • ODBC Driver for Salesforce

    ODBC Driver for Salesforce

    Devart ODBC Driver for Salesforce provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce.com, Force.com cloud CRM and Database.com cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Salesforce MC

    ODBC Driver for Salesforce MC

    Devart ODBC Driver for Salesforce Marketing Cloud (formerly known as ExactTarget) provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce Marketing Cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Dynamics CRM

    ODBC Driver for Dynamics CRM

    Devart ODBC Driver for Dynamics CRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Dynamics CRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for SugarCRM

    ODBC Driver for SugarCRM

    Devart ODBC Driver for SugarCRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SugarCRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Zoho CRM

    ODBC Driver for Zoho CRM

    Devart ODBC Driver for Zoho CRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Zoho CRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for QuickBooks

    ODBC Driver for QuickBooks

    Devart ODBC Driver for QuickBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access QuickBooks cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for FreshBooks

    ODBC Driver for FreshBooks

    Devart ODBC Driver for FreshBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access FreshBooks cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MailChimp

    ODBC Driver for MailChimp

    Devart ODBC Driver for MailChimp provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MailChimp cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for BigCommerce

    ODBC Driver for BigCommerce

    Devart ODBC Driver for BigCommerce provides high-performance and feature-rich connectivity solution for ODBC-based applications to access BigCommerce cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Magento

    ODBC Driver for Magento

    Devart ODBC Driver for Magento provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Magento cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for NetSuite

    ODBC Driver for NetSuite

    Devart ODBC Driver for NetSuite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access NetSuite cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • SSIS Components for Salesforce

    SSIS Components for Salesforce

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Dynamics CRM

    SSIS Components for Dynamics CRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Zoho CRM

    SSIS Components for Zoho CRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for SugarCRM

    SSIS Components for SugarCRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for QuickBooks

    SSIS Components for QuickBooks

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for MailChimp

    SSIS Components for MailChimp

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Salesforce Marketing Cloud

    SSIS Components for Salesforce Marketing Cloud

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for BigCommerce

    SSIS Components for BigCommerce

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Magento

    SSIS Components for Magento

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for FreshBooks

    SSIS Components for FreshBooks

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Oracle

    SSIS Components for Oracle

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for MySQL

    SSIS Components for MySQL

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for PostgreSQL

    SSIS Components for PostgreSQL

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for DB2

    SSIS Components for DB2

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • Excel Add-in Universal Pack

    Excel Add-in Universal Pack

    Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.

    Learn more
  • Excel Add-in Database Pack

    Excel Add-in Database Pack

    Devart Excel Add-ins Database Pack includes Excel Add-ins that allow working with database data like with usual worksheets. It includes add-ins for DB2, MySQL, Oracle, PostgreSQL, SQL Server, SQLite.

    Learn more
  • Excel Add-in for Oracle

    Excel Add-in for Oracle

    Excel add-in that allows you to connect Microsoft Excel to Oracle, quickly and easily load data from Oracle to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to Oracle

    Learn more
  • Excel Add-in for SQL Server

    Excel Add-in for SQL Server

    Excel add-in that allows you to connect Microsoft Excel to SQL Server or SQL Azure, easily load data from SQL Server or SQL Azure to Excel, refresh data in an Excel workbook from the database, edit these data, and save them back to SQL Server

    Learn more
  • Excel Add-in for MySQL

    Excel Add-in for MySQL

    Excel add-in that allows you to connect Microsoft Excel to MySQL or MariaDB, quickly load data from MySQL or MariaDB to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to MySQL

    Learn more
  • Excel Add-in for PostgreSQL

    Excel Add-in for PostgreSQL

    Excel add-in that allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL

    Learn more
  • Excel Add-in for SQLite

    Excel Add-in for SQLite

    Excel add-in that you to connect Microsoft Excel to an SQLite database, quickly and easily load data from an SQLite database to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to the database

    Learn more
  • Excel Add-in for DB2

    Excel Add-in for DB2

    Excel add-in that allows you to connect Microsoft Excel to DB2, quickly and easily load data from DB2 to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to DB2

    Learn more
  • Excel Add-in Universal Pack

    Excel Add-in Universal Pack

    Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.

    Learn more
  • Excel Add-in Cloud Pack

    Excel Add-in Cloud Pack

    Devart Excel Add-ins Cloud Pack includes Excel Add-ins that allow you to work with data of various cloud apps like with usual worksheets and save changes to these data back to the cloud app.

    Learn more
  • Excel Add-in for BigCommerce

    Excel Add-in for BigCommerce

    Excel add-in that allows you to connect Microsoft Excel to BigCommerce, easily load data from BigCommerce to Excel, instantly refresh data in an Excel workbook from BigCommerce, edit these data, and save them back to BigCommerce

    Learn more
  • Excel Add-in for Dynamics CRM

    Excel Add-in for Dynamics CRM

    Excel add-in that allows you to connect Microsoft Excel to Microsoft Dynamics CRM, load data from Dynamics CRM to Excel, refresh data in an Excel workbook from Dynamics CRM, edit these data, and save them back to Dynamics CRM

    Learn more
  • Excel Add-in for FreshBooks

    Excel Add-in for FreshBooks

    Excel add-in that allows you to connect Microsoft Excel to FreshBooks, easily load data from FreshBooks to Excel, instantly refresh data in an Excel workbook from FreshBooks, edit these data, and save them back to FreshBooks

    Learn more
  • Excel Add-in for Freshdesk

    Excel Add-in for Freshdesk

    Excel add-in that allows you to connect Microsoft Excel to Freshdesk, easily load data from Freshdesk to Excel, instantly refresh data in an Excel workbook from Freshdesk, edit these data, and save them back to Freshdesk

    Learn more
  • Excel Add-in for G Suite

    Excel Add-in for G Suite

    Excel add-in that allows you to connect Microsoft Excel to G Suite, easily load data from G Suite to Excel, instantly refresh data in an Excel workbook from G Suite, edit these data, and save them back to G Suite

    Learn more
  • Excel Add-in for HubSpot

    Excel Add-in for HubSpot

    Excel add-in that allows you to connect Microsoft Excel to HubSpot, easily load data from HubSpot to Excel, instantly refresh data in an Excel workbook from HubSpot, edit these data, and save them back to HubSpot

    Learn more
  • Excel Add-in for Magento

    Excel Add-in for Magento

    Excel add-in that allows you to connect Microsoft Excel to Magento, quickly and easily load data from Magento to Excel, instantly refresh data in an Excel workbook from Magento, edit these data, and save them back to Magento

    Learn more
  • Excel Add-in for MailChimp

    Excel Add-in for MailChimp

    Excel add-in that allows you to connect Microsoft Excel to MailChimp, quickly and easily load data from MailChimp to Excel, instantly refresh data in an Excel workbook from MailChimp, edit these data, and save them back to MailChimp

    Learn more
  • Excel Add-in for Marketo

    Excel Add-in for Marketo

    Excel add-in that allows you to connect Microsoft Excel to Marketo, quickly and easily load data from Marketo to Excel, instantly refresh data in an Excel workbook from Marketo, edit these data, and save them back to Marketo

    Learn more
  • Excel Add-in for NetSuite

    Excel Add-in for NetSuite

    Excel add-in that allows you to connect Microsoft Excel to NetSuite, quickly and easily load data from NetSuite to Excel, instantly refresh data in an Excel workbook from NetSuite, edit these data, and save them back to NetSuite

    Learn more
  • Excel Add-in for QuickBooks

    Excel Add-in for QuickBooks

    Excel add-in that allows you to connect Microsoft Excel to QuickBooks Online, easily load data from QuickBooks to Excel, refresh data in an Excel workbook from QuickBooks, edit these data, and save them back to QuickBooks

    Learn more
  • Excel Add-in for Salesforce

    Excel Add-in for Salesforce

    Excel add-in that allows you to connect Microsoft Excel to Salesforce, quickly and easily load data from Salesforce to Excel, instantly refresh data in an Excel workbook from Salesforce, edit these data, and save them back to Salesforce

    Learn more
  • Excel Add-in for Salesforce Marketing Cloud

    Excel Add-in for Salesforce Marketing Cloud

    Excel add-in that allows you to connect Microsoft Excel to Salesforce Marketing Cloud, easily load data from Salesforce Marketing Cloud to Excel, instantly refresh data in an Excel workbook from Salesforce Marketing Cloud, edit these data, and save them back to Salesforce Marketing Cloud

    Learn more
  • Excel Add-in for Shopify

    Excel Add-in for Shopify

    Excel add-in that allows you to connect Microsoft Excel to Shopify, quickly and easily load data from Shopify to Excel, instantly refresh data in an Excel workbook from Shopify, edit these data, and save them back to Shopify

    Learn more
  • Excel Add-in for SugarCRM

    Excel Add-in for SugarCRM

    Excel add-in that allows you to connect Microsoft Excel to SugarCRM, quickly and easily load data from SugarCRM to Excel, instantly refresh data in an Excel workbook from SugarCRM, edit these data, and save them back to SugarCRM

    Learn more
  • Excel Add-in for Zendesk

    Excel Add-in for Zendesk

    Excel add-in that allows you to connect Microsoft Excel to Zendesk, quickly and easily load data from Zendesk to Excel, instantly refresh data in an Excel workbook from Zendesk, edit these data, and save them back to Zendesk

    Learn more
  • Excel Add-in for Zoho CRM

    Excel Add-in for Zoho CRM

    Excel add-in that allows you to connect Microsoft Excel to Zoho CRM, quickly and easily load data from Zoho CRM to Excel, instantly refresh data in an Excel workbook from Zoho CRM, edit these data, and save them back to Zoho CRM

    Learn more
  • EntityDAC

    EntityDAC

    EntityDAC is an ORM for Delphi with LINQ support. It provides a powerful framework that allows to perform object-relational mapping of database objects to Delphi classes with full support for encapsulation, inheritance, polymorphism and other OOP features. To retrieve data from a database, LINQ is used as a database independent query engine. In addition, there is a feature-rich ORM modeling tool available – Entity Developer, that allows to create and edit your ORM models visually, and generate Delphi entity classes by this model automatically.

    Buy Download
  • UniDAC

    UniDAC

    Universal Data Access Components (ODAC) is a powerful tool for developing cross-database client/server applications in Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. UniDAC provides a unified interface to access popular database servers such as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and more other databases.

    Buy Download
  • ODAC

    ODAC

    Being a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, Oracle Data Access Components (ODAC) aims to assist programmers in developing of fast and native Oracle applications. It provides both possibility of connection to Oracle by means of native Oracle data access and directly via TCP/IP without involving Oracle Client.

    Buy Download
  • SDAC

    SDAC

    Being a feature-rich and high-performance library of components that provides direct and native connectivity to SQL Server from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQL Server Data Access Components (SDAC) aims to assist programmers in developing of fast and native SQL Server database applications. It provides both possibility of connection to SQL Server by means of native SQL Server data access and directly via TCP/IP without involving SQL Server Native Client.

    Buy Download
  • MyDAC

    MyDAC

    Being a feature-rich and high-performance library of components that provides direct access to MySQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, MySQL Data Access Components (MyDAC) aims to assist programmers in developing of fast and native MySQL applications. It provides an additional opportunity to work with MySQL directly via TCP/IP without involving MySQL client library.

    Buy Download
  • IBDAC

    IBDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to InterBase and Firebird from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, InterBase and Firebird Data Access Components (IBDAC) aims to assist programmers in developing of fast and native Interbase and Firebird applications. IBDAC-based applications connect to the server directly using the InterBase or Firebird client.

    Buy Download
  • PgDAC

    PgDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, PostgreSQL Data Access Components (PgDAC) aims to assist programmers in developing of fast and native PostgreSQL applications. It provides opportunity to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client.

    Buy Download
  • LiteDAC

    LiteDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to SQLite from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQLite Data Access Components (LiteDAC) aims to assist programmers in developing of fast and native SQLite applications. LiteDAC provides an opportunity to work with SQLite directly by static linking of SQLite library in an application. To protect your data from unauthorized access, LiteDAC provides a powerful and customizable SQLite Database Encryption engine.

    Buy Download
  • VirtualDAC

    VirtualDAC

    VirtualDAC (formerly known as VirtualTable) consists of components - TVirtualQuery, TVirtualTable and TVirtualDataSet - that provide such capabilities as working with non-tabular data, performing SQL-queries to data in memory or to data from sources in different RDBMS'es etc., that are not available for standard data access components.

    Buy Download
  • dbExpress Driver for Oracle

    dbExpress Driver for Oracle

    dbExpress is a database-independent layer that defines common interface to provide direct access to Oracle from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using Oracle Client, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for SQL Server

    dbExpress Driver for SQL Server

    dbExpress is a database-independent layer that defines common interface to provide direct access to SQL Server from Delphi and C++Builder on Windows for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using SQL Server Native Client, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for MySQL

    dbExpress Driver for MySQL

    dbExpress is a database-independent layer that defines common interface to provide direct access to MySQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using MySQL client library, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for InterBase and Firebird

    dbExpress Driver for InterBase and Firebird

    dbExpress is a database-independent layer that defines common interface to provide fast access to InterBase and Firebird from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms

    Buy Download
  • dbExpress Driver for PostgreSQL

    dbExpress Driver for PostgreSQL

    dbExpress is a database-independent layer that defines common interface to provide direct access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using PostgreSQL client software, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for SQLite

    dbExpress Driver for SQLite

    dbExpress Driver for SQLite is a database-independent layer that defines common interface to provide direct access to SQLite from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. SQLite library is statically linked into developed applications, that increases application performance and simplyfies deployment process. dbExpress Driver for SQLite also has support for SQLite database encryption to protect your data from unauthorized access.

    Buy Download
  • Code Review Bundle

    Code Review Bundle

    Code Compare adds value to Review Assistant when tools are used together. That's why they are sold in code review bundle. Buying the bundle saves you money on both tools.

    Learn more
  • Review Assistant

    Review Assistant

    A peer code review tool for Visual Studio. The tool includes lightweight support for formal code review, allows defect and discussion tracking, integrates with code comparison tools and version control systems to facilitate working with code changes.

    Buy Download
  • Code Compare

    Code Compare

    A popular comparison tool for file and folder comparison and merging, Code Compare takes into account specifics of programming languages (C#, Visual Basic, XML, XAML, etc.), supports two- and three- way comparison and merge.

    Buy Download
  • T4 Editor

    T4 Editor

    An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.

    Download
  • SecureBridge

    SecureBridge

    SecureBridge is a library of Delphi and C++Builder components for Windows, MacOS, iOS, Android, Linux, FreeBSD, both 32-bit and 64-bit, designed to protect connections between computers and trusted networks against unauthorized access.

    Buy Download
  • dbMonitor

    dbMonitor

    The tool provides visual monitoring of your database applications. It performs per-component tracing of database events: commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.

    Download
  • TMetric

    TMetric

    TMetric is a time tracking web application for IT-professionals and companies. The tool will help individuals and organizations to be more productive. TMetric provides time tracking, work session monitoring, reporting tools, integrations and more.

    Learn more
  • Entity Developer

    Entity Developer

    A powerful modelling and code generation tool for ADO.NET Entity Framework, NHibernate, Telerik Data Access, LinqConnect, and LINQ to SQL

    Buy Download
  • LINQ Insight

    LINQ Insight

    A Visual Studio add-in that allows you to execute LINQ queries at design time directly from Visual Studio without starting a debug session and provides a powerful ORM profiler for Entity Framework, NHibernate, LINQ to SQL, and LinqConnect.

    Buy Download
  • LinqConnect

    LinqConnect

    A fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology

    Buy Download
  • Data Integration

    Data Integration

    Wizard-based integration with no effort, no coding, and no need for special knowledge, performed completely in a cloud

    Learn more
  • Backup

    Backup

    Automatic daily and anytime manual cloud backup with search, view, and export of backed up data and one-click data restore.

    Learn more
  • Query

    Query

    Online SQL editor with visual Query Builder tool to query and manage data with SQL and view them in a grid or as charts.

    Learn more
  • Connect

    Connect

    Connectivity-as-a-service solution that provides standard OData interface to connect to various data sources.

    Learn more