{"id":813,"date":"2024-11-05T21:54:06","date_gmt":"2024-11-06T01:54:06","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-microsoft-excel\/"},"modified":"2025-12-20T16:08:55","modified_gmt":"2025-12-20T20:08:55","slug":"connx-microsoft-excel","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-microsoft-excel\/","title":{"rendered":"CONNX for Microsoft\u00ae Excel\u00ae"},"content":{"rendered":"

Join Excel 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 Excel is fast and efficient. You can create a single metadata model that spans all enterprise data sources and applications requiring data access<\/a>.<\/p>\n\n\n\n

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 Excel<\/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 encryption by group or user. 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":"

Explore the benefits and key features of Software AG\u2019s Adapter for Microsoft Excel. Get all the technical details for this data integration solution.<\/p>","protected":false},"featured_media":814,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-813","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":"\nJoin Excel with Multiple Data Sources Easily | Software AG<\/title>\n<meta name=\"description\" content=\"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.\" \/>\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-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONNX for Microsoft\u00ae Excel\u00ae\" \/>\n<meta property=\"og:description\" content=\"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-microsoft-excel\/\" \/>\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:08:55+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 for Microsoft\u00ae Excel\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-microsoft-excel\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/\",\"name\":\"Join Excel with Multiple Data Sources Easily | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg\",\"datePublished\":\"2024-11-06T01:54:06+00:00\",\"dateModified\":\"2025-12-20T20:08:55+00:00\",\"description\":\"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#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 for Microsoft\u00ae Excel\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":"Join Excel with Multiple Data Sources Easily | Software AG","description":"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.","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-microsoft-excel\/","og_locale":"de_DE","og_type":"article","og_title":"CONNX for Microsoft\u00ae Excel\u00ae","og_description":"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.","og_url":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-microsoft-excel\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2025-12-20T20:08:55+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 for Microsoft\u00ae Excel\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-microsoft-excel\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/","name":"Join Excel with Multiple Data Sources Easily | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg","datePublished":"2024-11-06T01:54:06+00:00","dateModified":"2025-12-20T20:08:55+00:00","description":"Learn how to join Excel with multiple data sources seamlessly and create a unified view of your enterprise data.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-cumulocity-02.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#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 for Microsoft\u00ae Excel\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\/813","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":5,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/813\/revisions"}],"predecessor-version":[{"id":4355,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/813\/revisions\/4355"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media\/814"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media?parent=813"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/product?post=813"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-industry?post=813"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-topic?post=813"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-type?post=813"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-subdirectory?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}