{"id":625,"date":"2020-08-06T13:30:00","date_gmt":"2020-08-06T17:30:00","guid":{"rendered":"https:\/\/www.pwvconsultants.com\/blog\/?p=625"},"modified":"2020-08-05T19:36:20","modified_gmt":"2020-08-05T23:36:20","slug":"the-lost-art-of-etl","status":"publish","type":"post","link":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/","title":{"rendered":"The Lost Art of ETL"},"content":{"rendered":"\n<p>Specialization is a problem across computing. Devs and coders tend to learn one or two languages and try to make everything fit into what they know. While those languages might be flexible enough to do a lot of things, it doesn\u2019t mean they do them well, nor does it mean that you SHOULD use them for what you are doing. We\u2019ve touched on this in our datastores series already, but there is something to add here. There\u2019s a lost art happening, something even really smart developers sometimes have not heard of: Extract, transform and load, or ETL.<\/p>\n\n\n\n<p>ETL is the art of taking data from one or more sources, running it through a process, manipulating it, doing calculations on it, somehow transforming it and getting a result or relationship from it, and then loading it in another location. In reality, ETL is what happens in some cases when you\u2019re simply moving data from a database and putting it into a cache. Or when you take data out, analyze it and put it into a search index.<\/p>\n\n\n\n<p>ETL is a lost art because people look at their data stores and think they can figure out a way to make everything fit into it. Startups especially have this happen because they have a store that is sufficient for the first few things they needed to do, so they think it can be used for everything. But the reality is that doesn\u2019t make sense. An even bigger problem happens when they realize this doesn\u2019t make sense and instead of searching for something that does, they see a new sexy tool they want to try. But they don\u2019t understand the implications of this new tool or how it can potentially cause a different set of problems.<\/p>\n\n\n\n<p>Choosing the proper store is only one part of the process. The other important part is understanding that you need to use different stores and move data around. If you have a screw that has a hex head on it and you try to screw it in with a Phillips head, it\u2019s not going to work. A wrench isn\u2019t going to work. A socket wrench might work, but what would work best is an Allen wrench. So, for example, you\u00a0 might need to take data and store some of it in an<a href=\"https:\/\/www.pwvconsultants.com\/blog\/sql-vs-nosql-databases\/\" target=\"_blank\" aria-label=\"undefined (opens in a new tab)\" rel=\"noreferrer noopener\"> SQL store<\/a>, some portion in a NoSQL store, <a href=\"https:\/\/www.pwvconsultants.com\/blog\/caches-and-queue-stores-are-short-term\/\" target=\"_blank\" aria-label=\"undefined (opens in a new tab)\" rel=\"noreferrer noopener\">cache it somewhere or put it in a queue<\/a> to get it in and out.<\/p>\n\n\n\n<p>You might need to use your entire toolbox to get a job done and might need to put glue and ETL in between to appropriately use the data. This is so that you\u2019re not moving into the edges of different systems and deteriorating the entire application <a href=\"https:\/\/www.pwvconsultants.com\/blog\/the-importance-of-proper-database-use\/\" target=\"_blank\" aria-label=\"undefined (opens in a new tab)\" rel=\"noreferrer noopener\">because you\u2019re misusing the systems<\/a>. Then you won\u2019t be able to complete the task at hand or your client will have to wait too long. Other drawbacks include extra expenses and time spent on a project.<\/p>\n\n\n\n<p>Computing is all about timing resources on all ends. When you start bloating or overloading systems, the effects can range in severity from a few minor problems all the way to systems crashing and everything coming to a screeching halt. So you want to stay out of those fringes and learn how to use the right tools for the job. You want to learn how to hand off data from one store to another properly so that data doesn\u2019t become lost and can still be used and analyzed in the way it needs to be. And sometimes you will need to glue the data between stores, and that\u2019s okay. Just don\u2019t get stuck on it being easier to keep it all in one place.<\/p>\n\n\n\n<p>Especially if you\u2019re a startup, you must understand that there is a balancing point. You might be able to start with just one store, but you\u2019re not leaving yourself room to grow. You don\u2019t necessarily want to run out and purchase or start using all of these different data stores before you really know what you\u2019re going to need. But you also don\u2019t want to just put everything into the first store you come across because when you do start to grow, it\u2019s going to break. If you\u2019re unsure of what type of data store to use or what you might need for future growth, consult an expert. Someone who understands the type of data you\u2019re going to have and what you need to do with it will be able to help you plan for growth.<\/p>\n\n\n\n<p>At the end of the day, everything is not created equal in the computing world. Developers like to have the idea that they learned a language and therefore everything they ever need to do can be done in that language. But if you don\u2019t look at how the language and data stores actually function and whether or not they make sense for what you are doing, when you get to scale, you\u2019re often going to make the wrong choices. Using a combination of data stores and moving data with ETL will always have a better outcome than trying to shove every piece of information you have into an misappropriated datastore.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.<\/p>\n","protected":false},"author":1,"featured_media":630,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[599,961,958],"tags":[791,925,1391,1273,1272,1170,1435,1436],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.2 (Yoast SEO v22.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Lost Art of ETL - PWV Consultants<\/title>\n<meta name=\"description\" content=\"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.\" \/>\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.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Lost Art of ETL\" \/>\n<meta property=\"og:description\" content=\"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\" \/>\n<meta property=\"og:site_name\" content=\"PWV Consultants\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PWV-Consultants-110444033947964\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-06T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T23:36:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1355\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Pieter VanIperen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PWV_Consultants\" \/>\n<meta name=\"twitter:site\" content=\"@PWV_Consultants\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pieter VanIperen\" \/>\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.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\"},\"author\":{\"name\":\"Pieter VanIperen\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/c15d5d40126a8ad906cb3067de95f8d4\"},\"headline\":\"The Lost Art of ETL\",\"datePublished\":\"2020-08-06T17:30:00+00:00\",\"dateModified\":\"2020-08-05T23:36:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\"},\"wordCount\":889,\"publisher\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg\",\"keywords\":[\"coders\",\"data\",\"data management\",\"Database\",\"Datastore\",\"Developers\",\"ETL\",\"extract transform load\"],\"articleSection\":[\"Coding\",\"Data Stores\",\"Information Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\",\"url\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\",\"name\":\"The Lost Art of ETL - PWV Consultants\",\"isPartOf\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg\",\"datePublished\":\"2020-08-06T17:30:00+00:00\",\"dateModified\":\"2020-08-05T23:36:20+00:00\",\"description\":\"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage\",\"url\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg\",\"contentUrl\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg\",\"width\":1920,\"height\":1355,\"caption\":\"Image by Gerd Altmann from Pixabay\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pwvconsultants.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Lost Art of ETL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#website\",\"url\":\"https:\/\/www.pwvconsultants.com\/blog\/\",\"name\":\"PWV Consultants\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pwvconsultants.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#organization\",\"name\":\"PWV Consultants\",\"url\":\"https:\/\/www.pwvconsultants.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/04\/logo-alternate-e1585773530392.png\",\"contentUrl\":\"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/04\/logo-alternate-e1585773530392.png\",\"width\":98,\"height\":84,\"caption\":\"PWV Consultants\"},\"image\":{\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/PWV-Consultants-110444033947964\",\"https:\/\/twitter.com\/PWV_Consultants\",\"https:\/\/www.linkedin.com\/company\/pwv-consultants\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/c15d5d40126a8ad906cb3067de95f8d4\",\"name\":\"Pieter VanIperen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b294918257a810803e2befc9a71b7bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b294918257a810803e2befc9a71b7bc?s=96&d=mm&r=g\",\"caption\":\"Pieter VanIperen\"},\"description\":\"PWV Consultants is a boutique group of industry leaders and influencers from the digital tech, security and design industries that acts as trusted technical partners for many Fortune 500 companies, high-visibility startups, universities, defense agencies, and NGOs. Founded by 20-year software engineering veterans, who have founded or co-founder several companies. PWV experts act as a trusted advisors and mentors to numerous early stage startups, and have held the titles of software and software security executive, consultant and professor. PWV's expert consulting and advisory work spans several high impact industries in finance, media, medical tech, and defense contracting. PWV's founding experts also authored the highly influential precursor HAZL (jADE) programming language.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/pwv-consultants\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Lost Art of ETL - PWV Consultants","description":"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.","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.pwvconsultants.com\/blog\/the-lost-art-of-etl\/","og_locale":"en_US","og_type":"article","og_title":"The Lost Art of ETL","og_description":"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.","og_url":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/","og_site_name":"PWV Consultants","article_publisher":"https:\/\/www.facebook.com\/PWV-Consultants-110444033947964","article_published_time":"2020-08-06T17:30:00+00:00","article_modified_time":"2020-08-05T23:36:20+00:00","og_image":[{"width":1920,"height":1355,"url":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg","type":"image\/jpeg"}],"author":"Pieter VanIperen","twitter_card":"summary_large_image","twitter_creator":"@PWV_Consultants","twitter_site":"@PWV_Consultants","twitter_misc":{"Written by":"Pieter VanIperen","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#article","isPartOf":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/"},"author":{"name":"Pieter VanIperen","@id":"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/c15d5d40126a8ad906cb3067de95f8d4"},"headline":"The Lost Art of ETL","datePublished":"2020-08-06T17:30:00+00:00","dateModified":"2020-08-05T23:36:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/"},"wordCount":889,"publisher":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg","keywords":["coders","data","data management","Database","Datastore","Developers","ETL","extract transform load"],"articleSection":["Coding","Data Stores","Information Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/","url":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/","name":"The Lost Art of ETL - PWV Consultants","isPartOf":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage"},"image":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg","datePublished":"2020-08-06T17:30:00+00:00","dateModified":"2020-08-05T23:36:20+00:00","description":"Extract, transform and load is a lost art among developers and coders. The process needs to be revitalized for proper database use.","breadcrumb":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#primaryimage","url":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg","contentUrl":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/08\/The-Lost-Art-of-ETL.jpg","width":1920,"height":1355,"caption":"Image by Gerd Altmann from Pixabay"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pwvconsultants.com\/blog\/the-lost-art-of-etl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pwvconsultants.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Lost Art of ETL"}]},{"@type":"WebSite","@id":"https:\/\/www.pwvconsultants.com\/blog\/#website","url":"https:\/\/www.pwvconsultants.com\/blog\/","name":"PWV Consultants","description":"","publisher":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pwvconsultants.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pwvconsultants.com\/blog\/#organization","name":"PWV Consultants","url":"https:\/\/www.pwvconsultants.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/04\/logo-alternate-e1585773530392.png","contentUrl":"https:\/\/www.pwvconsultants.com\/blog\/wp-content\/uploads\/2020\/04\/logo-alternate-e1585773530392.png","width":98,"height":84,"caption":"PWV Consultants"},"image":{"@id":"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PWV-Consultants-110444033947964","https:\/\/twitter.com\/PWV_Consultants","https:\/\/www.linkedin.com\/company\/pwv-consultants"]},{"@type":"Person","@id":"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/c15d5d40126a8ad906cb3067de95f8d4","name":"Pieter VanIperen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pwvconsultants.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b294918257a810803e2befc9a71b7bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b294918257a810803e2befc9a71b7bc?s=96&d=mm&r=g","caption":"Pieter VanIperen"},"description":"PWV Consultants is a boutique group of industry leaders and influencers from the digital tech, security and design industries that acts as trusted technical partners for many Fortune 500 companies, high-visibility startups, universities, defense agencies, and NGOs. Founded by 20-year software engineering veterans, who have founded or co-founder several companies. PWV experts act as a trusted advisors and mentors to numerous early stage startups, and have held the titles of software and software security executive, consultant and professor. PWV's expert consulting and advisory work spans several high impact industries in finance, media, medical tech, and defense contracting. PWV's founding experts also authored the highly influential precursor HAZL (jADE) programming language.","sameAs":["https:\/\/www.linkedin.com\/company\/pwv-consultants"]}]}},"_links":{"self":[{"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/posts\/625"}],"collection":[{"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/comments?post=625"}],"version-history":[{"count":3,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/posts\/625\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/posts\/625\/revisions\/633"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/media\/630"}],"wp:attachment":[{"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/media?parent=625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/categories?post=625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pwvconsultants.com\/blog\/wp-json\/wp\/v2\/tags?post=625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}