Xero is the emerging global leader of online accounting software that connects small businesses to their advisors and other services. The cloud-based software is used in more than 180 countries by more than one million subscribers. As a data-driven organization from the top down, Xero employees constantly talk about data and how to leverage it. To support the data needs of the rapidly growing company, Xero first created a data warehouse on Microsoft SQL Server. Then, with a company move to AWS, the data warehousing team was tasked to migrate its data warehousing efforts to Amazon Redshift.
Xero initially selected WhereScape® RED to aid in its design, development, deployment and operation of a new Microsoft SQL Server data warehouse. With rapid success delivering the SQL Server data warehouse using automation, the team turned its attention to the cloud and was confident to use WhereScape once again. With a single developer tied to the effort, Xero was able to use WhereScape RED to migrate its SQL Server data warehouse to Amazon Redshift with six months of development effort – meeting a company-mandated deadline for all infrastructure to be ready for use on AWS.
– Nathan Griffiths, Data Services Platform Lead, Xero