{"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":"2026-05-25T09:38:21","modified_gmt":"2026-05-25T13:38:21","slug":"connx-microsoft-excel","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-microsoft-excel\/","title":{"rendered":"CONNX f\u00fcr Microsoft\u00ae Excel\u00ae"},"content":{"rendered":"

Excel mit mehreren Datenquellen verbinden<\/h2>\n\n\n\n

In Verbindung mit anderen Produkten der CONNX-Suite k\u00f6nnen Sie mithilfe von ODBC, OLE DB, .NET und JDBC nahtlose Verkn\u00fcpfungen zwischen zwei oder mehr unterst\u00fctzten heterogenen Datenbanken herstellen\u00ae<\/sup>. CONNX f\u00fcr Excel ist schnell und effizient. Sie k\u00f6nnen ein einziges Metadatenmodell erstellen, das alle Unternehmensdatenquellen und -anwendungen abdeckt, die Datenzugriff<\/a>.<\/p>\n\n\n\n

Das Ergebnis ist eine unternehmensweite Sicht auf Daten, die einen wiederverwendbaren, standardbasierten Rahmen f\u00fcr den Informationszugriff bietet. F\u00fcr den Benutzer oder die Anwendung erscheinen die Daten, als ob sie in einer einzigen f\u00f6derierten relationalen Datenbank existieren w\u00fcrden.<\/p>\n\n\n\n

SQL & CONNX f\u00fcr Excel<\/h3>\n\n\n\n

CONNX unterst\u00fctzt ANSI-SQL (Insert, Update, Select und Delete); Group By, Distinct, Aggregatfunktionen (AVG, MIN, MAX, SUM und COUNT) sowie alle Teilzeichenfolgen-, Zeichenfolgen-, Datums-, Konvertierungs- und mathematischen Funktionen. Verschachtelte innere und \u00e4u\u00dfere Left\/Right-Joins werden ebenso unterst\u00fctzt wie Unterabfragen und korrelierte Unterabfragen. CONNX unterst\u00fctzt au\u00dferdem Unions und Insert\/Select. \u00a0<\/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

Das CONNX-Datenw\u00f6rterbuch (CDD) ist verschl\u00fcsselt, um sensible Informationen zu sch\u00fctzen. Es bietet zus\u00e4tzliche Verschl\u00fcsselung auf Feld- und Tabellenebene nach Gruppe oder Benutzer. CONNX unterst\u00fctzt zudem Sicherheit auf Zeilenebene mithilfe von CONNX-Ansichten.<\/p>\n\n\n\n

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

Machen Sie den n\u00e4chsten Schritt:<\/h2>\n <\/div>\n\n
\n \n
\n \"Tech-Community\"\n <\/div>\n
\n TECH-GEMEINSCHAFT<\/span>\n <\/div>\n

Werden Sie Teil der Software AG Tech-Community<\/h3>\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.\n <\/p>\n <\/a>\n \n

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

Durchst\u00f6bern Sie unsere Webinar-Bibliothek<\/h3>\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.\n <\/p>\n <\/a>\n \n

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

CONNX-Demo<\/h3>\n

\n Entdecken Sie die Funktionen von CONNX Demo f\u00fcr den Datenzugriff und die Datenintegration. Transformieren Sie Ihr Unternehmen mit besseren Datenl\u00f6sungen.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\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=\"2026-05-25T13:38:21+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=\"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-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\":\"2026-05-25T13:38:21+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\/\"},{\"@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":"Excel ganz einfach mit mehreren Datenquellen verbinden | Software AG","description":"Erfahren Sie, wie Sie Excel nahtlos mit mehreren Datenquellen verbinden, um eine einheitliche Ansicht Ihrer Unternehmensdaten zu erstellen.","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":"2026-05-25T13:38:21+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":"4 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":"Excel ganz einfach mit mehreren Datenquellen verbinden | 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":"2026-05-25T13:38:21+00:00","description":"Erfahren Sie, wie Sie Excel nahtlos mit mehreren Datenquellen verbinden, um eine einheitliche Ansicht Ihrer Unternehmensdaten zu erstellen.","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\/"},{"@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 ist ein weltweit t\u00e4tiger Anbieter von Unternehmenssoftware, der sich darauf spezialisiert hat, die digitale Transformation gro\u00dfer Organisationen voranzutreiben. Das Unternehmen ist auf die Modernisierung veralteter Infrastrukturen, die Optimierung des Mainframe-Betriebs und die nahtlose Datenintegration in hybriden Umgebungen spezialisiert.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"501","maxValue":"1000"}}]}},"jetpack_sharing_enabled":true,"_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":6,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/813\/revisions"}],"predecessor-version":[{"id":8907,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/813\/revisions\/8907"}],"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}]}}