{"id":5535,"date":"2024-08-01T17:19:51","date_gmt":"2024-08-01T14:19:51","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=5535"},"modified":"2024-08-01T17:19:51","modified_gmt":"2024-08-01T14:19:51","slug":"dzherelo-danyh-baza-danyh","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/dzherelo-danyh-baza-danyh\/","title":{"rendered":"Database as Data Sources"},"content":{"rendered":"<p>Select the \u201cDatabase\u201d data source:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5546\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_1-2-768x530.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p>You will see a form with the following data:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5547\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_2-2-768x530.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<ul>\n<li>Provider \u2013 select the required data source from the drop-down list<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5548\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_3-2-768x530.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<ul>\n<li>Server name \u2013 specify server name<\/li>\n<li>Authentication \u2013 authentication method<\/li>\n<li>Database \u2013 database name<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5549\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4-2-768x530.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p>Now, in the appeared form select the method for selecting the data:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5550\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_5-2-768x530.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<ul>\n<li>Query \u2013 possibility to select the necessary tables \/ columns with help of wizard;<\/li>\n<li>Stored Procedure \u2013 possibility to select a ready stored procedure when connecting to<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":5521,"menu_order":418,"template":"","manuals":[18],"class_list":["post-5535","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/5535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/5521"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=5535"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=5535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}