{"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\/br\/resources\/data-integration\/connx-microsoft-excel\/","title":{"rendered":"CONNX para Microsoft\u00ae Excel\u00ae"},"content":{"rendered":"

Integre o Excel a v\u00e1rias fontes de dados<\/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

O resultado \u00e9 uma vis\u00e3o corporativa unificada dos dados, que oferece uma estrutura reutiliz\u00e1vel e baseada em padr\u00f5es para acesso \u00e0s informa\u00e7\u00f5es. Para o usu\u00e1rio ou aplica\u00e7\u00e3o, os dados aparecem como se estivessem em um \u00fanico banco de dados relacional federado.<\/p>\n\n\n\n

SQL & CONNX para Excel<\/h3>\n\n\n\n

O CONNX \u00e9 compat\u00edvel com ANSI SQL (Insert, Update, Select e Delete); com os comandos group by, distinct e fun\u00e7\u00f5es de agrega\u00e7\u00e3o (AVG, MIN, MAX, SUM e COUNT), al\u00e9m de todas as fun\u00e7\u00f5es de substring, string, data, convers\u00e3o e matem\u00e1ticas. Tamb\u00e9m h\u00e1 suporte para jun\u00e7\u00f5es aninhadas internas e externas (left\/right joins), al\u00e9m de subconsultas correlacionadas. O CONNX tamb\u00e9m oferece suporte a Unions e Insert\/Select.  <\/p>\n\n\n\n

Principais capacidades<\/h3>\n\n\n\n

Visualiza\u00e7\u00f5es<\/h4>\n\n\n\n

O CONNX permite a cria\u00e7\u00e3o de visualiza\u00e7\u00f5es, o que facilita a oculta\u00e7\u00e3o das rela\u00e7\u00f5es entre tabelas para o usu\u00e1rio final. As visualiza\u00e7\u00f5es do CONNX simplificam a cria\u00e7\u00e3o de joins heterog\u00eaneas entre v\u00e1rios bancos de dados diferentes.<\/p>\n\n\n\n

Convers\u00f5es de dados<\/h4>\n\n\n\n

O CONNX \u00e9 compat\u00edvel com mais de 600 tipos de dados e realiza convers\u00f5es bidirecionais durante atualiza\u00e7\u00f5es e consultas de dados.<\/p>\n\n\n\n

Seguran\u00e7a preservada e ampliada<\/h4>\n\n\n\n

O CONNX Data Dictionary (CDD) \u00e9 criptografado para proteger informa\u00e7\u00f5es sens\u00edveis. Ele oferece criptografia adicional em campos e tabelas, por grupo ou usu\u00e1rio. O CONNX tamb\u00e9m oferece suporte \u00e0 seguran\u00e7a em n\u00edvel de linha por meio das CONNX Views.<\/p>\n\n\n\n

\n
Saiba mais sobre Adaptadores para Banco de Dados (DB Adapters)<\/a><\/div>\n<\/div>\n\n\n\n
\n

Recursos recomendados<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n\n\n\n
Demo<\/h6>\n\n\n\n

Agende uma demo com um especialista em moderniza\u00e7\u00e3o de mainframe<\/h4>\n\n\n\n

Veja como voc\u00ea pode acessar, virtualizar ou mover dados do seu mainframe. Assista \u00e0 uma demo ao vivo da plataforma CONNX com um de nossos especialistas na solu\u00e7\u00e3o.<\/p>\n\n\n\n

\n
Agende uma demo<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
COMUNIDADE TECNOL\u00d3GICA<\/h6>\n\n\n\n

Junte-se \u00e0 Tech Community da Software AG<\/h4>\n\n\n\n

Colabore com a comunidade de usu\u00e1rios e especialistas da plataforma CONNX e obtenha dicas, c\u00f3digos de teste e downloads que ir\u00e3o ajudar voc\u00ea a ampliar o valor de seus dados com vistas ao futuro.<\/p>\n\n\n\n

\n
Teste agora<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
WEBINARS ON-DEMAND<\/h6>\n\n\n\n

Pesquise em nosso arquivo de Webinars<\/h4>\n\n\n\n

Todos os nossos webinars est\u00e3o dispon\u00edveis para voc\u00ea assistir conforme sua conveni\u00eancia. Ou\u00e7a o que os analistas e especialistas em moderniza\u00e7\u00e3o de mainframe t\u00eam a dizer enquanto discutem e demonstram as melhores pr\u00e1ticas.<\/p>\n\n\n\n

\n
Assista aqui<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

Voc\u00ea est\u00e1 pronto para unir dados do mainframe e da nuvem?<\/h2>\n\n\n\n

Torne a sua organiza\u00e7\u00e3o realmente orientada a dados ao aproveitar todas as informa\u00e7\u00f5es em seus sistemas, independente da forma como est\u00e3o estruturadas e sem alterar suas aplica\u00e7\u00f5es de miss\u00e3o cr\u00edtica.  <\/p>\n\n\n\n

\n
Fale com um especialista<\/a><\/div>\n\n\n\n
Solicite uma demo<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

Explore os benef\u00edcios e os principais recursos do Software AG\u2019s Adapter para Microsoft Excel. Obtenha todos os detalhes t\u00e9cnicos desta solu\u00e7\u00e3o de integra\u00e7\u00e3o de dados.<\/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\/br\/resources\/data-integration\/connx-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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\/br\/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\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\",\"name\":\"Software AG\",\"alternateName\":\"SAG\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\/br\/resources\/data-integration\/connx-microsoft-excel\/","og_locale":"pt_BR","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\/br\/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":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@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":"Solu\u00e7\u00f5es e servi\u00e7os de transforma\u00e7\u00e3o digital da Software AG","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":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.softwareag.com\/en\/#organization","name":"Software AG","alternateName":"SAG","url":"https:\/\/www.softwareag.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@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\/br\/wp-json\/wp\/v2\/resource\/813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/types\/resource"}],"version-history":[{"count":5,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/813\/revisions"}],"predecessor-version":[{"id":4355,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/813\/revisions\/4355"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media\/814"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media?parent=813"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/product?post=813"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-industry?post=813"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-topic?post=813"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-type?post=813"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-subdirectory?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}