{"id":2932,"date":"2019-03-25T17:41:53","date_gmt":"2019-03-25T20:41:53","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/connections-between-e3-and-database\/"},"modified":"2020-01-23T11:38:21","modified_gmt":"2020-01-23T14:38:21","slug":"connections-between-e3-and-database","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/","title":{"rendered":"Connections between E3 and Database."},"content":{"rendered":"
\n

For each DBServer created in an E3 <\/span>domain, there are two possible connections with the Database: one of them is used for E3 <\/span>services (Formulas, Historics, Storage, and Alarms), and the other one is used for queries.<\/p>\n

If DBServer’s EnableLocalCreation <\/span>property is TRUE, an extra connection will be created for every running Viewer. If the domain has more than one DBServer, and their EnableLocalCreation <\/span>properties are all TRUE, an extra connection will be created for every Viewer and DBServer, in case there are Viewer queries in each DBServer.<\/p>\n

When EnableLocalCreation <\/span>property is enabled (TRUE), it makes the Viewer access the Database directly, without using the preexisting connection at the Server. Therefore, if the Domain has two DBServers, and if there are queries regarding both DBServers in the Viewer, each active Viewer will create an extra connection for each DBServer, regardless of the number of queries in each one of them.<\/p>\n

Examples:<\/span><\/p>\n

    \n
  1. Domain with one DBServer, EnableLocalCreation <\/span>property disabled (FALSE), and 2 running Viewers with 5 different queries to the Database. Formula<\/span>: number of DBServers * 2 = 1*2 = 2. Number of connections<\/span>: 2 (two).<\/li>\n
  2. Domain with one DBServer, EnableLocalCreation <\/span>property enabled (TRUE), and 2 running Viewers with 5 different queries to the Database. Formula<\/span>: number of DBServers * 2 + (number of DBServers * number of Viewers) = 1*2+(1*2) = 4. Number of connections<\/span>: 4 (four).<\/li>\n
  3. Domain with two DBServers, EnableLocalCreation <\/span>property enabled (TRUE), and 2 running Viewers with 5 different queries to the Database via both DBServers. Formula<\/span>: number of DBServers * 2 + (number of DBServers * number of Viewers) = 2*2+(2*2) = 8. Number of connections<\/span>: 8 (eight).<\/li>\n<\/ol>\n

    Note<\/span>: When setting up EnableLocalCreation <\/span>property as TRUE, you must make sure the Viewer is in a computer accessing the Database. If the DBServer is not in the same computer as E3, it will not be available outside the company’s intranet. Therefore, you will be able to access the E3 Server via WebViewer (outside the intranet), but not to perform the queries, because it will not be possible to access the DBServer directly.<\/p>\n<\/div>\n

    <\/div>\n
    From version 4.6 on, the EnableLocalCreation<\/b><\/span> property has been removed <\/span><\/b>from the DBServer object. Since then, the Viewers have no longer been able to access the database directly, and all access now take place via server.<\/div>\n","protected":false},"excerpt":{"rendered":"

    For each DBServer created in an E3 domain, there are two possible connections with the Database: one of them is used for E3 services (Formulas, Historics, Storage, and Alarms), and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735,736],"tags":[],"yoast_head":"\nConnections between E3 and Database. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connections between E3 and Database.\" \/>\n<meta property=\"og:description\" content=\"For each DBServer created in an E3 domain, there are two possible connections with the Database: one of them is used for E3 services (Formulas, Historics, Storage, and Alarms), and…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:41:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T14:38:21+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\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:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Connections between E3 and Database.\",\"datePublished\":\"2019-03-25T20:41:53+00:00\",\"dateModified\":\"2020-01-23T14:38:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\"},\"wordCount\":356,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\",\"DataServer\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\",\"name\":\"[:pt]Connections between E3 and Database.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:41:53+00:00\",\"dateModified\":\"2020-01-23T14:38:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connections between E3 and Database.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connections between E3 and Database. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Connections between E3 and Database.[:] - Elipse Knowledgebase","og_description":"For each DBServer created in an E3 domain, there are two possible connections with the Database: one of them is used for E3 services (Formulas, Historics, Storage, and Alarms), and…","og_url":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:41:53+00:00","article_modified_time":"2020-01-23T14:38:21+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Connections between E3 and Database.","datePublished":"2019-03-25T20:41:53+00:00","dateModified":"2020-01-23T14:38:21+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/"},"wordCount":356,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases","DataServer"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/","url":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/","name":"[:pt]Connections between E3 and Database.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:41:53+00:00","dateModified":"2020-01-23T14:38:21+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/connections-between-e3-and-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Connections between E3 and Database."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2932"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2932"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2932\/revisions"}],"predecessor-version":[{"id":10027,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2932\/revisions\/10027"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}