{"id":798,"date":"2024-11-05T21:54:23","date_gmt":"2024-11-06T01:54:23","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-ims\/"},"modified":"2025-12-20T16:01:11","modified_gmt":"2025-12-20T20:01:11","slug":"connx-db-adapter-ims","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-ims\/","title":{"rendered":"CONNX DB Adapter for IMS\u2122"},"content":{"rendered":"\n

Join IMS with multiple data sources<\/h2>\n\n\n\n

In conjunction with other products in the CONNX suite, you can perform seamless joins between two or more supported disparate databases using ODBC, OLE DB, .NET and JDBC\u00ae<\/sup>. CONNX for IMS is fast and efficient. With CONNX<\/a>, a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access. To the user or application, data appears as if it existed in a single federated relational database.<\/p>\n\n\n\n

SQL & CONNX for IMS<\/h2>\n\n\n\n

The CONNX distributed SQL engine reduces the workload placed on the mainframe by performing CPU-intensive operations where the CONNX client resides (Linux\u00ae<\/sup> or Windows\u00ae<\/sup>, i.e., remote desktop, web and\/or application server). The database calls are low level and minimize impact on the system. CONNX directly imports IMS metadata from the IMS Database Descriptions (DBDs). CONNX supports ANSI SQL (Insert, Update, Select and Delete); group by, distinct, aggregate (AVG, MIN, MAX, SUM and COUNT), and all substring, string, date, conversion and math functions. Nested inner and outer left\/right joins are supported, as well as subqueries and correlated subqueries. CONNX also supports Unions and Insert\/Select.<\/p>\n\n\n\n

Key Features<\/h2>\n\n\n\n

Views<\/h5>\n\n\n\n

CONNX supports the creation of views, which facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases.<\/p>\n\n\n\n

Data conversions<\/h5>\n\n\n\n

CONNX supports more than 600 data types and performs bi-directional data conversions for data updates and retrieves. <\/p>\n\n\n\n

Security preserved and extended<\/h5>\n\n\n\n

The CONNX Data Dictionary (CDD) is encrypted to secure sensitive information. It provides additional field and table-level security by group or user. CONNX also supports row level security with CONNX Views. <\/p>\n\n\n\n

Table redefinition<\/h5>\n\n\n\n

The CDD supports multiple record layouts of the same IMS file, based on a \u201crecord type\u201d field.<\/p>\n\n\n\n

Record definition import<\/h5>\n\n\n\n

CONNX imports table definitions directly from IMS databases.<\/p>\n\n\n\n

\n
Learn more about DB Adapters<\/a><\/div>\n<\/div>\n\n\n\n
\n

Take the next step:<\/h2>\n\n\n\n
\n
\n
\"\"<\/figure>\n\n\n\n
Demo<\/h6>\n\n\n\n

Schedule a demo with a mainframe modernization expert<\/h4>\n\n\n\n

See how you can access, virtualize or move your mainframe data. Get a live demo of CONNX with one of our product experts.<\/p>\n\n\n\n

\n
Schedule demo<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
TECH COMMUNITY<\/h6>\n\n\n\n

Join the Software AG Tech Community<\/h4>\n\n\n\n

Collaborate with the CONNX community\u2014and get tips and tricks, test code, and downloads\u2014to help you extend your CONNX solutions into the future.<\/p>\n\n\n\n

\n
Try now<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
ON-DEMAND WEBINARS<\/h6>\n\n\n\n

Browse our library of webinars<\/h4>\n\n\n\n

All of our webinars are available to watch on demand. Join mainframe modernization experts and analysts as they discuss, elaborate and demonstrate best practices.<\/p>\n\n\n\n

\n
Watch now<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

Are you ready to unite cloud and mainframe data?<\/h2>\n\n\n\n

Become a data-driven organization by leveraging all the information in your enterprise, however it\u2019s structured\u2014without changing your core systems.  <\/p>\n\n\n\n

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

Meet all of your data access, integration and management requirements. Create a single view of multiple databases and allow real-time access to consume the data as it is being updated in real time.<\/p>\n","protected":false},"featured_media":799,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-798","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":"\nDB Adapter for IMS: Streamline Your Database Access | Software AG<\/title>\n<meta name=\"description\" content=\"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.\" \/>\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\/connx-db-adapter-ims\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONNX DB Adapter for IMS\u2122\" \/>\n<meta property=\"og:description\" content=\"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-ims\/\" \/>\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=\"2025-12-20T20:01:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"CONNX DB Adapter for IMS\u2122\" \/>\n<meta name=\"twitter:site\" content=\"@softwareag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 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\/connx-db-adapter-ims\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/\",\"name\":\"DB Adapter for IMS: Streamline Your Database Access | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg\",\"datePublished\":\"2024-11-06T01:54:23+00:00\",\"dateModified\":\"2025-12-20T20:01:11+00:00\",\"description\":\"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwareag.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.softwareag.com\/br\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CONNX DB Adapter for IMS\u2122\"}]},{\"@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":"DB Adapter for IMS: Streamline Your Database Access | Software AG","description":"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.","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\/connx-db-adapter-ims\/","og_locale":"en_US","og_type":"article","og_title":"CONNX DB Adapter for IMS\u2122","og_description":"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.","og_url":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-ims\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2025-12-20T20:01:11+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/software-gmbh-dark-logo-bg_Small.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_title":"CONNX DB Adapter for IMS\u2122","twitter_site":"@softwareag","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/","name":"DB Adapter for IMS: Streamline Your Database Access | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg","datePublished":"2024-11-06T01:54:23+00:00","dateModified":"2025-12-20T20:01:11+00:00","description":"Explore the DB Adapter for IMS to seamlessly connect various databases with CONNX for efficient data access and management.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-appdev-01.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-ims\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwareag.com\/de\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.softwareag.com\/br\/resources\/"},{"@type":"ListItem","position":3,"name":"CONNX DB Adapter for IMS\u2122"}]},{"@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"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/798","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":2,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/798\/revisions"}],"predecessor-version":[{"id":1678,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/798\/revisions\/1678"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media\/799"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media?parent=798"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/product?post=798"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-industry?post=798"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-topic?post=798"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-type?post=798"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-subdirectory?post=798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}