{"id":3560,"date":"2023-04-12T15:39:28","date_gmt":"2023-04-12T15:39:28","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/"},"modified":"2023-04-12T15:39:28","modified_gmt":"2023-04-12T15:39:28","slug":"euclid-studio-connecting-to-a-database-via-jdbc","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/","title":{"rendered":"Euclid Studio: Connecting to a database via JDBC"},"content":{"rendered":"<p>When using an ETL and modeling tool like Euclid Studio, it\u2019s extremely likely that you\u2019ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow.<\/p>\n<p>Once you\u2019ve logged into Euclid Studio and created\/opened your flow, hover over the \u2018Server\u2019 menu at the top and click on the \u2018Databases\u2026\u2019 option:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1065 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg\" alt=\"\" width=\"529\" height=\"334\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>This window will display any connections if they\u2019ve already been configured in the flow or saved to the currently logged in user. To create a new connection, click \u2018Add\u2019 under the Flow Database Connections:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1061 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/e2a-min-1024x216.jpg\" alt=\"\" width=\"605\" height=\"128\" \/><\/p>\n<p>You can edit the newly created connection by clicking on the pencil icon on the far right. Once in edit mode, you can fill in the following fields:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1062 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/e3a-min-1024x84.jpg\" alt=\"\" width=\"605\" height=\"50\" \/><\/p>\n<ul>\n<li>Connection Name \u2013 this is what the connection will be referred to in database connected nodes. You can enter any value you\u2019d like.<\/li>\n<li>User \u2013 the SQL username that will login and connect to the database<\/li>\n<li>Password \u2013 the password of the associated username<\/li>\n<li>Driver Class \u2013 dropdown menu of supported databases. Choose whichever applies to the database you are connecting to (SQL Server, Oracle, Firebird, etc.)<\/li>\n<li>URL \u2013 the JDBC connection URL. You can select from the dropdown for an example of the correct syntax, then edit the appropriate parameters. For example, if you\u2019re connecting to SQL Server, the example string is:<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>jdbc:sqlserver:\/\/localhost:1433;databaseName=AdventureWorks;<\/strong><\/p>\n<p>In this case, you\u2019ll just need to replace \u2018localhost\u2019 with the server that the database resides on and replace AdventureWorks with the database that you are connecting to.<\/p>\n<p>Once all of the fields have been filled in, you can click the checkmark on the right to confirm your changes.<\/p>\n<p>To test the connection, click the row to select it (turning it white). Then click \u2018Test Connection\u2019 above. If everything is working, you should see a \u2018Connection successful!\u2019 message. If there is an error, it will display it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1063 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/e4a-min-1024x102.jpg\" alt=\"\" width=\"605\" height=\"60\" \/><\/p>\n<p>If this is a connection you will be using across multiple flows, you can click \u2018Add to User Saved\u2019. This will copy the connection up to the top section, saving it to the currently logged in user. For any new flows, you can then select the saved connection and click \u2018Add to Flow\u2019 to add it to the currently opened flow.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1064 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/e5a-min-1024x151.jpg\" alt=\"\" width=\"605\" height=\"89\" \/><\/p>\n<p>Once a connection has been established, you can select it in any database connected node (Database source, export, or output):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-1066 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/e6a-min.jpg\" alt=\"\" width=\"605\" height=\"201\" \/><\/p>\n<p>If multiple connections exist in a single flow, you can choose between them using the dropdown in each node.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using an ETL and modeling tool like Euclid Studio, it\u2019s extremely likely that you\u2019ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you\u2019ve logged into Euclid Studio and created\/opened your flow, hover over the \u2018Server\u2019 menu at the top&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[33],"class_list":["post-3560","post","type-post","status-publish","format-standard","hentry","category-quebit-value","tag-euclid-studio"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Euclid Studio: Connecting to a database via JDBC - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Euclid Studio: Connecting to a database via JDBC - QueBIT\" \/>\n<meta property=\"og:description\" content=\"When using an ETL and modeling tool like Euclid Studio, it\u2019s extremely likely that you\u2019ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you\u2019ve logged into Euclid Studio and created\/opened your flow, hover over the \u2018Server\u2019 menu at the top&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:39:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"Euclid Studio: Connecting to a database via JDBC\",\"datePublished\":\"2023-04-12T15:39:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/\"},\"wordCount\":430,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/E1a-min.jpg\",\"keywords\":[\"Euclid Studio\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/\",\"name\":\"Euclid Studio: Connecting to a database via JDBC - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/E1a-min.jpg\",\"datePublished\":\"2023-04-12T15:39:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/E1a-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/E1a-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/euclid-studio-connecting-to-a-database-via-jdbc\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Euclid Studio: Connecting to a database via JDBC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Euclid Studio: Connecting to a database via JDBC - QueBIT","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:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/","og_locale":"en_US","og_type":"article","og_title":"Euclid Studio: Connecting to a database via JDBC - QueBIT","og_description":"When using an ETL and modeling tool like Euclid Studio, it\u2019s extremely likely that you\u2019ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you\u2019ve logged into Euclid Studio and created\/opened your flow, hover over the \u2018Server\u2019 menu at the top&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:39:28+00:00","og_image":[{"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg","type":"","width":"","height":""}],"author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"Euclid Studio: Connecting to a database via JDBC","datePublished":"2023-04-12T15:39:28+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/"},"wordCount":430,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg","keywords":["Euclid Studio"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/","url":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/","name":"Euclid Studio: Connecting to a database via JDBC - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg","datePublished":"2023-04-12T15:39:28+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/06\/E1a-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/euclid-studio-connecting-to-a-database-via-jdbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Euclid Studio: Connecting to a database via JDBC"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3560"}],"version-history":[{"count":0,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3560\/revisions"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}