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

PostgreSQL mit mehreren Datenquellen verbinden<\/h2>\n\n\n\n

CONNX DB Adapter f\u00fcr den PostgreSQL-Zugriff ist schnell und effizient. Mit CONNX<\/a>kann ein einziges Metadatenmodell erstellt werden, das alle Unternehmensdatenquellen und Anwendungen umfasst, die einen Datenzugriff ben\u00f6tigen. Das Ergebnis ist eine unternehmensweite Sicht auf die Daten, die einen wiederverwendbaren, auf Standards basierenden Rahmen f\u00fcr den Informationszugang bietet. F\u00fcr den Benutzer oder die Anwendung erscheinen die Daten so, als ob sie in einer einzigen f\u00f6derierten relationalen Datenbank vorhanden w\u00e4ren.<\/p>\n\n\n\n

SQL & CONNX DB Adapter f\u00fcr PostgreSQL<\/h2>\n\n\n\n

Die verteilte SQL-Engine von CONNX entlastet den Server, indem sie rechenintensive Vorg\u00e4nge auf dem CONNX-Client (Linux\u00ae, UNIX\u00ae oder Windows\u00ae, z. B. Remote-Desktop-, Web- und\/oder Anwendungsserver) ausf\u00fchrt, w\u00e4hrend die Datenbank-Engine sich auf die Aufgaben konzentrieren kann, f\u00fcr die sie am besten geeignet ist. CONNX importiert RMS-Metadaten direkt aus COBOL-Copybooks oder Textdateien. CONNX unterst\u00fctzt ANSI SQL (Insert, Update, Select und Delete); Group by Distinct, Aggregate (AVG, MIN, MAX, SUM und COUNT); sowie alle Teilzeichenfolgen-, Zeichenfolgen-, Datums-, Konvertierungs- und mathematischen Funktionen. Verschachtelte innere und \u00e4u\u00dfere Left\/Right-Joins werden ebenso unterst\u00fctzt wie Unterabfragen und korrelierte Unterabfragen. CONNX unterst\u00fctzt au\u00dferdem Unions und Insert\/Select.<\/p>\n\n\n\n

Wesentliche Merkmale<\/h2>\n\n\n\n

Ansichten<\/strong>
CONNX unterst\u00fctzt die Erstellung von Ansichten, die es erm\u00f6glichen, Tabellenbeziehungen vor dem Endbenutzer zu verbergen. CONNX Views erleichtern die Erstellung von heterogenen Joins zwischen mehreren unterschiedlichen Datenbanken.<\/p>\n\n\n\n

Datenkonvertierungen<\/strong>
CONNX unterst\u00fctzt mehr als 600 Datentypen und f\u00fchrt bidirektionale Datenkonvertierungen f\u00fcr Datenaktualisierungen und -abrufe durch.<\/p>\n\n\n\n

Metadaten-Import<\/strong>
CONNX DB Adapter for PostgreSQL importiert PostgreSQL-Metadaten direkt aus COBOL-Copybooks und einem CONNX-Text-Spezifikationsdateiformat in eine CONNX Data Dictionary-Datei (CDD).<\/p>\n\n\n\n

Occur-Klauseln<\/strong>
Die einzigartige Rotated Array Technology von CONNX macht die Bearbeitung gro\u00dfer Arrays einfach. CONNX erreicht dies, indem jede Spalte des Arrays als separate Zeile zur\u00fcckgegeben wird.<\/p>\n\n\n\n

Einhaltung der Vorschriften<\/strong>
Z\u00e4hlen Sie auf ODBC Full Compliance (Level 2), JDBC Type 3 Driver, OLE DB 2.5 Driver, .NET 2.0 Driver und h\u00f6her.<\/p>\n\n\n\n

Neudefinition der Tabelle<\/strong>
Die CDD unterst\u00fctzt mehrere Datensatz-Layouts der gleichen PostgreSQL-Datei, basierend auf einem \"Datensatztyp\"-Feld.<\/p>\n\n\n\n

\n
\n
\n
Mehr erfahren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
Erfahren Sie mehr \u00fcber DB-Adapter<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n\n\n\n \n
\n
\n
<\/h6>\n

