{"id":807,"date":"2024-11-05T21:54:14","date_gmt":"2024-11-06T01:54:14","guid":{"rendered":"https:\/\/www.softwareag.com\/resources\/adabas-natural\/connx-db-adapter-sql-server\/"},"modified":"2025-12-20T16:03:23","modified_gmt":"2025-12-20T20:03:23","slug":"connx-db-adapter-sql-server","status":"publish","type":"resource","link":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-sql-server\/","title":{"rendered":"CONNX DB Adapter para SQL Server\u00ae"},"content":{"rendered":"

Join SQL Server with multiple data sources<\/h2>\n\n\n\n

Ao utilizar outros produtos da su\u00edte CONNX, \u00e9 poss\u00edvel realizar jun\u00e7\u00f5es cont\u00ednuas entre dois ou mais bancos de dados distintos e compat\u00edveis, utilizando ODBC, OLE DB, .NET e JDBC\u00ae.\u00ae<\/sup>. CONNX para C-ISAM e D-ISAM \u00e9 r\u00e1pido e eficiente. Com o CONNX, \u00e9 poss\u00edvel criar um \u00fanico modelo de metadados que abrange todas as fontes de dados corporativos e aplicativos que exigem acesso aos dados. O resultado \u00e9 uma vis\u00e3o dos dados em toda a empresa que fornece uma estrutura reutiliz\u00e1vel baseada em padr\u00f5es para o acesso \u00e0s informa\u00e7\u00f5es. Para o usu\u00e1rio ou aplicativo, os dados aparecem como se existissem em um \u00fanico banco de dados relacional federado.<\/p>\n\n\n\n

SQL & CONNX for SQL Server<\/h3>\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

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

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

The CONNX Data Dictionary (CDD) is encrypted to secure sensitive information. It provides additional field and table-level security by group or user, ensuring information is protected. CONNX also supports row level security with CONNX Views. <\/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

Recursos recomendados<\/h3>\n\n\n\n
\n
\n
\"\"<\/figure>\n\n\n\n
Demo<\/h6>\n\n\n\n

Agende uma demo com um especialista em moderniza\u00e7\u00e3o de mainframe<\/h4>\n\n\n\n

Veja como voc\u00ea pode acessar, virtualizar ou mover dados do seu mainframe. Assista \u00e0 uma demo ao vivo da plataforma CONNX com um de nossos especialistas na solu\u00e7\u00e3o.<\/p>\n\n\n\n

\n
Agende uma demo<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
COMUNIDADE TECNOL\u00d3GICA<\/h6>\n\n\n\n

Junte-se \u00e0 Tech Community da Software AG<\/h4>\n\n\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.<\/p>\n\n\n\n

\n
Teste agora<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n\n\n\n
WEBINARS ON-DEMAND<\/h6>\n\n\n\n

Pesquise em nosso arquivo de Webinars<\/h4>\n\n\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.<\/p>\n\n\n\n

\n
Assista aqui<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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 uma vis\u00e3o corporativa dos dados, oferecendo uma estrutura reutiliz\u00e1vel e baseada em padr\u00f5es para acesso \u00e0 informa\u00e7\u00e3o, utilizando nossa ferramenta de integra\u00e7\u00e3o de dados CONNX para SQL Server\u00ae.<\/p>","protected":false},"featured_media":808,"template":"","product":[48],"resource-industry":[],"resource-topic":[21],"resource-type":[31],"resource-subdirectory":[65],"class_list":["post-807","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":"\nDB Adapter for SQL Server: Seamless Data Access<\/title>\n<meta name=\"description\" content=\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\" \/>\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-sql-server\/\" \/>\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 SQL Server\u00ae\" \/>\n<meta property=\"og:description\" content=\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-sql-server\/\" \/>\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-20T20:03:23+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 SQL Server\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-sql-server\/\",\"url\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/\",\"name\":\"DB Adapter for SQL Server: Seamless Data Access\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwareag.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"datePublished\":\"2024-11-06T01:54:14+00:00\",\"dateModified\":\"2025-12-20T20:03:23+00:00\",\"description\":\"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"contentUrl\":\"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#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 SQL Server\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\":\"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":"DB Adapter for SQL Server: Seamless Data Access","description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","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-sql-server\/","og_locale":"pt_BR","og_type":"article","og_title":"CONNX DB Adapter for SQL Server\u00ae","og_description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","og_url":"https:\/\/www.softwareag.com\/br\/resources\/data-integration\/connx-db-adapter-sql-server\/","og_site_name":"Software AG","article_publisher":"https:\/\/www.facebook.com\/SoftwareAG","article_modified_time":"2025-12-20T20:03:23+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 SQL Server\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-sql-server\/","url":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/","name":"DB Adapter for SQL Server: Seamless Data Access","isPartOf":{"@id":"https:\/\/www.softwareag.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","datePublished":"2024-11-06T01:54:14+00:00","dateModified":"2025-12-20T20:03:23+00:00","description":"Unlock seamless database integration with the DB Adapter for SQL Server. Enhance your data access with CONNX technology.","breadcrumb":{"@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#primaryimage","url":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","contentUrl":"https:\/\/www.softwareag.com\/app\/uploads\/2025\/09\/ds-alfabet-03.svg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwareag.com\/resources\/data-integration\/connx-db-adapter-sql-server\/#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 SQL Server\u00ae"}]},{"@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":"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\/br\/wp-json\/wp\/v2\/resource\/807","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":3,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/807\/revisions"}],"predecessor-version":[{"id":4353,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource\/807\/revisions\/4353"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media\/808"}],"wp:attachment":[{"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/product?post=807"},{"taxonomy":"resource-industry","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-industry?post=807"},{"taxonomy":"resource-topic","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-topic?post=807"},{"taxonomy":"resource-type","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-type?post=807"},{"taxonomy":"resource-subdirectory","embeddable":true,"href":"https:\/\/www.softwareag.com\/br\/wp-json\/wp\/v2\/resource-subdirectory?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}