& data warehouse automation software founded auckland nz 1997 headquarters auckland new zealand portland oregon usa reading united kingdom singapore singapore key people michael whitehead mark budzinski mark otten david morris roger walton miriam cook rob mellor marc demarest aaron parvin abby dowd philip rock products wherescape red wherescape 3d number of employees 100 website www.wherescape.com wherescape is a privately held international data warehousing & big data software company with offices in auckland new zealand portland oregon usa reading united kingdom pune india & singapore . contents 1 history 2 wherescape products 2.1 wherescape red 2.2 wherescape 3d 3 references 4 external links history edit wherescape was originally founded as a data warehouse consulting company in auckland new zealand 1 in 1997 by co founders michael whitehead ceo and wayne richmond cto . 2 the company was formerly named profit management systems but officially renamed to wherescape in 2001 when expanding business operations into the usa . 2 wherescape operate out of regional headquarters in auckland new zealand ; portland oregon usa ; reading united kingdom ; and singapore . 1 as of 2015 the company has over 720 customers in more than 15 countries and a turnover of around 20 million nzd . 3 sales channels vary by country but can be either direct sales or through local partners . wherescape also have partnerships with third party companies that embed wherescape software in their solutions . 4 wherescape products edit wherescape s products are used in business intelligence projects in commercial environments . project applications include normal form enterprise data warehouses data vaults data marts and reporting systems . 5 wherescape red edit this integrated development environment ide is used for building deploying managing and renovating data warehouses and data marts . 6 wherescape red unites source system exploration etl dimensional and normal form target schema design and dependent cube building construction with an integrated operations and management environment and a metadata repository all build and operate metadata is customizable rewritable and stored in a central managed and versioned repository . 7 the software creates a repository database for business data data warehouse metadata and code one of the supported database platforms microsoft sql server ibm db2 or oracle or on a teradata data warehouse appliance . unlike etl tools such as business objects data services or sql server integration services which generally use an in memory pipeline to process data red leverages the database platform for data manipulation . the software automatically generates much of the sql code required to process data into the required data model . wherescape 3d edit wherescape 3d is a data driven design tool used in planning and reality testing for data warehousing and business intelligence projects . the product produces project design documentation and an implementation ready design through the process of source and target exploration and modelling usability and data legibility and scoping sizing and costing activities . wherescape 3d is compatible with wherescape red for automated build out or can be used for input to a manual build or a third party tool set . 8 references edit a b pamatatau r. 20 jan 2004 . wherescape sets up for european sales campaign . the new zealand herald . a b nikiel c. 19 nov 2007 . what when why and wherescape . the new zealand herald . christopher adams 30 jan 2014 . nzx listing on cards for wherescape . the new zealand herald . wherescape is helping businesses put data into their decision making . . new zealand trade & enterprise . retrieved 7 november 2013 . humphrey s. 14 feb 2011 . wherescape launches new solution for sql server fast track data warehouse 3.0 . business wire . teradata partner . teradata . retrieved july 19 2011 . klebanov r. 2 feb 2011 . getting agile with wherescape red and balanced insight consensus . humphrey s. 20 may 2011 . wherescape introduces data driven design tool . business wire . external links edit official website retrieved from https en.wikipedia.org w index.php title wherescape & oldid 675990760 categories business intelligence companiessoftware companies of new zealanddata warehousing productsextract transform load toolshidden categories articles created via the article wizard navigation menu personal tools not logged intalkcontributionscreate accountlog in namespaces article talk variants views read edit view history more search navigation main pagecontentsfeatured contentcurrent eventsrandom articledonate to wikipediawikipedia store interaction helpabout wikipediacommunity portalrecent changescontact page tools what links hererelated changesupload filespecial pagespermanent linkpage informationwikidata itemcite this page print export create a bookdownload as pdfprintable version languages add links this page was last modified on 14 august 2015 at 00 26 . text is available under the creative commons attribution sharealike license ; additional terms may apply . by using this site you agree to the terms of use and privacy policy . wikipedia is a registered trademark of the wikimedia foundation inc. a non profit organization . privacy policy about wikipedia disclaimers contact wikipedia developers cookie statement mobile view