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

Combinar Excel con m\u00faltiples fuentes de datos<\/h2>\n\n\n\n

En combinaci\u00f3n con otros productos de la suite CONNX, puede realizar uniones fluidas entre dos o m\u00e1s bases de datos dispares compatibles mediante ODBC, OLE DB, .NET y JDBC\u00ae<\/sup>. CONNX para Excel es r\u00e1pido y eficaz. Permite crear un \u00fanico modelo de metadatos que abarca todas las fuentes de datos y aplicaciones de la empresa que requieran acceso a datos<\/a>.<\/p>\n\n\n\n

El resultado es una vista de datos a nivel de toda la empresa que proporciona un marco reutilizable basado en est\u00e1ndares para el acceso a la informaci\u00f3n. Para el usuario o la aplicaci\u00f3n, los datos aparecen como si existieran en una \u00fanica base de datos relacional federada.<\/p>\n\n\n\n

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

CONNX es compatible con ANSI SQL (Insert, Update, Select y Delete); las funciones GROUP BY, DISTINCT, de agregaci\u00f3n (AVG, MIN, MAX, SUM y COUNT), as\u00ed como todas las funciones de subcadenas, cadenas, fechas, conversi\u00f3n y matem\u00e1ticas. Admite uniones anidadas internas y externas (izquierda\/derecha), as\u00ed como subconsultas y subconsultas correlacionadas. CONNX tambi\u00e9n admite uniones (UNION) y operaciones insert\/select. \u00a0<\/p>\n\n\n\n

Caracter\u00edsticas principales<\/h3>\n\n\n\n

Vistas<\/h4>\n\n\n\n

CONNX admite la creaci\u00f3n de vistas, que facilitan ocultar las relaciones entre tablas al usuario final. CONNX Views facilita la creaci\u00f3n de uniones heterog\u00e9neas entre m\u00faltiples bases de datos dispares.<\/p>\n\n\n\n

Conversi\u00f3n de datos<\/h4>\n\n\n\n

CONNX admite m\u00e1s de 600 tipos de datos y realiza conversiones bidireccionales de datos para su actualizaci\u00f3n y recuperaci\u00f3n.<\/p>\n\n\n\n

Seguridad preservada y ampliada<\/h4>\n\n\n\n

El diccionario de datos (CDD) de CONNX est\u00e1 cifrado para proteger la informaci\u00f3n confidencial. Ofrece cifrado adicional a nivel de campo y de tabla por grupo o usuario. CONNX tambi\u00e9n admite la seguridad a nivel de fila mediante las vistas de CONNX.<\/p>\n\n\n\n

\n
M\u00e1s informaci\u00f3n sobre DB Adapters<\/a><\/div>\n<\/div>\n\n\n\n
\n\n\n\n \n
\n
\n
<\/h6>\n

Conoce los beneficios:<\/h2>\n <\/div>\n\n
\n \n
\n \"comunidad\n <\/div>\n
\n COMUNIDAD TECNOL\u00d3GICA<\/span>\n <\/div>\n

\u00danase a la comunidad t\u00e9cnica de Software AG<\/h3>\n

\n Colabore con la comunidad CONNX y obtenga consejos y trucos, c\u00f3digo de prueba y descargas que le ayudar\u00e1n a ampliar sus soluciones CONNX en el futuro.\n <\/p>\n <\/a>\n \n

\n \"Seminarios\n <\/div>\n
\n SEMINARIOS WEB A LA CARTA<\/span>\n <\/div>\n

Consulte nuestra biblioteca de seminarios web<\/h3>\n

\n Todos nuestros seminarios web est\u00e1n disponibles a la carta. \u00danase a los expertos y analistas en modernizaci\u00f3n de mainframes mientras debaten, elaboran y demuestran las mejores pr\u00e1cticas.\n <\/p>\n <\/a>\n \n

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

Demostraci\u00f3n CONNX<\/h3>\n

\n Descubra las capacidades de CONNX Demo para el acceso e integraci\u00f3n de datos. Transforme su negocio con mejores soluciones de datos.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\n\n\n\n

\n
\n

\u00bfTu organizaci\u00f3n est\u00e1 lista para integrar los datos de la nube y del mainframe?<\/h2>\n\n\n\n

Aseg\u00farate de que tu organizaci\u00f3n est\u00e9 verdaderamente basada en datos aprovechando toda la informaci\u00f3n de su negocio, independientemente de c\u00f3mo est\u00e9 estructurada, sin cambiar sus sistemas de misi\u00f3n cr\u00edtica.  <\/p>\n\n\n\n

\n
Habla con nuestros expertos<\/a><\/div>\n\n\n\n
Solicita una demostraci\u00f3n<\/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\/es\/resources\/data-integration\/connx-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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\":\"es-ES\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@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\":\"es-ES\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\",\"name\":\"Software AG\",\"alternateName\":\"SAG\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@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":"Combina f\u00e1cilmente Excel con m\u00faltiples fuentes de datos | Software AG","description":"Aprenda a unir Excel con m\u00faltiples fuentes de datos sin problemas y cree una vista unificada de los datos de su empresa.","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\/es\/resources\/data-integration\/connx-microsoft-excel\/","og_locale":"es_ES","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\/es\/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":"Combina f\u00e1cilmente Excel con m\u00faltiples fuentes de datos | 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 unir Excel con m\u00faltiples fuentes de datos sin problemas y cree una vista unificada de los datos de su empresa.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/#breadcrumb"},"inLanguage":"es-ES","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es-ES","@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":"Soluciones y servicios de transformaci\u00f3n digital de 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":"es-ES"},{"@type":"Organization","@id":"https:\/\/www.softwareag.com\/en\/#organization","name":"Software AG","alternateName":"SAG","url":"https:\/\/www.softwareag.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"es-ES","@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 es una empresa global de software empresarial dedicada a facilitar la transformaci\u00f3n digital de grandes organizaciones. Se especializa en la modernizaci\u00f3n de infraestructuras heredadas, la optimizaci\u00f3n de las operaciones de mainframe y la integraci\u00f3n fluida de datos en entornos h\u00edbridos.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"501","maxValue":"1000"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/types\/resource"}],"version-history":[{"count":6,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/813\/revisions"}],"predecessor-version":[{"id":8907,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/813\/revisions\/8907"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/media\/814"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/media?parent=813"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/product?post=813"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-industry?post=813"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-topic?post=813"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-type?post=813"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-subdirectory?post=813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}