{"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":"2025-12-20T16:03:23","modified_gmt":"2025-12-20T20:03:23","slug":"connx-db-adapter-sql-server","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-db-adapter-sql-server\/","title":{"rendered":"CONNX DB Adapter for SQL Server\u00ae"},"content":{"rendered":"

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 f\u00fcr C-ISAM und D-ISAM ist schnell und effizient. Mit CONNX kann ein einziges Metadatenmodell erstellt werden, das alle unternehmensweiten Datenquellen und Anwendungen umfasst, die einen Datenzugriff ben\u00f6tigen. Das Ergebnis ist eine unternehmensweite Sicht auf die Daten, die einen wiederverwendbaren, standardbasierten Rahmen f\u00fcr den Informationszugriff bietet. F\u00fcr den Benutzer oder die Anwendung erscheinen die Daten so, als ob sie in einer einzigen f\u00f6derierten relationalen Datenbank vorhanden w\u00e4ren.<\/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

Wesentliche Merkmale<\/h3>\n\n\n\n

Ansichten<\/h4>\n\n\n\n

CONNX unterst\u00fctzt die Erstellung von Ansichten, die es erm\u00f6glichen, Tabellenbeziehungen vor dem Endbenutzer zu verbergen. CONNX Views erleichtern die Erstellung von heterogenen Joins zwischen mehreren unterschiedlichen Datenbanken.<\/p>\n\n\n\n

Datenkonvertierungen<\/h4>\n\n\n\n

CONNX unterst\u00fctzt mehr als 600 Datentypen und f\u00fchrt bidirektionale Datenkonvertierungen f\u00fcr Datenaktualisierungen und -abrufe durch.<\/p>\n\n\n\n

Sicherheit erhalten und erweitert<\/h4>\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, ensuring information is protected. CONNX also supports row level security with CONNX Views. <\/p>\n\n\n\n

\n
Erfahren Sie mehr \u00fcber DB-Adapter<\/a><\/div>\n<\/div>\n\n\n\n
\n

Machen Sie den n\u00e4chsten Schritt:<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n\n\n\n
Demo<\/h6>\n\n\n\n

Vereinbaren Sie eine Demo mit einem Experten f\u00fcr Mainframe-Modernisierung<\/h4>\n\n\n\n

Entdecken Sie, wie Sie Mainframe-Daten zugreifen, virtualisieren oder verschieben k\u00f6nnen - mit einer Live-Demo von CONNX zusammen mit einem unserer Produktexperten.<\/p>\n\n\n\n

\n
Demo vereinbaren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
TECH-GEMEINSCHAFT<\/h6>\n\n\n\n

Werden Sie Teil der Software AG Tech-Community<\/h4>\n\n\n\n

Tauschen Sie sich mit der CONNX-Community aus und profitieren Sie von Tipps, Testcode und Downloads, um Ihre CONNX-L\u00f6sungen erfolgreich in die Zukunft zu f\u00fchren.<\/p>\n\n\n\n

\n
Jetzt ausprobieren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
ON-DEMAND WEBINARE<\/h6>\n\n\n\n

Durchst\u00f6bern Sie unsere Webinar-Bibliothek<\/h4>\n\n\n\n

Unsere Webinare stehen jederzeit zum Abruf bereit. Erfahren Sie von Mainframe-Modernisierungsexperten und Analysten, wie Best Practices umgesetzt werden, und sehen Sie praxisnahe Demonstrationen.<\/p>\n\n\n\n

\n
Jetzt ansehen<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

Sind Sie bereit, Cloud- und Mainframe-Daten zu vereinen?<\/h2>\n\n\n\n

Werden Sie zu einem datengesteuerten Unternehmen, indem Sie alle Informationen in Ihrem Unternehmen nutzen, wie auch immer sie strukturiert sind - ohne Ihre Kernsysteme zu ver\u00e4ndern.  <\/p>\n\n\n\n

\n
Sprechen Sie mit einem Experten<\/a><\/div>\n\n\n\n
Demo anfordern<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>","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>","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\/de\/resources\/data-integration\/connx-db-adapter-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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=\"2025-12-20T20:03:23+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=\"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-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\":\"2025-12-20T20:03:23+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\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@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\/de\/\"},{\"@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\":\"de-DE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\",\"name\":\"Software AG\",\"alternateName\":\"SAG\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@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\/de\/resources\/data-integration\/connx-db-adapter-sql-server\/","og_locale":"de_DE","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\/de\/resources\/data-integration\/connx-db-adapter-sql-server\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2025-12-20T20:03:23+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":"3 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":"2025-12-20T20:03:23+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":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"de-DE","@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\/de\/"},{"@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":"L\u00f6sungen und Dienstleistungen der Software AG f\u00fcr die digitale Transformation","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":"de-DE"},{"@type":"Organization","@id":"https:\/\/www.softwareag.com\/en\/#organization","name":"Software AG","alternateName":"SAG","url":"https:\/\/www.softwareag.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"de-DE","@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\/de\/wp-json\/wp\/v2\/resource\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/types\/resource"}],"version-history":[{"count":3,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/807\/revisions"}],"predecessor-version":[{"id":4353,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/807\/revisions\/4353"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media\/808"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/product?post=807"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-industry?post=807"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-topic?post=807"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-type?post=807"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-subdirectory?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}