During their experience gained from working on implementation projects, the founders of AnalyticsCreator recognized a market need and the possibility to develop a framework to automate data warehouse creation and loading. They built a code framework in 2008, which they began to use in customer projects. However, the company AnalyticsCreator was not founded until 2017, by which point the framework had been rebuilt into a UI-based product and the vendor was able to promote it commercially.
Today the company – headquartered in Munich, Germany – employs nine people who are mainly focused on software development and marketing. Overall, the vendor serves more than 100 direct customers and has additional customer projects that have been implemented by partners. In general, the company is partneroriented. The software mainly helps consulting companies to implement data warehouse systems in shorter time frames than in the past. Therefore, the majority of AnalyticsCreator customers are actually systems implementers. AnalyticsCreator is 100 percent committed to Microsoft and aims to be among the best in this environment.
The software is designed for creating data warehouses for Microsoft SQL Server or the cloudbased databases Azure SQL and Azure Synapse. AnalyticsCreator is independent of the modeling concept. Customers are free to use Kimball, Data Vault or other modeling methodologies for this. Besides layers created for Microsoft SQL Server or in Azure, the solution supports the preparation of data marts for a number of BI front ends. For example, customers can automatically generate data models for Microsoft Power BI, Tableau, Looker, Cognos TM1 and Qlik Sense. Once a data warehouse environment with the appropriate data marts is set up, the runtime of the customer’s choice can be chosen for deployment. AnalyticsCreator sees itself as a design time and not a runtime environment. After initial implementation, customers may continue using AnalyticsCreator for the further development of their data warehouse system.
AnalyticsCreator’s eponymous product consists of two main components: A Windows client and a cloudbased service. The first is used to customize the data warehouse. Users can connect to data sources, declare the data semantics and set model-specific parameters. The model data is deployed to a cloudbased service called ‘AnalyticsCreator Cloud Generator’, which generates the database code and structures. The use of cloud services also opens up the possibility of sharing repositories and exchanging DW artifacts or working on data warehouse models in a distributed manner. The usability of the generated code is also worth mentioning. Generated code can still be used and processed after the AnalyticsCreator license expires. AnalyticsCreator is continuously expanding its integration with the Microsoft world.
User & Use Cases
AnalyticsCreator has a clear focus on data warehouse automation, especially data integration, which is reflected in the survey results. All the AnalyticsCreator users responding to this survey use it for ‘data integration (ETL/ELT)’, while 95 percent use it for ‘data warehousing / BI’ and ‘data warehouse automation’. The main effort in data ware-housing lies in data integration, which is undertaken by 79 percent of respondents. Data integration is where au-tomation can really pay off and save time and money. The tool is mainly used by implementers, and therefore a small number of experts and users is usual. AnalyticsCreator is still available exclusively on Microsoft platforms, with only a third now using the solution on-premises. AnalyticsCreator is now reaching significantly more mid-sized companies than it was last year, at least according to our survey results. 11 percent of respondents came from companies with more than 2,500 employees: the same as last year. 47 percent of respondents use the tool several times day, and another 26 percent use it several times a week.
Want to see the whole picture?
BARC’s Vendor Performance Summary contains an overview of The Data Management Survey results based on feedback from AnalyticsCreator users, accompanied by expert analyst commentary.Contact us to purchase the Vendor Performance Summary