{"id":805,"date":"2024-11-05T21:53:48","date_gmt":"2024-11-06T01:53:48","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-rms\/"},"modified":"2026-05-25T09:39:02","modified_gmt":"2026-05-25T13:39:02","slug":"connx-db-adapter-rms","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-rms\/","title":{"rendered":"CONNX DB Adapter para RMS"},"content":{"rendered":"

Unir RMS com m\u00faltiplas fontes de dados  <\/h2>\n\n\n\n

Em conjunto com outros produtos da su\u00edte CONNX, \u00e9 poss\u00edvel realizar jun\u00e7\u00f5es cont\u00ednuas entre dois ou mais bancos de dados diferentes compat\u00edveis, utilizando ODBC, OLE DB, .NET e JDBC\u00ae<\/sup>. O CONNX para acesso RMS \u00e9 r\u00e1pido e eficiente. Com CONNX<\/a>, um \u00fanico modelo de metadados pode ser criado que abrange todas as fontes de dados e aplica\u00e7\u00f5es empresariais que exigem acesso a dados<\/a>O resultado \u00e9 uma visualiza\u00e7\u00e3o de dados em toda a empresa que fornece uma estrutura reutiliz\u00e1vel e baseada em padr\u00f5es para acesso \u00e0 informa\u00e7\u00e3o. Para o usu\u00e1rio ou aplica\u00e7\u00e3o, os dados aparecem como se existissem em um \u00fanico banco de dados relacional federado. <\/p>\n\n\n\n

SQL e CONNX para RMS<\/h3>\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<\/h3>\n\n\n\n

Visualiza\u00e7\u00f5es<\/h4>\n\n\n\n

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<\/h4>\n\n\n\n

O CONNX \u00e9 compat\u00edvel com mais de 600 tipos de dados e realiza convers\u00f5es bidirecionais durante atualiza\u00e7\u00f5es e consultas de dados.<\/p>\n\n\n\n

Importa\u00e7\u00e3o de metadados<\/h4>\n\n\n\n

O CONNX para Oracle RDB importa metadados do RDB diretamente de arquivos de c\u00f3pia COBOL e de um arquivo no formato de especifica\u00e7\u00e3o de texto CONNX para um arquivo do Dicion\u00e1rio de Dados CONNX (CDD).<\/p>\n\n\n\n

Conformidade<\/h4>\n\n\n\n

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<\/h4>\n\n\n\n

O Dicion\u00e1rio de Dados CONNX suporta v\u00e1rios layouts de registro do mesmo arquivo VSAM com base no campo \u201ctipo de registro\u201d.<\/p>\n\n\n\n

Seguran\u00e7a preservada e ampliada<\/h4>\n\n\n\n

O CDD fornece seguran\u00e7a adicional criptograf\u00e1vel em n\u00edvel de campo e de tabela por grupo ou usu\u00e1rio, garantindo a seguran\u00e7a de informa\u00e7\u00f5es confidenciais. O CONNX tamb\u00e9m oferece suporte \u00e0 seguran\u00e7a em n\u00edvel de linha com o CONNX Views. Al\u00e9m disso, o CDD \u00e9 criptografado para proteger informa\u00e7\u00f5es confidenciais.<\/p>\n\n\n\n

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

Torne a sua organiza\u00e7\u00e3o realmente orientada a dados ao aproveitar todas as informa\u00e7\u00f5es em seus sistemas, independente da forma como est\u00e3o estruturadas e sem alterar suas aplica\u00e7\u00f5es de miss\u00e3o cr\u00edtica.  <\/p>\n\n\n\n

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

Obtenha acesso SQL seguro e em tempo real a arquivos RMS em servidores OpenVMS. Realize jun\u00e7\u00f5es cont\u00ednuas entre m\u00faltiplas fontes de dados com o CONNX, garantindo uma integra\u00e7\u00e3o de dados eficiente.<\/p>","protected":false},"featured_media":806,"template":"","product":[48],"resource-industry":[],"resource-topic":[21,72],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-805","resource","type-resource","status-publish","has-post-thumbnail","hentry","product-connx","resource-topic-data-integration","resource-topic-mainframe","resource-type-datasheet","resource-subdirectory-data-integration"],"acf":[],"yoast_head":"\nCONNX DB Adapter for RMS | Software AG<\/title>\n<meta name=\"description\" content=\"Explore the benefits of using the DB Adapter for RMS to seamlessly connect disparate databases and enhance data access.\" \/>\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-rms\/\" \/>\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 RMS\" \/>\n<meta property=\"og:description\" content=\"Explore the benefits of using the DB Adapter for RMS to seamlessly connect disparate databases and enhance data access.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-rms\/\" \/>\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:39:02+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 RMS\" \/>\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-rms\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/\",\"name\":\"CONNX DB Adapter for RMS | Software AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg\",\"datePublished\":\"2024-11-06T01:53:48+00:00\",\"dateModified\":\"2026-05-25T13:39:02+00:00\",\"description\":\"Explore the benefits of using the DB Adapter for RMS to seamlessly connect disparate databases and enhance data access.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#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 RMS\"}]},{\"@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 RMS | Software AG","description":"Explore os benef\u00edcios de usar o Adaptador DB para RMS para conectar de forma transparente bancos de dados d\u00edspares e aprimorar o acesso a dados.","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-rms\/","og_locale":"pt_BR","og_type":"article","og_title":"CONNX DB Adapter for RMS","og_description":"Explore the benefits of using the DB Adapter for RMS to seamlessly connect disparate databases and enhance data access.","og_url":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-rms\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2026-05-25T13:39:02+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 RMS","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-rms\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/","name":"Adaptador de banco de dados CONNX para RMS | Software AG","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg","datePublished":"2024-11-06T01:53:48+00:00","dateModified":"2026-05-25T13:39:02+00:00","description":"Explore os benef\u00edcios de usar o Adaptador DB para RMS para conectar de forma transparente bancos de dados d\u00edspares e aprimorar o acesso a dados.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/living-flow-gen3-multi-grad-dark-01.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-rms\/#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 RMS"}]},{"@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\/805","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":6,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/805\/revisions"}],"predecessor-version":[{"id":9356,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/805\/revisions\/9356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media\/806"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media?parent=805"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/product?post=805"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-industry?post=805"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-topic?post=805"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-type?post=805"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-subdirectory?post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}