{"id":782,"date":"2024-09-25T11:09:34","date_gmt":"2024-09-25T15:09:34","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/data-virtualization\/"},"modified":"2026-05-25T09:40:47","modified_gmt":"2026-05-25T13:40:47","slug":"data-virtualization","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/data-virtualization\/","title":{"rendered":"Data virtualization"},"content":{"rendered":"\n

What is data virtualization?<\/h2>\n\n\n\n

Data virtualization is the process of integrating enterprise data from multiple sources and managing it with centralized security and governance to deliver a single virtual view of real-time data to business users and front-end solutions. Data virtualization is a subset of data integration and is commonly used within business intelligence, service-oriented architecture, data services, cloud computing, enterprise search, and master data management.<\/p>\n\n\n\n

Why use data virtualization?<\/h3>\n\n\n\n

Your organization stores data in various databases, in many formats, across many platforms. Many data sources are in legacy systems, such as Adabas, Db2\u00ae, IMS, VSAM\u2122, and Datacom\u00ae. Data virtualization tools are used to leverage these assets, enabling you to connect, combine, and consume data anywhere in your organization.<\/p>\n\n\n\n

With data virtualization, you can display data from many disparate sources and formats in one application or interface. You can access real-time data from a variety of sources\u2014whether a data warehouse, cloud platform, database or even an Excel\u00ae spreadsheet\u2014in a single virtual view, without the need for duplication.<\/p>\n\n\n\n

Presenting data from legacy, relational, big data, and cloud to users in one place saves time and increases productivity. You can write standard (ANSI) SQL queries against a unified set of real-time data, and you won\u2019t create workloads by moving data around or risking data errors, unlike the traditional ETL process. This means data virtualization solutions can help you maintain data quality. And unlike data federation, you don\u2019t need to impose a single data model on your heterogeneous data. You can also write data updates back to the source systems, using transformation techniques to resolve differences in the source formats.<\/p>\n\n\n\n

Use cases include:<\/h4>\n\n\n\n

Business intelligence and analytics<\/h5>\n\n\n\n

Use data virtualization tools to combine databases across platforms (for example, mainframe, UNIX\u00ae, and cloud) and types (VSAM, relational, and columnar databases) into a single view. Standard (ANSI) SQL queries will direct the system to parse the query into the required syntax, submit the query, and return the result set.<\/p>\n\n\n\n

Application development<\/h5>\n\n\n\n

Developers can more easily build applications that deliver complete and real-time enterprise information to business users. Data virtualization tools reduce the amount of coding required, so developers can focus on delivering information faster and at scale.<\/p>\n\n\n\n

Self-service tools<\/h5>\n\n\n\n

With access to a virtualized dataset, users can run reports, assess performance, analyze data, and run \u201cwhat-if\u201d analyses. These capabilities can accelerate product development, reduce IT overhead, and streamline processes.<\/p>\n\n\n\n

Data warehousing<\/h5>\n\n\n\n

Make sure your data warehouse contains the most up-to-date information across your organization while minimizing impact on underlying systems. Using data virtualization tools, you can harness all the benefits of modern cloud data warehouses. You can replicate your enterprise data from virtually any source to the cloud, capturing changes from single or multiple data sources, without compromising source system uptime and performance.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n\n\n\n

Benefits of data virtualization using CONNX<\/h3>\n\n\n\n

Integrate all your data sources<\/h4>\n\n\n\n

The CONNX data virtualization solution creates a single view of one or more databases and allows real-time access to data as it is updated. CONNX offers 150+ database adapters<\/a>, the industry’s largest range, to deliver standard SQL connectivity to a wide spectrum of databases with a strength in legacy.<\/p>\n\n\n\n

You can virtualize data from a wide spectrum of databases (legacy, relational, big data, and cloud) across platforms such as mainframe, OpenVMS, iSeries (AS\/400), UNIX\u00ae, Linux\u00ae, Windows\u00ae, and desktop. Connect to any ODBC, OLE DB, JDBC\u00ae, J2EE\u00ae, or .NET\u00ae compliant application, report writer, or development tool.<\/p>\n\n\n\n

Gain real-time access<\/h5>\n\n\n\n

Provide your applications and users with real-time access to multiple databases in a single view, regardless of the database type or platform. There is no data movement required, no data latency, and no additional data warehouse or data lakes required.<\/p>\n\n\n\n

Reduce data errors and workload<\/h5>\n\n\n\n

Data virtualization is different from data movement, such as the ETL process. Data virtualization with CONNX can leave your original data intact, whether it\u2019s in a mainframe, legacy, big data, or cloud system, reducing the risk of errors and data loss, as well as workload.<\/p>\n\n\n\n

Preserve full control and flexibility<\/h5>\n\n\n\n

Through metadata management, you create a lexicon that combines all your data into a single, comprehensible structure without altering the source structures.<\/p>\n\n\n\n

Simplify and save on integration projects<\/h5>\n\n\n\n

Use CONNX to simplify SQL data access to legacy and other data sources. Unlock enterprise data everywhere, making it accessible to critical applications, business intelligence systems, and web-enabled front ends. You can do this in a fraction of the time and at a fraction of the cost of conventional in-house development with CONNX.<\/p>\n\n\n\n

Protect sensitive data<\/h5>\n\n\n\n

Manage database logins and secure access to the data in each system.<\/p>\n\n\n\n

Make smarter decisions faster<\/h5>\n\n\n\n

Use insights based on a flow of real-time data from many disparate databases through a single platform.<\/p>\n\n\n\n

Accelerate your shift to digital<\/h5>\n\n\n\n

Leverage your investment in legacy technology. Connecting that data to new data warehouses, web apps, business intelligence tools, big data, and cloud platforms.<\/p>\n\n\n\n

\n\n\n\n \n
\n
\n
<\/h6>\n

You may also like:<\/h2>\n <\/div>\n\n
\n \n
\n \"\"\n <\/div>\n
\n Resource<\/span>\n \n \n schedule\n <\/span>\n 4 MIN read\n <\/span>\n <\/div>\n

Build the next generation of Adabas & Natural experts<\/h3>\n

\n Your most experienced Adabas & Natural practitioners won’t work forever. Turn transition into opportunity.\n <\/p>\n <\/a>\n \n

\n \"an\n <\/div>\n
\n Resource<\/span>\n \n \n schedule\n <\/span>\n 4 MIN read\n <\/span>\n <\/div>\n

Free up capacity for growth<\/h3>\n

\n Software AG\u2019s JOPAZ optimizes mainframe COBOL workloads by redistributing them to zIIP, reclaiming over 80% of capacity for growth and innovation.\n <\/p>\n <\/a>\n \n

\n \"\"\n <\/div>\n
\n Resource<\/span>\n \n \n schedule\n <\/span>\n 5 MIN read\n <\/span>\n <\/div>\n

Data Movement<\/h3>\n

\n Data movement ensures efficient, secure transfer and synchronization across systems, supporting data migration, warehousing, and real-time updates across infrastructures.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\n\n\n\n

\n
\n

Want to make your core applications future-ready?<\/h2>\n\n\n\n

Build on your legacy. Accelerate development in a modern DevOps environment. Modernize your Adabas & Natural applications to save costs and embrace hybrid cloud.<\/p>\n\n\n\n

\n
Speak with an expert<\/a><\/div>\n\n\n\n
Try for free<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Learn about data virtualization and why it\u2019s critical in gaining a single view of real-time data across your organization to power modern business applications.<\/p>\n","protected":false},"featured_media":6402,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-782","resource","type-resource","status-publish","has-post-thumbnail","hentry","product-connx","resource-topic-data-integration","resource-type-datasheet","resource-subdirectory-data-integration"],"acf":[],"yoast_head":"\nWhat is Data Virtualization and Its Benefits? | Software AG<\/title>\n<meta name=\"description\" content=\"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/data-virtualization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data virtualization\" \/>\n<meta property=\"og:description\" content=\"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/data-virtualization\/\" \/>\n<meta property=\"og:site_name\" content=\"Software AG\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SoftwareAG\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-25T13:40:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1880\" \/>\n\t<meta property=\"og:image:height\" content=\"1253\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@softwareag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/\",\"name\":\"What is Data Virtualization and Its Benefits? | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg\",\"datePublished\":\"2024-09-25T15:09:34+00:00\",\"dateModified\":\"2026-05-25T13:40:47+00:00\",\"description\":\"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg\",\"width\":1880,\"height\":1253,\"caption\":\"Photo by Brett Sayles on Pexels.com\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwareag.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.softwareag.com\/br\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data virtualization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"name\":\"Software AG\",\"description\":\"Software AG's digital transformation solutions & services\",\"publisher\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\"},\"alternateName\":\"SAG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwareag.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\",\"name\":\"Software AG\",\"alternateName\":\"SAG\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg\",\"width\":800,\"height\":450,\"caption\":\"Software AG\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SoftwareAG\",\"https:\/\/x.com\/softwareag\",\"https:\/\/www.linkedin.com\/company\/software-ag\",\"https:\/\/www.youtube.com\/user\/SOFTWAREAG\"],\"description\":\"Software AG is a global enterprise software company dedicated to facilitating digital transformation for large-scale organizations. They specialize in modernizing legacy infrastructure, optimizing mainframe operations, and enabling seamless data integration across hybrid environments.\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"501\",\"maxValue\":\"1000\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is Data Virtualization and Its Benefits? | Software AG","description":"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/data-virtualization\/","og_locale":"en_US","og_type":"article","og_title":"Data virtualization","og_description":"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.","og_url":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/data-virtualization\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2026-05-25T13:40:47+00:00","og_image":[{"width":1880,"height":1253,"url":"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@softwareag","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/","name":"What is Data Virtualization and Its Benefits? | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg","datePublished":"2024-09-25T15:09:34+00:00","dateModified":"2026-05-25T13:40:47+00:00","description":"Explore what data virtualization is and how it integrates enterprise data from multiple sources for real-time access.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2024\/09\/pexels-photo-4508745.jpeg","width":1880,"height":1253,"caption":"Photo by Brett Sayles on Pexels.com"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/data-virtualization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwareag.com\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.softwareag.com\/br\/resources\/"},{"@type":"ListItem","position":3,"name":"Data virtualization"}]},{"@type":"WebSite","@id":"https:\/\/www.softwareag.com\/en\/#website","url":"https:\/\/www.softwareag.com\/en\/","name":"Software AG","description":"Software AG's digital transformation solutions & services","publisher":{"@id":"https:\/\/www.softwareag.com\/en\/#organization"},"alternateName":"SAG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwareag.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.softwareag.com\/en\/#organization","name":"Software AG","alternateName":"SAG","url":"https:\/\/www.softwareag.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwareag.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg","width":800,"height":450,"caption":"Software AG"},"image":{"@id":"https:\/\/www.softwareag.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SoftwareAG","https:\/\/x.com\/softwareag","https:\/\/www.linkedin.com\/company\/software-ag","https:\/\/www.youtube.com\/user\/SOFTWAREAG"],"description":"Software AG is a global enterprise software company dedicated to facilitating digital transformation for large-scale organizations. They specialize in modernizing legacy infrastructure, optimizing mainframe operations, and enabling seamless data integration across hybrid environments.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"501","maxValue":"1000"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/types\/resource"}],"version-history":[{"count":18,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/782\/revisions"}],"predecessor-version":[{"id":9359,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/782\/revisions\/9359"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media\/6402"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media?parent=782"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/product?post=782"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-industry?post=782"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-topic?post=782"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-type?post=782"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-subdirectory?post=782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}