{"id":6812,"date":"2016-01-29T07:21:44","date_gmt":"2016-01-29T06:21:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/"},"modified":"2016-01-29T07:21:44","modified_gmt":"2016-01-29T06:21:44","slug":"the-postgres-plus-cloud-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/","title":{"rendered":"The Postgres Plus\u00ae Cloud Database"},"content":{"rendered":"

In the last posts (1<\/a>, 2<\/a>, 3<\/a>, 4<\/a>, 5<\/a>) I looked at PostgreSQL in Amazon RDS<\/a>. Another option you have if you want to go to the cloud is to use the The Postgres Plus\u00ae Cloud Database<\/a> offered by EnterpriseDB<\/a>.<\/p>\n

I will not go through the whole setup here as this is described in detail here<\/a>. <\/p>\n

So once you went through the registration and setup process you should be able to login<\/a>. The login URL is depending on the region you selected so this link will not work for you if you not selected a region in the EU (Ireland, in my case):<\/p>\n

\"edb_cloud_1\"<\/a><\/p>\n

You’ll land at the EnterpriseDB console after a successful login:
\n\"edb_cloud_2\"<\/a><\/p>\n

Obviously we want to bring up our first cluster, so lets go. You’ll have the choice between community PostgreSQL and Postgres Plus Advanced Server. The other values are more or less the same than those of the Amazon RDS service:<\/p>\n

\"edb_cloud_3\"<\/a><\/p>\n

\"edb_cloud_4\"<\/a>
\n\"edb_cloud_5\"<\/a>
\n\"edb_cloud_6\"<\/a><\/p>\n

As soon as you choose continuous archiving a storage container for holding all the archived wal files will be created automatically:<\/p>\n

\"edb_cloud_7\"<\/a><\/p>\n

As soon as the creation of the storage finished an email should arrive in your inbox:<\/p>\n

\nFrom: support@theclouddatabase.com\nTo: \"daniel westermann\" \nSent: Wednesday, January 13, 2016 2:16:18 PM\nSubject: WAL Archive Storage Container Created\n\nA storage container (bucket) named xxxxx-ppcd has been created. All Postgres Plus Cloud Database clusters configured for Continuous Archiving (Point-in-Time Recovery) will use this location to store archived WAL files. This container should not be deleted once created as it will cause WAL archiving to stop functioning.\n<\/pre>\n
\"edb_cloud_8\"<\/a><\/p>\n
Waiting a few minutes for the process to complete and the new PostgreSQL cluster will be ready:<\/p>\n
\"edb_cloud_9\"<\/a>
\n\"edb_cloud_10\"<\/a><\/p>\n
As with the storage container you’ll receive notification emails once an instance is ready:<\/p>\n
\nFrom: support@theclouddatabase.com\nTo: \"daniel westermann\" \nSent: Wednesday, January 13, 2016 2:32:09 PM\nSubject: Database State Changed to RUNNING i-7ce1b6f1 t2.micro\n\nThe Master database server ec2-52-18-219-36.eu-west-1.compute.amazonaws.com in cluster pgclust1 is now RUNNING in location eu-west-1a using port 1234.\n<\/pre>\n
\nFrom: support@theclouddatabase.com\nTo: \"daniel westermann\" \nSent: Wednesday, January 13, 2016 2:40:44 PM\nSubject: Database State Changed to RUNNING i-9e4c7d15 t2.micro\n\nThe Replica database server ec2-52-48-111-239.eu-west-1.compute.amazonaws.com t2.micro in cluster pgclust1 is now RUNNING in location eu-west-1c.\n<\/pre>\n
Quite easy. A very good features is that a load balances will be added automatically which listens on port 9999:<\/p>\n
\"edb_cloud_11\"<\/a><\/p>\n
Lets see if we can connect to the load balancer:<\/p>\n
\ndwe@dwe:~$ psql -h ec2-52-18-219-36.eu-west-1.compute.amazonaws.com -p 9999 -U postgres postgres\nPassword for user postgres: \npsql (9.3.10, server 9.4.4)\nWARNING: psql major version 9.3, server major version 9.4.\n         Some psql features might not work.\nType \"help\" for help.\n\npostgres=# \\l\n                                 List of databases\n   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   \n-----------+----------+----------+------------+------------+-----------------------\n postgres  | postgres | UTF8     | en_US.UTF8 | en_US.UTF8 | \n template0 | postgres | UTF8     | en_US.UTF8 | en_US.UTF8 | =c\/postgres          +\n           |          |          |            |            | postgres=CTc\/postgres\n template1 | postgres | UTF8     | en_US.UTF8 | en_US.UTF8 | =c\/postgres          +\n           |          |          |            |            | postgres=CTc\/postgres\n(3 rows)\n\npostgres=# \n<\/pre>\n
In contrast to the Amazon RDS service we have full control over the cluster as we are able to connect with the postgres superuser.
\nWhen the cluster was created an initial backup was created automatically:<\/p>\n
\"edb_cloud_12\"<\/a><\/p>\n
Another interesting feature is auto scaling:<\/p>\n
\"edb_cloud_13\"<\/a><\/p>\n
You have two options there: Auto scale the cluster when a specified threshold for storage usage is reached or auto scale the cluster when a specified threshold on concurrent connections is reached. But keep in mind that this will increase costs as well.<\/p>\n
You even can choose what happens when there is a major issue on the master:
\n\"edb_cloud_14\"<\/a><\/p>\n
Do you want to replace the master with a new master or do you want to promote to a replica? Promoting to a replica is faster but you might loose transactions as replication in this case is asynchronous. In case the master is replaced with a new master the storage volumes are switch to the new master so no transaction will be lost but this will take longer than promoting a replica.<\/p>\n
Configuring the instances is almost the same as in Amazon RDS. You’ll have to create a new configuration and then attach it to a running instance. Additionally you may configure pgpool<\/a>, which is the load balancer from above:<\/p>\n
\"edb_cloud_15\"<\/a><\/p>\n
The monitoring part is slightly limited. You can take a look at the storage used, the amount of connections and the load. This help when defining the auto scaling options but does not replace a full monitoring solution:
\n\"edb_cloud_16\"<\/a><\/p>\n
The events sections lists all events that happened to your cluster:
\n\"edb_cloud_17\"<\/a><\/p>\n
Let’s try to manually scale up our cluster by adding another replica:
\n\"edb_cloud_18\"<\/a>
\n\"edb_cloud_19\"<\/a>
\n\"edb_cloud_20\"<\/a><\/p>\n
Quite easy as well. Now we have two replicas which replicate from the same master. So, in the end, this might be a solution to consider.<\/p>\n","protected":false},"excerpt":{"rendered":"
In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud is to use the The Postgres Plus\u00ae Cloud Database offered by EnterpriseDB. I will not go through the whole setup here as this is described in detail […]<\/p>\n","protected":false},"author":29,"featured_media":6833,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[135,713,77],"type_dbi":[],"class_list":["post-6812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-cloud","tag-enterprisedb","tag-postgresql"],"acf":[],"yoast_head":"\nThe Postgres Plus\u00ae Cloud Database - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Postgres Plus\u00ae Cloud Database\" \/>\n<meta property=\"og:description\" content=\"In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud is to use the The Postgres Plus\u00ae Cloud Database offered by EnterpriseDB. I will not go through the whole setup here as this is described in detail […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-29T06:21:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"540\" \/>\n\t<meta property=\"og:image:height\" content=\"413\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"The Postgres Plus\u00ae Cloud Database\",\"datePublished\":\"2016-01-29T06:21:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\"},\"wordCount\":551,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png\",\"keywords\":[\"Cloud\",\"enterprisedb\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\",\"name\":\"The Postgres Plus\u00ae Cloud Database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png\",\"datePublished\":\"2016-01-29T06:21:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png\",\"width\":540,\"height\":413},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Postgres Plus\u00ae Cloud Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Postgres Plus\u00ae Cloud Database - dbi Blog","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:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/","og_locale":"en_US","og_type":"article","og_title":"The Postgres Plus\u00ae Cloud Database","og_description":"In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud is to use the The Postgres Plus\u00ae Cloud Database offered by EnterpriseDB. I will not go through the whole setup here as this is described in detail […]","og_url":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/","og_site_name":"dbi Blog","article_published_time":"2016-01-29T06:21:44+00:00","og_image":[{"width":540,"height":413,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"The Postgres Plus\u00ae Cloud Database","datePublished":"2016-01-29T06:21:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/"},"wordCount":551,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png","keywords":["Cloud","enterprisedb","PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/","url":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/","name":"The Postgres Plus\u00ae Cloud Database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png","datePublished":"2016-01-29T06:21:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/edb_cloud_1-1.png","width":540,"height":413},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-postgres-plus-cloud-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Postgres Plus\u00ae Cloud Database"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6812"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6812\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6833"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6812"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}