{"id":704,"date":"2020-05-06T21:23:21","date_gmt":"2020-05-06T13:23:21","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=704"},"modified":"2020-05-06T21:23:21","modified_gmt":"2020-05-06T13:23:21","slug":"connecting-to-your-database-in-sql-data-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/connecting-to-your-database-in-sql-data-analysis\/","title":{"rendered":"Connecting to your database in SQL Data Analysis"},"content":{"rendered":"<p><a href=\"https:\/\/www.yohz.com\/sda_details.htm\">SQL Data Analysis<\/a> supports the following databases:<\/p>\n<ul>\n<li>PostgreSQL 8.0 onwards<\/li>\n<li>MySQL and MariaDB 4.0 onwards<\/li>\n<li>Oracle 8.0 onwards<\/li>\n<li>SQL Server 7 onwards<\/li>\n<li>SQL Server Compact 3.1 onwards<\/li>\n<li>SQL Azure<\/li>\n<li>SQLite 3.0 onwards<\/li>\n<li>Microsoft Access 2000 onwards<\/li>\n<li>Firebird 1.x onwards<\/li>\n<li>ODBC supported databases<\/li>\n<\/ul>\n<p>To connect to a database, click on the <strong>Run SQL query<\/strong> item:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-705\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01.png\" alt=\"\" width=\"931\" height=\"667\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01.png 931w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-300x215.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-768x550.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect01-624x447.png 624w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><\/p>\n<p>Details of previous connections are also listed, and you can double-click on the connection item to re-open that connection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-706\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect02.png\" alt=\"\" width=\"770\" height=\"364\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect02.png 770w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect02-300x142.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect02-768x363.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect02-624x295.png 624w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/p>\n<p>In the <strong>Run SQL Query<\/strong> window, a list of existing connections will be displayed on the left.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-707\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect03.png\" alt=\"\" width=\"609\" height=\"404\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect03.png 609w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect03-300x199.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p>To establish a new connection, click on the <strong>Connect to a database<\/strong> item.\u00a0 Enter the connection details, and click <strong>Connect<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-708 alignnone\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect04.png\" alt=\"\" width=\"426\" height=\"541\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect04.png 426w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect04-236x300.png 236w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/p>\n<p>On a successful connection, a new query window will be created.\u00a0 The active connection will be highlighted in the <strong>Database Connections<\/strong> panel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-710\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect06.png\" alt=\"\" width=\"656\" height=\"423\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect06.png 656w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect06-300x193.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect06-624x402.png 624w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>Enter your SQL queries in the editor window, and click on the <strong>Execute query<\/strong> button (or press F5) to run your query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-713 alignnone\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect07-2.png\" alt=\"\" width=\"599\" height=\"270\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect07-2.png 599w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/sda_connect07-2-300x135.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/06\/697\/\">running queries on the internal data sets<\/a><\/li>\n<\/ul>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/connecting-to-your-database-in-sql-data-analysis\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/06\/connecting-to-your-database-in-sql-data-analysis\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>SQL Data Analysis supports the following databases: PostgreSQL 8.0 onwards MySQL and MariaDB 4.0 onwards Oracle 8.0 onwards SQL Server 7 onwards SQL Server Compact 3.1 onwards SQL Azure SQLite 3.0 onwards Microsoft Access 2000 onwards Firebird 1.x onwards ODBC supported databases To connect to a database, click on the Run SQL query item: Details [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[86],"tags":[87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/704"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=704"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/704\/revisions"}],"predecessor-version":[{"id":714,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/704\/revisions\/714"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}