{"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\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","title":{"rendered":"Adaptador CONNX DB para PostgreSQL\u00ae"},"content":{"rendered":"

Unir o PostgreSQL a v\u00e1rias fontes de dados<\/h2>\n\n\n\n

O CONNX DB Adapter para acesso ao PostgreSQL \u00e9 r\u00e1pido e eficiente. Com o CONNX.<\/a>Com o uso de metadados, \u00e9 poss\u00edvel criar um \u00fanico modelo de metadados que abrange todas as fontes de dados e aplicativos da empresa que exigem acesso aos dados. O resultado \u00e9 uma vis\u00e3o dos dados em toda a empresa que fornece uma estrutura reutiliz\u00e1vel baseada em padr\u00f5es para o acesso \u00e0s informa\u00e7\u00f5es. Para o usu\u00e1rio ou aplicativo, os dados aparecem como se existissem em um \u00fanico banco de dados relacional federado.<\/p>\n\n\n\n

Adaptador de banco de dados SQL e CONNX para PostgreSQL<\/h2>\n\n\n\n

O mecanismo SQL distribu\u00eddo CONNX reduz a carga de trabalho no servidor ao executar opera\u00e7\u00f5es que exigem uso intensivo da CPU no cliente CONNX (Linux\u00ae, UNIX\u00ae ou Windows\u00ae, por exemplo, servidores de \u00e1rea de trabalho remota, web e\/ou de aplicativos), permitindo que o mecanismo de banco de dados execute as tarefas para as quais \u00e9 mais adequado. O CONNX importa diretamente metadados RMS a partir de copybooks COBOL ou arquivos de texto. O CONNX suporta ANSI SQL (Insert, Update, Select e Delete); agrupamento por distinct, agrega\u00e7\u00e3o (AVG, MIN, MAX, SUM e COUNT); e todas as fun\u00e7\u00f5es de subcadeia, cadeia, data, convers\u00e3o e matem\u00e1ticas. S\u00e3o suportadas jun\u00e7\u00f5es aninhadas internas e externas \u00e0 esquerda\/direita, bem como subconsultas e subconsultas correlacionadas. O CONNX tamb\u00e9m suporta Unions e insert\/select.<\/p>\n\n\n\n

Principais capacidades<\/h2>\n\n\n\n

Visualiza\u00e7\u00f5es<\/strong>
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<\/strong>
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

Importa\u00e7\u00e3o de metadados<\/strong>
O CONNX DB Adapter for PostgreSQL importa metadados do PostgreSQL diretamente de copybooks COBOL e de um formato de arquivo CONNX Text Specification para um arquivo CONNX Data Dictionary (CDD).<\/p>\n\n\n\n

Cl\u00e1usulas de ocorr\u00eancia<\/strong>
A tecnologia exclusiva de matriz rotacionada da CONNX simplifica a manipula\u00e7\u00e3o de grandes matrizes. O CONNX consegue isso retornando cada coluna da matriz como uma linha separada.<\/p>\n\n\n\n

Conformidade<\/strong>
Conte com ODBC Full Compliance (n\u00edvel 2), driver JDBC Tipo 3, driver OLE DB 2.5, driver .NET 2.0 e superior.<\/p>\n\n\n\n

Redefini\u00e7\u00e3o de tabela<\/strong>
O CDD oferece suporte a v\u00e1rios layouts de registro do mesmo arquivo PostgreSQL, com base em um campo \"tipo de registro\".<\/p>\n\n\n\n

\n
\n
\n
Saiba mais<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
Saiba mais sobre Adaptadores para Banco de Dados (DB Adapters)<\/a><\/div>\n<\/div>\n<\/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

Construa sob o seu legado. Acelere o desenvolvimento em um ambiente DevOps moderno. Modernize suas aplica\u00e7\u00f5es Adabas & Natural para reduzir custos e adotar a nuvem h\u00edbrida.<\/p>\n\n\n\n

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

Em conjunto com outros m\u00f3dulos CONNX, voc\u00ea pode realizar uni\u00f5es perfeitas entre dois ou mais bancos de dados diferentes com suporte.<\/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\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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\/br\/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\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\":\"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":"Adaptador de banco de dados CONNX para PostgreSQL\u00ae | Software AG","description":"Explore o Adaptador DB para PostgreSQL e aumente a efici\u00eancia do gerenciamento do seu banco de dados com integra\u00e7\u00e3o perfeita.","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-db-adapter-for-postgresql\/","og_locale":"pt_BR","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\/br\/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 banco de dados 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 o Adaptador DB para PostgreSQL e aumente a efici\u00eancia do gerenciamento do seu banco de dados com integra\u00e7\u00e3o perfeita.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@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":"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\/796","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":8,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/796\/revisions"}],"predecessor-version":[{"id":10009,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/796\/revisions\/10009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media\/797"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/product?post=796"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-industry?post=796"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-topic?post=796"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-type?post=796"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-subdirectory?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}