{"id":20409,"date":"2022-03-25T13:45:54","date_gmt":"2022-03-25T12:45:54","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/"},"modified":"2026-05-13T10:47:47","modified_gmt":"2026-05-13T08:47:47","slug":"sql-connectivity-module","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/","title":{"rendered":"SQL Connectivity Module"},"content":{"rendered":"\n<p><strong>The configuration of the SQL connectivity module is intended for experienced users with knowledge of the SQL language.<\/strong><\/p>\n\n<p><strong><em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">The Cloud SQL Query feature is available as an option. Please contact support to request activation.<\/mark><\/em><\/strong><\/p>\n\n<p>This module will be able to, via SQL queries on an external DBMS:<\/p>\n\n<ul class=\"wp-block-list\"><li>Populate Open Bee\u2122 Portal metadata from other metadata<\/li><li>Populate a form&#8217;s metadata from another metadata<\/li><li>Populate an Open Bee\u2122 Portal list<\/li><li>Populate a list of a form<\/li><li>Populate one or more columns in a row of a table on a form<\/li><\/ul>\n\n<p>The operation is based on a connection to an external database as well as SQL queries.<\/p>\n\n<p>Click on &#8220;<strong>Administration<\/strong>&#8221; &#8220;<strong>SQL&#8221;<\/strong> to access the module.  <br\/>There are two tabs available, &#8220;<strong>External SQL Connections<\/strong>&#8221; and &#8220;<strong>SQL Queries<\/strong>&#8220;.<\/p>\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/external-sql-connections\/\" data-type=\"page\" data-id=\"13974\">External SQL Connections<\/a><\/li><li><a href=\"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/sql-queries\/\" data-type=\"page\" data-id=\"13972\">SQL queries<\/a><ul><li><a href=\"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/sql-queries\/sql-query-in-a-table\/\" data-type=\"page\" data-id=\"13980\">SQL query in a table<\/a><\/li><li><a href=\"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/sql-queries\/self-populated-list\/\" data-type=\"page\" data-id=\"13983\">Self-Populated List<\/a><\/li><\/ul><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The configuration of the SQL connectivity module is intended for experienced users with knowledge of the SQL language. The Cloud SQL Query feature is available as an option. Please contact support to request activation. This module will be able to, via SQL queries on an external DBMS: Populate Open Bee\u2122 Portal metadata from other metadata [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":20157,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"templates\/ob-help-products.php","meta":{"footnotes":""},"class_list":["post-20409","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=20409"}],"version-history":[{"count":2,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20409\/revisions"}],"predecessor-version":[{"id":29199,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20409\/revisions\/29199"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20157"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=20409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}