{"id":803,"date":"2024-11-05T21:53:54","date_gmt":"2024-11-06T01:53:54","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-oracle\/"},"modified":"2026-05-25T09:38:38","modified_gmt":"2026-05-25T13:38:38","slug":"connx-db-adapter-oracle","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-db-adapter-oracle\/","title":{"rendered":"CONNX-DB-Adapter f\u00fcr Oracle"},"content":{"rendered":"

Treten Sie Oracle mit mehreren Datenquellen bei<\/h4>\n\n\n\n

In Verbindung mit anderen Produkten der CONNX-Suite k\u00f6nnen Sie mithilfe von ODBC, OLE DB, .NET und JDBC\u00ae nahtlose Verkn\u00fcpfungen zwischen zwei oder mehr unterst\u00fctzten heterogenen Datenbanken herstellen. CONNX f\u00fcr Oracle ist eine schnelle und effiziente L\u00f6sung. Mit CONNX<\/a>, ein einziges Metadatenmodell erstellt werden kann, das alle Unternehmensdatenquellen und -anwendungen umfasst Datenzugriff<\/a>Das Ergebnis ist eine unternehmensweite Sicht auf Daten, die einen wiederverwendbaren, standardbasierten Rahmen f\u00fcr den Informationszugriff bietet. F\u00fcr den Benutzer oder die Anwendung erscheinen die Daten, als ob sie in einer einzigen f\u00f6derierten relationalen Datenbank existieren w\u00fcrden. <\/p>\n\n\n\n

SQL und CONNX f\u00fcr Oracle<\/h4>\n\n\n\n

CONNX unterst\u00fctzt ANSI-SQL (Insert, Update, Select und Delete); Group By Distinct, Aggregatfunktionen (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.\u00a0\u00a0
<\/p>\n\n\n\n

Hauptvorteile<\/h2>\n\n\n\n

Ansichten<\/h5>\n\n\n\n

CONNX unterst\u00fctzt die Erstellung von Ansichten, die Tabellenbeziehungen vor dem Endbenutzer verbergen. CONNX-Ansichten erleichtern die Erstellung heterogener Verkn\u00fcpfungen zwischen mehreren unterschiedlichen Datenbanken.<\/p>\n\n\n\n

Datenkonvertierungen<\/h5>\n\n\n\n

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

Einhaltung der Vorschriften<\/h5>\n\n\n\n

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

Sicherheit erhalten und erweitert<\/h5>\n\n\n\n

Die CDD bietet zus\u00e4tzliche Sicherheit auf Feld- und Tabellenebene, die nach Gruppen oder Benutzern verschl\u00fcsselt werden kann, um die Sicherheit sensibler Informationen zu gew\u00e4hrleisten. CONNX unterst\u00fctzt auch Sicherheit auf Zeilenebene mit CONNX Views. Zus\u00e4tzlich wird die CDD verschl\u00fcsselt, um sensible Informationen zu sch\u00fctzen.<\/p>\n\n\n\n

Ausf\u00fchrung gespeicherter Prozeduren<\/h5>\n\n\n\n

CONNX bietet eine M\u00f6glichkeit, gespeicherte Prozeduren in den Zieldatenbanken aus der Ferne auszuf\u00fchren.\u00a0
<\/p>\n\n\n\n

Neudefinition der Tabelle<\/h5>\n\n\n\n

Das CONNX-Datenw\u00f6rterbuch unterst\u00fctzt mehrere Datensatzlayouts derselben VSAM-Datei auf der Grundlage eines Feldes vom Typ \u201eDatensatztyp\u201c.<\/p>\n\n\n\n

Datensatzdefinitionsimport<\/h5>\n\n\n\n

CONNX importiert Tabellendefinitionen direkt aus Oracle-Datenbanken.<\/p>\n\n\n\n

\n
Erfahren Sie mehr \u00fcber DB-Adapter<\/a><\/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

Sind Sie bereit, Cloud- und Mainframe-Daten zu vereinen?<\/h2>\n\n\n\n

Werden Sie zu einem datengesteuerten Unternehmen, indem Sie alle Informationen in Ihrem Unternehmen nutzen, wie auch immer sie strukturiert sind - ohne Ihre Kernsysteme zu ver\u00e4ndern.  <\/p>\n\n\n\n

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

Secure, real-time SQL access to Oracle Rdb on OpenVMS servers. Seamlessly join Oracle Rdb with other databases using CONNX for efficient data integration.<\/p>","protected":false},"featured_media":804,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-803","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 Oracle | Software AG<\/title>\n<meta name=\"description\" content=\"Explore the benefits of the DB Adapter for Oracle for seamless database integration and a unified view of enterprise data.\" \/>\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-oracle\/\" \/>\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 Oracle\" \/>\n<meta property=\"og:description\" content=\"Explore the benefits of the DB Adapter for Oracle for seamless database integration and a unified view of enterprise data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-db-adapter-oracle\/\" \/>\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-05-25T13:38:38+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 Oracle\" \/>\n<meta name=\"twitter:site\" content=\"@softwareag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 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-oracle\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/\",\"name\":\"CONNX DB Adapter for Oracle | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg\",\"datePublished\":\"2024-11-06T01:53:54+00:00\",\"dateModified\":\"2026-05-25T13:38:38+00:00\",\"description\":\"Explore the benefits of the DB Adapter for Oracle for seamless database integration and a unified view of enterprise data.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwareag.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.softwareag.com\/br\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CONNX DB Adapter for Oracle\"}]},{\"@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 Oracle | Software AG","description":"Erkunden Sie die Vorteile des DB-Adapters f\u00fcr Oracle f\u00fcr eine nahtlose Datenbankintegration und eine einheitliche Sicht auf Unternehmensdaten.","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-oracle\/","og_locale":"de_DE","og_type":"article","og_title":"CONNX DB Adapter for Oracle","og_description":"Explore the benefits of the DB Adapter for Oracle for seamless database integration and a unified view of enterprise data.","og_url":"https:\/\/www.softwareag.com\/de\/resources\/data-integration\/connx-db-adapter-oracle\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2026-05-25T13:38:38+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 Oracle","twitter_site":"@softwareag","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/","name":"CONNX-DB-Adapter f\u00fcr Oracle | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg","datePublished":"2024-11-06T01:53:54+00:00","dateModified":"2026-05-25T13:38:38+00:00","description":"Erkunden Sie die Vorteile des DB-Adapters f\u00fcr Oracle f\u00fcr eine nahtlose Datenbankintegration und eine einheitliche Sicht auf Unternehmensdaten.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-light-02.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwareag.com\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.softwareag.com\/br\/resources\/"},{"@type":"ListItem","position":3,"name":"CONNX DB Adapter for Oracle"}]},{"@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\/803","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":6,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/803\/revisions"}],"predecessor-version":[{"id":8908,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/803\/revisions\/8908"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media\/804"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/media?parent=803"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/product?post=803"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-industry?post=803"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-topic?post=803"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-type?post=803"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource-subdirectory?post=803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}