{"id":807,"date":"2024-11-05T21:54:14","date_gmt":"2024-11-06T01:54:14","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-sql-server\/"},"modified":"2026-05-25T09:38:08","modified_gmt":"2026-05-25T13:38:08","slug":"connx-db-adapter-sql-server","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-sql-server\/","title":{"rendered":"CONNX DB Adapter for SQL Server\u00ae"},"content":{"rendered":"\n

Join SQL Server 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 SQL Server access is fast and efficient. With CONNX, 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 SQL Server<\/h3>\n\n\n\n

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<\/h3>\n\n\n\n

Views<\/h4>\n\n\n\n

CONNX supports creating views that hide 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<\/h4>\n\n\n\n

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

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

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

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

Take the next step:<\/h2>\n <\/div>\n\n
\n \n
\n \"tech\n <\/div>\n
\n TECH COMMUNITY<\/span>\n <\/div>\n

Join the Software AG Tech Community<\/h3>\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.\n <\/p>\n <\/a>\n \n

\n \"Software\n <\/div>\n
\n ON-DEMAND WEBINARS<\/span>\n <\/div>\n

Browse our library of webinars<\/h3>\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.\n <\/p>\n <\/a>\n \n

\n \"connx\n <\/div>\n
\n Page<\/span>\n <\/div>\n

CONNX Demo<\/h3>\n

\n Explore the capabilities of CONNX Demo for data access and integration. Transform your business with better data solutions.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\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":"

Gain an enterprise-wide view of data that provides a reusable, standards-based framework for information access using our data integration tool CONNX for SQL Server\u00ae.<\/p>\n","protected":false},"featured_media":808,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-807","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 SQL Server: Seamless Data Access<\/title>\n<meta name=\"description\" content=\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\" \/>\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-sql-server\/\" \/>\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 SQL Server\u00ae\" \/>\n<meta property=\"og:description\" content=\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-sql-server\/\" \/>\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:38:08+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 SQL Server\u00ae\" \/>\n<meta name=\"twitter:site\" content=\"@softwareag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 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-sql-server\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/\",\"name\":\"DB Adapter for SQL Server: Seamless Data Access\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"datePublished\":\"2024-11-06T01:54:14+00:00\",\"dateModified\":\"2026-05-25T13:38:08+00:00\",\"description\":\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#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\":\"CONNX DB Adapter for SQL Server\u00ae\"}]},{\"@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 SQL Server: Seamless Data Access","description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","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-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"CONNX DB Adapter for SQL Server\u00ae","og_description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","og_url":"https:\/\/www.softwareag.com\/en\/resources\/data-integration\/connx-db-adapter-sql-server\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2026-05-25T13:38:08+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 SQL Server\u00ae","twitter_site":"@softwareag","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/","name":"DB Adapter for SQL Server: Seamless Data Access","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","datePublished":"2024-11-06T01:54:14+00:00","dateModified":"2026-05-25T13:38:08+00:00","description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#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":"CONNX DB Adapter for SQL Server\u00ae"}]},{"@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\/807","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":4,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/807\/revisions"}],"predecessor-version":[{"id":8906,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource\/807\/revisions\/8906"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media\/808"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/product?post=807"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-industry?post=807"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-topic?post=807"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-type?post=807"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/en\/wp-json\/wp\/v2\/resource-subdirectory?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}