{"id":2588,"date":"2022-01-07T10:15:54","date_gmt":"2022-01-06T22:15:54","guid":{"rendered":"https:\/\/hartit.io\/?p=2588"},"modified":"2022-01-07T10:19:05","modified_gmt":"2022-01-06T22:19:05","slug":"what-is-a-data-warehouse","status":"publish","type":"post","link":"https:\/\/hartit.io\/what-is-a-data-warehouse","title":{"rendered":"What is a data warehouse?"},"content":{"rendered":"<p>What is a data warehouse, and when do you need one?<\/p>\n<p>There&#8217;s many uses for data warehouses but I&#8217;m gonna talk about when we need to use them for dashboards \ud83d\udcca.<\/p>\n<p>Usually it&#8217;s when the software you want to connect to has a bad API, which stands for Application Programming Interface, and is a topic for another day!<\/p>\n<p>Sometimes it&#8217;s bad because they want to limit how you use it \ud83e\udd10<\/p>\n<p>Sometimes it&#8217;s bad because the software is poorly coded \ud83e\udd21<\/p>\n<p>Similar to above, sometimes it&#8217;s bad because they made poor decisions when they were designing the software and now they&#8217;re stuck with it \ud83d\ude29 Xero admit this in their API documentation!<\/p>\n<p>Sometimes it&#8217;s bad because they&#8217;re cheap skates and don&#8217;t want to accommodate other software querying it \ud83d\ude24<\/p>\n<p>Sometimes it&#8217;s bad because the software is so old it&#8217;s amazing it even has an API \ud83d\udc74<\/p>\n<p>Anyway, when we come across a piece of software like this, a method that we can use to get around it is use a data warehouse \ud83c\udfe2<\/p>\n<p>This is a piece of software that sits in the middle and works with the bad API, coaxing and cajoling it to give up it&#8217;s data, and then stores it in another place, usually a SQL database or similar.<\/p>\n<p>Now your data is arranged logically and neatly and we can then make simple and fast \ud83c\udfce SQL queries to get the data.<\/p>\n<p>You can also use it for other purposes than a dashboard, for example updating your website \ud83d\udd78 If we can&#8217;t connect to your software then your web designer probably can&#8217;t either.<\/p>\n<p>By the way these are the bits of software that we sometimes need to use data warehouses for:<\/p>\n<ul>\n<li>Cin7<\/li>\n<li>HubSpot<\/li>\n<li>MYOB AccountRight<\/li>\n<li>Simpro<\/li>\n<li>Xero<\/li>\n<\/ul>\n<p>Usually we will know up front if we need to use a data warehouse and will include it in the fixed price quote.<\/p>\n<p>Sometimes it only becomes apparent after we&#8217;ve started your dashboard. Because it is an additional cost, we always give our customers the option to cancel the project and receive a full refund.<\/p>\n<p>And just like a normal warehouse, you need to be careful how you store and move your data, otherwise you&#8217;ll end up with a mess!<\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is a data warehouse, and when do you need one? There&#8217;s many uses for data warehouses but I&#8217;m gonna talk about when we need to use them for dashboards \ud83d\udcca. Usually it&#8217;s when the software you want to connect&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2587,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[58],"tags":[],"_links":{"self":[{"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/posts\/2588"}],"collection":[{"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/comments?post=2588"}],"version-history":[{"count":4,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/posts\/2588\/revisions"}],"predecessor-version":[{"id":2592,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/posts\/2588\/revisions\/2592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/media\/2587"}],"wp:attachment":[{"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/media?parent=2588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/categories?post=2588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hartit.io\/wp-json\/wp\/v2\/tags?post=2588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}