The Professional Data Warehouse acts as a warehouse for your vital information, allowing you to extract only the key data you want to report on. By capturing only the data you need, you eliminate the time-consuming task of sifting through irrelevant information and can focus on business at hand. It also contains vital budgeting and scheduling capabilities, along with special security features to ensure that only authorized personnel have access to key data.
The Enterprise Data Warehouse is designed for large enterprises that require an elevated set of functionalities. It contains all of the components in the Professional Data Warehouse plus the ability to connect and integrate with other non-ACCPAC applications via the Universal Database Access (UDA) component, which provides access to any ODBC-compliant database. It also includes replication capabilities that let you synchronize your data warehouse across multiple locations - making key information even more accessible to employees across the enterprise.
Professional Data Warehouse
The Professional Data Warehouse contains the following components:
Budget Express
Budget Express turns an ACCPAC Insight report into a fully functional budget model workbook. It provides a quick and easy way to define up to five basic spread methods, automatically defines mapping to the Data Mart based on a users’ chart of account structure and more.
Scheduling
Scheduling makes it easy to automate the execution of specific reports by naming date, time and report parameters that are applied to the execution of each report. You can even schedule reports to run after business hours to take advantage of underutilized computing resources that typically sit idle during this time.
Security
Security provides access (in SQL Server only) based on a clearly defined reporting structure. Security is implemented at the account, not the report, structure level. For example, Security limits what data users can see, not what reports they can request. Users are assigned to profiles, and when reports are run, access is only granted to the rows in the database or Data Mart as indicated by users' assigned profiles.
Workbook Generator
Workbook Generator automatically creates procedures for generating reporting or budgeting workbooks from any valid database. It contains all the information needed to allow the distribution of workbooks, providing a single source of maintenance. It can run manually, or be scheduled using any scheduling tool, including ACCPAC Alerts (ACCPAC Advantage Series) and ACCPAC Pro Alert™ (ACCPAC Pro Series).
Workbook Refresher
You can schedule a workbook for automated refreshing with the Workbook Refresher.
Write Back
Write back captures data from an Excel file and writes it to the data warehouse. For example, it can capture budget information from all departments and divisions and store it in the data warehouse for future reference.
Enterprise Data Warehouse
The Enterprise Data Warehouse contains all of the components in the Professional Data Warehouse as well as the following:
Data Mart Generator
Data Mart Generator creates tailored Data Marts from existing databases, automates and schedules the publishing of Data Marts, synchronizes one or more Data Mart(s), summarizes reporting structures and provides access via Microsoft SQL Server and Access.
Universal Database Access
You can integrate data from other applications and databases into your ACCPAC Insight reporting system using UDA and drill down and "drill around" the data. With UDA, you can use ACCPAC Insight to report on all of your enterprise data stores, including legacy applications and propriety software systems.
