{"id":796,"date":"2025-05-27T06:58:41","date_gmt":"2025-05-27T10:58:41","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-for-postgresql\/"},"modified":"2026-06-17T12:55:15","modified_gmt":"2026-06-17T16:55:15","slug":"connx-db-adapter-for-postgresql","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/es\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","title":{"rendered":"Adaptador CONNX DB para PostgreSQL"},"content":{"rendered":"

Unir PostgreSQL con m\u00faltiples fuentes de datos<\/h2>\n\n\n\n

CONNX DB Adapter para acceso PostgreSQL es r\u00e1pido y eficiente. Con CONNX<\/a>De este modo, se puede crear un \u00fanico modelo de metadatos que abarque todas las fuentes de datos de la empresa y las aplicaciones que requieren acceso a los datos. El resultado es una visi\u00f3n de los datos que abarca toda la empresa y 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

Adaptador SQL & CONNX DB para PostgreSQL<\/h2>\n\n\n\n

El motor SQL distribuido de CONNX reduce la carga de trabajo del servidor al realizar las operaciones que consumen m\u00e1s recursos de la CPU en el cliente de CONNX (Linux\u00ae, UNIX\u00ae o Windows\u00ae, por ejemplo, servidores de escritorio remoto, web o de aplicaciones), al tiempo que permite que el motor de la base de datos realice las tareas para las que est\u00e1 mejor preparado. CONNX importa directamente metadatos RMS desde archivos de copia de COBOL o archivos de texto. CONNX es compatible con ANSI SQL (Insert, Update, Select y Delete); agrupar por distintos, agregados (AVG, MIN, MAX, SUM y COUNT); y todas las funciones de subcadenas, cadenas, fechas, conversi\u00f3n y matem\u00e1ticas. Se admiten uniones anidadas internas y externas a la izquierda\/derecha, as\u00ed como subconsultas y subconsultas correlacionadas. CONNX tambi\u00e9n admite uniones e insert\/select.<\/p>\n\n\n\n

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

Vistas<\/strong>
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<\/strong>
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

Importaci\u00f3n de metadatos<\/strong>
CONNX DB Adapter for PostgreSQL importa metadatos PostgreSQL directamente desde copybooks COBOL y un formato de archivo CONNX Text Specification a un archivo CONNX Data Dictionary (CDD).<\/p>\n\n\n\n

Ocurrencias<\/strong>
La exclusiva tecnolog\u00eda de matrices rotadas de CONNX simplifica la manipulaci\u00f3n de matrices de gran tama\u00f1o. CONNX lo consigue devolviendo cada columna de la matriz como una fila independiente.<\/p>\n\n\n\n

Conformidad<\/strong>
Cuente con ODBC Full Compliance (nivel 2), JDBC Type 3 Driver, OLE DB 2.5 Driver, .NET 2.0 Driver y superiores.<\/p>\n\n\n\n

Redefinici\u00f3n de la tabla<\/strong>
El CDD admite varios dise\u00f1os de registro del mismo archivo PostgreSQL, basados en un campo \"tipo de registro\".<\/p>\n\n\n\n

\n
\n
\n
Saber m\u00e1s<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
M\u00e1s informaci\u00f3n sobre DB Adapters<\/a><\/div>\n<\/div>\n<\/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

\u00bfQuieres preparar tus aplicaciones cr\u00edticas para el futuro?<\/h2>\n\n\n\n

Construye sobre tu legado. Acelera el desarrollo en un entorno DevOps moderno. Moderniza tus aplicaciones Adabas & Natural para ahorrar costes y adoptar la nube h\u00edbrida.<\/p>\n\n\n\n

\n
Habla con nuestros expertos<\/a><\/div>\n\n\n\n
Pruebas gratuitas<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

Junto con otros m\u00f3dulos CONNX, puede realizar uniones sin fisuras entre dos o m\u00e1s bases de datos dispares compatibles.<\/p>","protected":false},"featured_media":797,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-796","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":"\nCONNX DB Adapter for PostgreSQL\u00ae | Software AG<\/title>\n<meta name=\"description\" content=\"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.\" \/>\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-db-adapter-for-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONNX DB Adapter for PostgreSQL\u00ae\" \/>\n<meta property=\"og:description\" content=\"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/es\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\" \/>\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-06-17T16:55:15+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 DB Adapter for PostgreSQL\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\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\",\"url\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\",\"name\":\"CONNX DB Adapter for PostgreSQL\u00ae | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg\",\"datePublished\":\"2025-05-27T10:58:41+00:00\",\"dateModified\":\"2026-06-17T16:55:15+00:00\",\"description\":\"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb\"},\"inLanguage\":\"es-ES\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@id\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwareag.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.softwareag.com\/en\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CONNX DB Adapter for PostgreSQL\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":"Adaptador de base de datos CONNX para PostgreSQL\u00ae | Software AG","description":"Explore el Adaptador de DB para PostgreSQL y potencie la eficiencia de su gesti\u00f3n de bases de datos con una integraci\u00f3n perfecta.","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-db-adapter-for-postgresql\/","og_locale":"es_ES","og_type":"article","og_title":"CONNX DB Adapter for PostgreSQL\u00ae","og_description":"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.","og_url":"https:\/\/www.softwareag.com\/es\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2026-06-17T16:55:15+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 DB Adapter for PostgreSQL\u00ae","twitter_site":"@softwareag","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","url":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","name":"Adaptador de base de datos CONNX para PostgreSQL\u00ae | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg","datePublished":"2025-05-27T10:58:41+00:00","dateModified":"2026-06-17T16:55:15+00:00","description":"Explore el Adaptador de DB para PostgreSQL y potencie la eficiencia de su gesti\u00f3n de bases de datos con una integraci\u00f3n perfecta.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb"},"inLanguage":"es-ES","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"es-ES","@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-wm-integration-02.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwareag.com\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.softwareag.com\/en\/resources\/"},{"@type":"ListItem","position":3,"name":"CONNX DB Adapter for PostgreSQL\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\/796","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":8,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/796\/revisions"}],"predecessor-version":[{"id":10009,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/796\/revisions\/10009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/media\/797"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/product?post=796"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-industry?post=796"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-topic?post=796"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-type?post=796"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource-subdirectory?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}