{"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\/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 CPU-intensive Operationen dort ausf\u00fchrt, wo sich der CONNX-Client befindet (Linux\u00ae<\/sup> und Windows\u00ae<\/sup>(z. B. Remote-Desktop, Web- und\/oder Anwendungsserver), w\u00e4hrend die Datenbank-Engine die Aufgaben ausf\u00fchren kann, f\u00fcr die sie am besten geeignet ist. CONNX importiert PostgreSQL-Metadaten direkt aus COBOL-Copybooks oder Textdateien. CONNX unterst\u00fctzt ANSI SQL (Einf\u00fcgen, Aktualisieren, Ausw\u00e4hlen und L\u00f6schen), Gruppieren nach, Unterscheiden, Aggregieren (AVG, MIN, MAX, SUM und COUNT) sowie alle Teilstring-, String-, Datums-, Konvertierungs- und mathematischen Funktionen. Verschachtelte innere und \u00e4u\u00dfere Links\/Rechts-Joins werden ebenso unterst\u00fctzt wie Unterabfragen und korrelierte Unterabfragen. CONNX unterst\u00fctzt auch 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

Das k\u00f6nnte Sie auch interessieren:<\/h2>\n\n\n\n
\n
\n
\"Gl\u00fchbirnen-Symbol\"<\/figure>\n\n\n\n

Bleiben Sie verbunden<\/h4>\n\n\n\n

Treten Sie der Community bei und verfolgen Sie die neuesten Nachrichten zu Adabas & Natural in der Software AG<\/span> Tech Community.<\/p>\n\n\n\n

\n
Besuchen Sie die Tech Community<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"Laptop-Symbol\"<\/figure>\n\n\n\n

Neuigkeiten entdecken<\/h4>\n\n\n\n

Entdecken Sie die neuesten Innovationen, sehen Sie sich Webinare an und erfahren Sie, wie Adabas & Natural<\/span> f\u00fcr 2050 und dar\u00fcber hinaus ger\u00fcstet ist.<\/p>\n\n\n\n

\n
Mehr erfahren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"Globus-Symbol\"<\/figure>\n\n\n\n

Internationale Benutzergruppen<\/h4>\n\n\n\n

Werden Sie Teil einer User Group und kn\u00fcpfen Sie weltweit Kontakte mit Ihren Kolleg:innen.<\/p>\n\n\n\n

\n
Finden Sie Ihre Gruppe<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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=\"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\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@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\":\"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 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\/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":"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":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-for-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"de-DE","@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":"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 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\/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":5,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/796\/revisions"}],"predecessor-version":[{"id":3848,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/796\/revisions\/3848"}],"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}]}}