{"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":"2025-12-19T16:30:10","modified_gmt":"2025-12-19T20:30:10","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 realizando las operaciones intensivas de CPU donde reside el cliente CONNX (Linux\u00ae<\/sup> y Windows\u00ae<\/sup>(es decir, escritorio remoto, web y\/o servidor de aplicaciones), permitiendo al mismo tiempo que el motor de la base de datos realice las tareas para las que es m\u00e1s adecuado. CONNX importa directamente metadatos PostgreSQL desde copybooks COBOL o archivos de texto. CONNX soporta ANSI SQL (Insert, Update, Select, y Delete); group by, distinct, aggregate (AVG, MIN, MAX, SUM, y COUNT), y todas las funciones de subcadena, cadena, fecha, conversi\u00f3n y matem\u00e1ticas. Se admiten uniones anidadas internas y externas izquierda\/derecha, as\u00ed como subconsultas y subconsultas correlacionadas. CONNX tambi\u00e9n admite Uniones e Insertar\/Seleccionar.<\/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

Tambi\u00e9n te puede interesar:<\/h2>\n\n\n\n
\n
\n
\"icono<\/figure>\n\n\n\n

Mantente conectado<\/h4>\n\n\n\n

\u00danase a la comunidad y siga las \u00faltimas noticias sobre Adabas & Natural en la comunidad tecnol\u00f3gica de Software AG<\/span>.<\/p>\n\n\n\n

\n
Visite nuestra comunidad tecnol\u00f3gica<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"icono<\/figure>\n\n\n\n

Novedades<\/h4>\n\n\n\n

Descubra las \u00faltimas innovaciones, vea seminarios web y compruebe c\u00f3mo Adabas & Natural<\/span> est\u00e1 preparado para 2050 y m\u00e1s all\u00e1.<\/p>\n\n\n\n

\n
Saber m\u00e1s<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"icono<\/figure>\n\n\n\n

Grupos internacionales de usuarios<\/h4>\n\n\n\n

\u00danase a uno de nuestros grupos de usuarios para establecer contactos con colegas de todo el mundo.<\/p>\n\n\n\n

\n
Encuentra un grupo de usuarios<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

\u00bfQuiere preparar sus aplicaciones principales para el futuro?<\/h2>\n\n\n\n

Build on your legacy. Accelerate development in a modern DevOps environment. Modernize your Adabas & Natural<\/span> applications to save costs and embrace hybrid cloud.<\/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=\"2025-12-19T20:30:10+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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\",\"url\":\"https:\/\/www.softwareag.com\/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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/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\":\"2025-12-19T20:30:10+00:00\",\"description\":\"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb\"},\"inLanguage\":\"es-ES\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es-ES\",\"@id\":\"https:\/\/www.softwareag.com\/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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#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 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":"CONNX DB Adapter for PostgreSQL\u00ae | Software AG","description":"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.","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":"2025-12-19T20:30:10+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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","url":"https:\/\/www.softwareag.com\/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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/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":"2025-12-19T20:30:10+00:00","description":"Explore the DB Adapter for PostgreSQL and boost your database management efficiency with seamless integration.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb"},"inLanguage":"es-ES","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"es-ES","@id":"https:\/\/www.softwareag.com\/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\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#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 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 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\/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":5,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/796\/revisions"}],"predecessor-version":[{"id":3848,"href":"https:\/\/www.softwareag.com\/es\/wp-json\/wp\/v2\/resource\/796\/revisions\/3848"}],"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}]}}