Machen Sie den n\u00e4chsten Schritt:<\/h2>\n <\/div>\n\n
\n \n
\n \"Tech-Community\"\n <\/div>\n
\n TECH-GEMEINSCHAFT<\/span>\n <\/div>\n

Werden Sie Teil der Software AG Tech-Community<\/h3>\n

\n Tauschen Sie sich mit der CONNX-Community aus und profitieren Sie von Tipps, Testcode und Downloads, um Ihre CONNX-L\u00f6sungen erfolgreich in die Zukunft zu f\u00fchren.\n <\/p>\n <\/a>\n \n

\n \"Software\n <\/div>\n
\n ON-DEMAND WEBINARE<\/span>\n <\/div>\n

Durchst\u00f6bern Sie unsere Webinar-Bibliothek<\/h3>\n

\n Unsere Webinare stehen jederzeit zum Abruf bereit. Erfahren Sie von Mainframe-Modernisierungsexperten und Analysten, wie Best Practices umgesetzt werden, und sehen Sie praxisnahe Demonstrationen.\n <\/p>\n <\/a>\n \n

\n \"connx\n <\/div>\n
\n Seite<\/span>\n <\/div>\n

CONNX-Demo<\/h3>\n

\n Entdecken Sie die Funktionen von CONNX Demo f\u00fcr den Datenzugriff und die Datenintegration. Transformieren Sie Ihr Unternehmen mit besseren Datenl\u00f6sungen.\n <\/p>\n <\/a>\n <\/div>\n <\/div>\n <\/section>\n\n\n\n

\n
\n

Sie m\u00f6chten Ihre Kernanwendungen zukunftsf\u00e4hig machen?<\/h2>\n\n\n\n

Bauen Sie auf Ihrem Bestand auf. Beschleunigen Sie die Entwicklung in einer modernen DevOps-Umgebung. Modernisieren Sie Ihre Adabas & Natural<\/span>-Anwendungen, um Kosten zu senken und Hybrid-Cloud-Strategien zu nutzen.<\/p>\n\n\n\n

\n
Sprechen Sie mit einem Experten<\/a><\/div>\n\n\n\n
Unverbindlich ausprobieren<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

In Verbindung mit anderen CONNX-Modulen k\u00f6nnen Sie nahtlose Joins zwischen zwei oder mehr unterst\u00fctzten, unterschiedlichen Datenbanken durchf\u00fchren.<\/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\/de\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@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\":\"de-DE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softwareag.com\/en\/#organization\",\"name\":\"Software AG\",\"alternateName\":\"SAG\",\"url\":\"https:\/\/www.softwareag.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@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 f\u00fcr PostgreSQL\u00ae | Software AG","description":"Entdecken Sie den DB-Adapter f\u00fcr PostgreSQL und steigern Sie Ihre Datenbankverwaltungseffizienz mit nahtloser 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\/de\/resources\/data-integration\/connx-db-adapter-for-postgresql\/","og_locale":"de_DE","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\/de\/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":"CONNX DB-Adapter f\u00fcr 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":"Entdecken Sie den DB-Adapter f\u00fcr PostgreSQL und steigern Sie Ihre Datenbankverwaltungseffizienz mit nahtloser Integration.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"de-DE","@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":"L\u00f6sungen und Dienstleistungen der Software AG f\u00fcr die digitale Transformation","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":"de-DE"},{"@type":"Organization","@id":"https:\/\/www.softwareag.com\/en\/#organization","name":"Software AG","alternateName":"SAG","url":"https:\/\/www.softwareag.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"de-DE","@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 ist ein weltweit t\u00e4tiger Anbieter von Unternehmenssoftware, der sich darauf spezialisiert hat, die digitale Transformation gro\u00dfer Organisationen voranzutreiben. Das Unternehmen ist auf die Modernisierung veralteter Infrastrukturen, die Optimierung des Mainframe-Betriebs und die nahtlose Datenintegration in hybriden Umgebungen spezialisiert.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"501","maxValue":"1000"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/types\/resource"}],"version-history":[{"count":8,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/796\/revisions"}],"predecessor-version":[{"id":10009,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/796\/revisions\/10009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media\/797"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/product?post=796"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-industry?post=796"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-topic?post=796"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-type?post=796"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-subdirectory?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}