Profitbase Studio is a configuration tool for quick and easy deployments of Data Marts, Data Warehouses and SSAS Multidimensional and Tabular models on Microsoft SQL Server. Profitbase Studio provides a graphical configuration environment that speeds up and yet simplifies Data Warehouse deployments, maintenance and upgrades reducing deployment time, risks and total cost of ownership.
Profitbase Studio also represents a new way of deploying business oriented solutions by using Business Templates to reduce the time from business decision to deployed solution.
What you see is what you get. See how your data looks along the way, so you do not get any surprises when output is generated. Having one interface for your solution, across technologies like SQL, SSIS and SSAS, makes collaboration easier and the system less person-dependent. Understanding your Data Warehouse has never been easier.
Profitbase Studio can leverage templates for mapping against source systems like Dynamics AX, and for modules like Finance providing the most used MDX calculations. This helps you cut development time, and enables fast prototyping.
Profitbase Studio lets you configure and execute ETL jobs using SSIS or OpenQuery (linked server) technology making your day easier. Pull data from different sources like MS SQL, Oracle, and many database technologies in addition to Excel or flat files and the like. Scheduling and notifications are also supported through SQL Server Agent and related technology.
Profitbase Studio keeps track of dependencies in your solution, so that objects cannot be inadvertently deleted, by yourself or others. Having a robust and at the same time complex solution comes with many challenges. Profitbase makes development easier, more productive, and at the same time helps you avoid bugs compared to programming from scratch.
Profitbase Studio will log every move, so that you can monitor and debug both while developing and with scheduled jobs. Logs exist in SQL Server tables, so that you can pick up statuses and flags from any centralized tool if desirable.
Create detailed batches, with actions for exceptions and notifications. These batches are pushed to SQL Server Agent for scheduled execution.