{"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":"2025-12-26T12:10:47","modified_gmt":"2025-12-26T16:10:47","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 for Oracle"},"content":{"rendered":"

Join Oracle with multiple data sources<\/h4>\n\n\n\n

In conjunction with other products in the CONNX suite, you can\u00a0perform seamless joins between two or more supported disparate\u00a0databases using ODBC, OLE DB, .NET, and JDBC\u00ae. CONNX\u00a0for Oracle is a fast and efficient solution. With CONNX<\/a>, a single metadata\u00a0model can be created that spans all enterprise data sources and\u00a0applications requiring data access<\/a>. The result is an enterprise-wide view of data that provides a reusable standards-based\u00a0framework for information access. To the user or application, data\u00a0appears as if it existed in a single federated relational database.\u00a0<\/p>\n\n\n\n

SQL & CONNX for Oracle<\/h4>\n\n\n\n

CONNX supports ANSI SQL (Insert, Update, Select, and Delete); group by distinct, aggregate (AVG, MIN, MAX, SUM, and COUNT), and all substring, string, date, conversion, and math functions. Nested inner and outer left\/right joins are supported, as well as subqueries and correlated subqueries. CONNX also supports Unions and Insert\/Select.  
<\/p>\n\n\n\n

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

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

CONNX supports the creation of views, which facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases.<\/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

Stored procedure execution<\/h5>\n\n\n\n

CONNX provides a mechanism that allows the remote execution of stored procedures contained in the target databases. 
<\/p>\n\n\n\n

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

The CONNX Data Dictionary supports multiple record layouts of the same Rdb file, based on a \u201crecord type\u201d field.<\/p>\n\n\n\n

Record definition import<\/h5>\n\n\n\n

CONNX imports table definitions directly from Oracle databases.<\/p>\n\n\n\n

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

Machen Sie den n\u00e4chsten Schritt:<\/h2>\n\n\n\n
\n
\n
\"\"<\/figure>\n\n\n\n
Demo<\/h6>\n\n\n\n

Vereinbaren Sie eine Demo mit einem Experten f\u00fcr Mainframe-Modernisierung<\/h4>\n\n\n\n

Entdecken Sie, wie Sie Mainframe-Daten zugreifen, virtualisieren oder verschieben k\u00f6nnen - mit einer Live-Demo von CONNX zusammen mit einem unserer Produktexperten.<\/p>\n\n\n\n

\n
Demo vereinbaren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
TECH-GEMEINSCHAFT<\/h6>\n\n\n\n

Werden Sie Teil der Software AG Tech-Community<\/h4>\n\n\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.<\/p>\n\n\n\n

\n
Jetzt ausprobieren<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
ON-DEMAND WEBINARE<\/h6>\n\n\n\n

Durchst\u00f6bern Sie unsere Webinar-Bibliothek<\/h4>\n\n\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.<\/p>\n\n\n\n

\n
Jetzt ansehen<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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>\n\n\n\n

<\/p>","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=\"2025-12-26T16:10:47+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=\"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-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\":\"2025-12-26T16:10:47+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\/de\/\"},{\"@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 for Oracle | Software AG","description":"Explore the benefits of the DB Adapter for Oracle for seamless database integration and a unified view of enterprise data.","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":"2025-12-26T16:10:47+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":"3 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 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":"2025-12-26T16:10:47+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\/de\/"},{"@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 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\/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":5,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/803\/revisions"}],"predecessor-version":[{"id":4474,"href":"https:\/\/www.softwareag.com\/de\/wp-json\/wp\/v2\/resource\/803\/revisions\/4474"}],"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}]}}