{"id":2473,"date":"2019-03-25T17:39:44","date_gmt":"2019-03-25T20:39:44","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb31085-connecting-e3-to-the-postgresql-database\/"},"modified":"2023-03-07T16:52:42","modified_gmt":"2023-03-07T19:52:42","slug":"kb-31085-how-to-connect-elipse-e3-to-postgresql","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/","title":{"rendered":"KB-31085: Connecting Elipse E3 to PostgreSQL."},"content":{"rendered":"<h3 align=\"justify\"><span style=\"font-weight: bold;\">Question:<\/span><\/h3>\n<div align=\"justify\">How can I connect Elipse E3 to a <a href=\"https:\/\/kb.elipse.com.br\/en\/?s=postgresql\" target=\"_blank\" rel=\"noopener\">PostgreSQL<\/a> database? Does it have native support to this database, or do I need to perform any extra procedures to do so?<\/div>\n<div align=\"justify\"><\/div>\n<h3 align=\"justify\"><span style=\"font-weight: bold;\">Solution:<\/span><\/h3>\n<div align=\"justify\">PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. It supports both SQL (relational) and JSON (non-relational) querying, and is the fourth most popular database in the world.<\/div>\n<div align=\"justify\"><\/div>\n<div align=\"justify\">From Elipse E3 <strong>version 6.5<\/strong> on, the supervisory has featured native support to PostgreSQL databases, in addition to Access, SQLServer, MySQL and Oracle databases. For <strong>previous versions<\/strong> of Elipse E3, you can use the procedure described below.<\/div>\n<div align=\"justify\">\n<p>If you&#8217;re using any Elipse E3 version prior to 6.5, you can also connect to the PostgreSQL database. However, you won&#8217;t have native support to it, and therefore need to connect to it via OBDC. To do so, you must be sure you have its connection string (you can check it at\u00a0 <a href=\"http:\/\/www.connectionstrings.com\" target=\"_blank\" rel=\"noopener noreferrer\">www.connectionstrings.com<\/a> for more information), and then add it to a script. In this case, you will not be able to use any E3 database objects, such as Historic, Storage, and E3Query.<\/p>\n<p>Due to these limitations, whenever you use this database, the <span style=\"font-weight: bold;\">E3 <\/span>application will usually record all data with a database with native support in older versions\u00a0 (Access, SQLServer, or Oracle), and then the database will periodically execute a direct command to export all data to PostgreSQL (in this case, you can use a\u00a0 StoredProcedure that does this automatically).<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: How can I connect Elipse E3 to a PostgreSQL database? Does it have native support to this database, or do I need to perform any extra procedures to do&hellip;<\/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],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-31085: Connecting Elipse E3 to PostgreSQL. - 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\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-31085: Connecting Elipse E3 to PostgreSQL.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I connect Elipse E3 to a PostgreSQL database? Does it have native support to this database, or do I need to perform any extra procedures to do&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\" \/>\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:39:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T19:52:42+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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-31085: Connecting Elipse E3 to PostgreSQL.\",\"datePublished\":\"2019-03-25T20:39:44+00:00\",\"dateModified\":\"2023-03-07T19:52:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\"},\"wordCount\":404,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\",\"url\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\",\"name\":\"[:pt]KB-31085: Connecting E3 to the PostgreSQL database.[:en]KB-31085: Connecting Elipse E3 to PostgreSQL.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:39:44+00:00\",\"dateModified\":\"2023-03-07T19:52:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-31085: Connecting E3 to the PostgreSQL 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":"KB-31085: Connecting Elipse E3 to PostgreSQL. - 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\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-31085: Connecting E3 to the PostgreSQL database.[:en]KB-31085: Connecting Elipse E3 to PostgreSQL.[:] - Elipse Knowledgebase","og_description":"Question: How can I connect Elipse E3 to a PostgreSQL database? Does it have native support to this database, or do I need to perform any extra procedures to do&hellip;","og_url":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:39:44+00:00","article_modified_time":"2023-03-07T19:52:42+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-31085: Connecting Elipse E3 to PostgreSQL.","datePublished":"2019-03-25T20:39:44+00:00","dateModified":"2023-03-07T19:52:42+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/"},"wordCount":404,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/","url":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/","name":"[:pt]KB-31085: Connecting E3 to the PostgreSQL database.[:en]KB-31085: Connecting Elipse E3 to PostgreSQL.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:39:44+00:00","dateModified":"2023-03-07T19:52:42+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/kb-31085-how-to-connect-elipse-e3-to-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-31085: Connecting E3 to the PostgreSQL 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\/2473"}],"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=2473"}],"version-history":[{"count":4,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2473\/revisions"}],"predecessor-version":[{"id":14325,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2473\/revisions\/14325"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}