{"id":48790,"date":"2024-07-24T11:38:38","date_gmt":"2024-07-24T09:38:38","guid":{"rendered":"https:\/\/community.simplifier.io\/doc\/sql-konnektor\/"},"modified":"2025-12-11T11:11:47","modified_gmt":"2025-12-11T09:11:47","slug":"sql-konnektor","status":"publish","type":"manual_documentation","link":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/","title":{"rendered":"SQL-Konnektor"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row row_content_display=&#8221;in_grid&#8221; row_content_display_align=&#8221;left&#8221; row_type=&#8221;row&#8221; stretch_row_type=&#8221;yes&#8221;][vc_column][vc_column_text]<\/p>\n<h4>Konfiguration des neuen SQL-Konnektors<\/h4>\n<p>[\/vc_column_text][vc_single_image image=&#8221;72280&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221;][vc_single_image image=&#8221;72281&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<\/p>\n<h4><strong>Datenquelle<\/strong><\/h4>\n<p><span style=\"font-weight: 400;\">Der JDBC-Treiber der unterst\u00fctzten Datenbank: MySQL, Sybase, Oracle, PostgreSQL, SQLite, HANA, Microsoft SQL, IBM DB2 und IBM DB2 f\u00fcr AS-400-Systeme.<\/span><\/p>\n<hr>\n<p>&nbsp;<\/p>\n<p><strong>Verbindungszeichenfolge<\/strong><\/p>\n<p>Die Verbindungszeichenfolge enth\u00e4lt Informationen \u00fcber eine Datenquelle und die Art der Verbindung zu ihr. Sie wird automatisch generiert, abh\u00e4ngig von Ihren vorherigen Auswahlen. <\/p>\n<hr>\n<p><strong>Ergebnistyp<\/strong><\/p>\n<p>Der Ergebnistyp ist ein monadischer Typ, der einen R\u00fcckgabewert oder einen Fehlercode enth\u00e4lt. W\u00e4hlen Sie zwischen mehreren Ergebnissen (z. B. Array), einem einzelnen Ergebnis und keinem Ergebnis. <\/p>\n<p>&nbsp;<\/p>\n<p>Wenn Sie einen SQL-Konnektor mit der SQLite-Datenquelle erstellt haben, werden Dateien f\u00fcr ein spezielles Verzeichnis f\u00fcr SQLite-Datendateien erstellt. Der Konnektor erstellt eine SQLite-Datenbank auf dem Simplifier-Server in den Konnektor-Eigenschaften, falls diese nicht verf\u00fcgbar ist. Wenn Sie den Konnektor \u00e4ndern, wird eine Sicherungskopie der Datei erstellt.  <\/p>\n<p><strong>Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Werfen Sie einen Blick auf die <a href=\"https:\/\/community.simplifier.io\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/sql-connector-calls\/\">SQL Connector Calls<\/a>.[\/vc_column_text][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][vc_column][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.  <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":48974,"menu_order":168,"template":"","format":"standard","class_list":["post-48790","manual_documentation","type-manual_documentation","status-publish","format-standard","hentry","manualdocumentationcategory-aktueller-release","manual_doc_tag-fortgeschrittene-203","manual_doc_tag-fortgeschrittene-210-2","manual_doc_tag-mittelstufe-210-1"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL-Konnektor - Simplifier Makers Club<\/title>\n<meta name=\"description\" content=\"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL-Konnektor - Simplifier Makers Club\" \/>\n<meta property=\"og:description\" content=\"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/\" \/>\n<meta property=\"og:site_name\" content=\"Simplifier Makers Club\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/simplifier.io\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-11T09:11:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@simplifier_io\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/\"},\"author\":{\"name\":\"Chris Bouveret\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#\\\/schema\\\/person\\\/4e80618add686271435728dd07f9e595\"},\"headline\":\"SQL-Konnektor\",\"datePublished\":\"2024-07-24T09:38:38+00:00\",\"dateModified\":\"2025-12-11T09:11:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/\"},\"wordCount\":254,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#organization\"},\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/\",\"url\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/\",\"name\":\"SQL-Konnektor - Simplifier Makers Club\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#website\"},\"datePublished\":\"2024-07-24T09:38:38+00:00\",\"dateModified\":\"2025-12-11T09:11:47+00:00\",\"description\":\"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/current-release\\\/integrate\\\/connectors\\\/sql-connector-details\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Builder-Leitfaden\",\"item\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/app-builder-leitfaden\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Integrieren\",\"item\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/app-builder-leitfaden\\\/integrieren\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Konnektoren\",\"item\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/doc\\\/app-builder-leitfaden\\\/integrieren\\\/verbinder\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL-Konnektor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/\",\"name\":\"Simplifier Makers Club\",\"description\":\"Where Ideas become Digital Reality - Simplifier Documentation, Knowledgebase, Forum, Courses and Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#organization\",\"name\":\"Simplifier AG\",\"url\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/community.simplifier.io\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/simplifier-logo.png\",\"contentUrl\":\"https:\\\/\\\/community.simplifier.io\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/simplifier-logo.png\",\"width\":651,\"height\":150,\"caption\":\"Simplifier AG\"},\"image\":{\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/simplifier.io\\\/\",\"https:\\\/\\\/x.com\\\/simplifier_io\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/simplifier-ag\\\/\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/Simplifier\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/de\\\/#\\\/schema\\\/person\\\/4e80618add686271435728dd07f9e595\",\"name\":\"Chris Bouveret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/community.simplifier.io\\\/wp-content\\\/uploads\\\/avatars\\\/1\\\/1713192263-bpfull.png\",\"url\":\"https:\\\/\\\/community.simplifier.io\\\/wp-content\\\/uploads\\\/avatars\\\/1\\\/1713192263-bpfull.png\",\"contentUrl\":\"https:\\\/\\\/community.simplifier.io\\\/wp-content\\\/uploads\\\/avatars\\\/1\\\/1713192263-bpfull.png\",\"caption\":\"Chris Bouveret\"},\"description\":\"Hi, I\u2019m Chris, Co-Founder and CIO of Simplifier. I\u2019m passionate about revolutionizing how businesses build and deploy applications using low-code technology. I focus on ensuring our platform is secure, robust, and constantly evolving to meet your needs. At Simplifier, we're committed to empowering you with the tools and support necessary to streamline your processes and drive innovation within your organization.\",\"sameAs\":[\"https:\\\/\\\/www.simplifier.io\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/christopher-bouveret\",\"https:\\\/\\\/x.com\\\/chrisbouveret\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL-Konnektor - Simplifier Makers Club","description":"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.","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:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/","og_locale":"de_DE","og_type":"article","og_title":"SQL-Konnektor - Simplifier Makers Club","og_description":"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.","og_url":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/","og_site_name":"Simplifier Makers Club","article_publisher":"https:\/\/www.facebook.com\/simplifier.io\/","article_modified_time":"2025-12-11T09:11:47+00:00","twitter_card":"summary_large_image","twitter_site":"@simplifier_io","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/#article","isPartOf":{"@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/"},"author":{"name":"Chris Bouveret","@id":"https:\/\/community.simplifier.io\/de\/#\/schema\/person\/4e80618add686271435728dd07f9e595"},"headline":"SQL-Konnektor","datePublished":"2024-07-24T09:38:38+00:00","dateModified":"2025-12-11T09:11:47+00:00","mainEntityOfPage":{"@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/"},"wordCount":254,"commentCount":0,"publisher":{"@id":"https:\/\/community.simplifier.io\/de\/#organization"},"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/","url":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/","name":"SQL-Konnektor - Simplifier Makers Club","isPartOf":{"@id":"https:\/\/community.simplifier.io\/de\/#website"},"datePublished":"2024-07-24T09:38:38+00:00","dateModified":"2025-12-11T09:11:47+00:00","description":"Der neue SQL-Konnektor unterst\u00fctzt verschiedene Datenbanken. Er verwendet eine Verbindungszeichenfolge f\u00fcr die Datenquellenverbindung und bietet mehrere Ergebnistypen. Achtung: Das L\u00f6schen des Konnektors l\u00f6scht auch die Datendatei.","breadcrumb":{"@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/community.simplifier.io\/de\/doc\/current-release\/integrate\/connectors\/sql-connector-details\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/community.simplifier.io\/de\/"},{"@type":"ListItem","position":2,"name":"Builder-Leitfaden","item":"https:\/\/community.simplifier.io\/de\/doc\/app-builder-leitfaden\/"},{"@type":"ListItem","position":3,"name":"Integrieren","item":"https:\/\/community.simplifier.io\/de\/doc\/app-builder-leitfaden\/integrieren\/"},{"@type":"ListItem","position":4,"name":"Konnektoren","item":"https:\/\/community.simplifier.io\/de\/doc\/app-builder-leitfaden\/integrieren\/verbinder\/"},{"@type":"ListItem","position":5,"name":"SQL-Konnektor"}]},{"@type":"WebSite","@id":"https:\/\/community.simplifier.io\/de\/#website","url":"https:\/\/community.simplifier.io\/de\/","name":"Simplifier Makers Club","description":"Where Ideas become Digital Reality - Simplifier Documentation, Knowledgebase, Forum, Courses and Marketplace","publisher":{"@id":"https:\/\/community.simplifier.io\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/community.simplifier.io\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/community.simplifier.io\/de\/#organization","name":"Simplifier AG","url":"https:\/\/community.simplifier.io\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/community.simplifier.io\/de\/#\/schema\/logo\/image\/","url":"https:\/\/community.simplifier.io\/wp-content\/uploads\/2024\/09\/simplifier-logo.png","contentUrl":"https:\/\/community.simplifier.io\/wp-content\/uploads\/2024\/09\/simplifier-logo.png","width":651,"height":150,"caption":"Simplifier AG"},"image":{"@id":"https:\/\/community.simplifier.io\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/simplifier.io\/","https:\/\/x.com\/simplifier_io","https:\/\/www.linkedin.com\/company\/simplifier-ag\/","https:\/\/www.youtube.com\/c\/Simplifier\/"]},{"@type":"Person","@id":"https:\/\/community.simplifier.io\/de\/#\/schema\/person\/4e80618add686271435728dd07f9e595","name":"Chris Bouveret","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/community.simplifier.io\/wp-content\/uploads\/avatars\/1\/1713192263-bpfull.png","url":"https:\/\/community.simplifier.io\/wp-content\/uploads\/avatars\/1\/1713192263-bpfull.png","contentUrl":"https:\/\/community.simplifier.io\/wp-content\/uploads\/avatars\/1\/1713192263-bpfull.png","caption":"Chris Bouveret"},"description":"Hi, I\u2019m Chris, Co-Founder and CIO of Simplifier. I\u2019m passionate about revolutionizing how businesses build and deploy applications using low-code technology. I focus on ensuring our platform is secure, robust, and constantly evolving to meet your needs. At Simplifier, we're committed to empowering you with the tools and support necessary to streamline your processes and drive innovation within your organization.","sameAs":["https:\/\/www.simplifier.io","https:\/\/www.linkedin.com\/in\/christopher-bouveret","https:\/\/x.com\/chrisbouveret"]}]}},"_links":{"self":[{"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/docs\/48790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/types\/manual_documentation"}],"author":[{"embeddable":true,"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":5,"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/docs\/48790\/revisions"}],"predecessor-version":[{"id":72300,"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/docs\/48790\/revisions\/72300"}],"up":[{"embeddable":true,"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/docs\/48974"}],"wp:attachment":[{"href":"https:\/\/community.simplifier.io\/de\/wp-json\/wp\/v2\/media?parent=48790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}