{"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\/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

Em conjunto com outros produtos da su\u00edte CONNX, \u00e9 poss\u00edvel realizar jun\u00e7\u00f5es cont\u00ednuas entre dois ou mais bancos de dados diferentes compat\u00edveis, utilizando ODBC, OLE DB, .NET e JDBC\u00ae<\/sup>O CONNX para Excel \u00e9 r\u00e1pido e eficiente. Voc\u00ea pode criar um \u00fanico modelo de metadados que abrange todas as fontes de dados e aplica\u00e7\u00f5es de miss\u00e3o cr\u00edtica. acesso a dados<\/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 suporta ANSI SQL (Insert, Update, Select e Delete); group by, distinct, fun\u00e7\u00f5es de agrega\u00e7\u00e3o (AVG, MIN, MAX, SUM e COUNT), al\u00e9m de todas as fun\u00e7\u00f5es de subcadeia, cadeia de caracteres, data, convers\u00e3o e matem\u00e1ticas. S\u00e3o suportadas jun\u00e7\u00f5es aninhadas internas e externas (left\/right), bem como subconsultas e subconsultas correlacionadas. O CONNX tamb\u00e9m suporta un\u00f5es (Unions) e insert\/select. \u00a0<\/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 suporta mais de 600 tipos de dados e realiza convers\u00f5es bidirecionais de dados para atualiza\u00e7\u00f5es e recupera\u00e7\u00e3o 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\n\n\n \n
\n
\n
<\/h6>\n

Recursos recomendados<\/h2>\n <\/div>\n\n
\n \n
\n \"comunidade\n <\/div>\n
\n COMUNIDADE TECNOL\u00d3GICA<\/span>\n <\/div>\n

Junte-se \u00e0 Tech Community da Software AG<\/h3>\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.\n <\/p>\n <\/a>\n \n

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

Pesquise em nosso arquivo de Webinars<\/h3>\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.\n <\/p>\n <\/a>\n \n

\n \"connx\n <\/div>\n
\n P\u00e1gina<\/span>\n <\/div>\n

Demonstra\u00e7\u00e3o do CONNX<\/h3>\n

\n Explore os recursos do CONNX Demo para acesso e integra\u00e7\u00e3o de dados. Transforme sua empresa com melhores solu\u00e7\u00f5es de dados.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\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=\"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\":\"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\/\"},{\"@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":"Junte facilmente o Excel a v\u00e1rias fontes de dados | Software AG","description":"Aprenda a juntar o Excel com v\u00e1rias fontes de dados de forma integrada e a criar uma vis\u00e3o unificada dos seus dados empresariais.","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":"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":"Junte facilmente o Excel a v\u00e1rias fontes de dados | 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":"Aprenda a juntar o Excel com v\u00e1rias fontes de dados de forma integrada e a criar uma vis\u00e3o unificada dos seus dados empresariais.","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\/"},{"@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":"A Software AG \u00e9 uma empresa global de software empresarial dedicada a facilitar a transforma\u00e7\u00e3o digital de grandes organiza\u00e7\u00f5es. Ela \u00e9 especializada na moderniza\u00e7\u00e3o de infraestruturas legadas, na otimiza\u00e7\u00e3o de opera\u00e7\u00f5es de mainframe e na integra\u00e7\u00e3o perfeita de dados em ambientes h\u00edbridos.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"501","maxValue":"1000"}}]}},"jetpack_sharing_enabled":true,"_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":6,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/813\/revisions"}],"predecessor-version":[{"id":8907,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/813\/revisions\/8907"}],"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}]}}