Technology & Compatibility
Vivid Reports: CPM is built on the Microsoft technology stack. As a Microsoft Gold Certified ISV, all of the application code is written in Microsoft .Net. We utilize our proprietary database / warehouse, which runs on Microsoft SQL Server, and the client consists of a Microsoft Excel Add-In and a .Net application for the administration interface (all accessible from the Add-In). Our technology is professionally designed, developed and tested by our team of expert software engineers.
Product direction, including new features and functionality, is primarily driven by the feedback we receive from our extensive user base. We also rely on our in-house accountants, business experts and partners. We constantly research emerging technologies, new releases of ERP and upgrades to the various platforms we employ (Excel, SQL Server, Windows) to keep ahead of the curve. We’re also continuously researching our software solutions to enable improvements and enhancements to provide a better overall user experience.
Our extensive experience with numerous ERP and the various environments, technologies and platforms means that we can integrate our system with just about any ERP or General Ledger data source. To date, we have integrated with over 19 ERP systems, including systems that are based on Microsoft, IBM, Oracle and SAP.
Vivid Reports : CPM addresses several limitations of existing CPM software solutions and is designed to handle large databases, reports, complex scenarios (both Accounting and IT) and support a large number of users without requiring long wait times or massive computing power when someone requests a report. Vivid Reports: CPM is truly an extremely flexible, easily deployed and affordable CPM solution.
Our software is built using two components, a database that installs on SQL Server and an Excel Add-In that installs on an Excel client. Vivid Reports: CPM uses the same system requirements provided by Microsoft for SQL Server and Excel. Therefore, you rarely need to purchase new hardware to support Vivid Reports: CPM.
(Click arrows to expand.)
Microsoft SQL Server
Vivid Reports: CPM supports SQL Server 2000, 2005, 2008, and 2008 R2. For SQL 2000 you need to be on SP4. All sub-versions of each SQL Server generation are also supported (Express, Standard, Enterprise, etc.). Vivid Reports: CPM requires Microsoft SQL Server to run and no other database systems are supported. SQL Server 2008 R2 – Express has a free license and allows up to 1 GB of RAM and 10 GB of database size. This is often adequate for more simple installs.
Server Operating System
As long as SQL Server is installed Vivid Reports: CPM will be compatible with the Server O/S including 64 bit versions.
Vivid Reports: CPM is often deployed through either Citrix Server or Microsoft Terminal Services. An advantage of using terminal software to deploy Excel and Vivid Reports: CPM is that you do not have to install or upgrade Vivid Reports: CPM on multiple machines.
Server Disk Space Requirements
The bulk of the data in Vivid Reports: CPM relates to the General Ledger Transactions. As a general rule if you allow for 3GB of hard drive space for every 1,000,000 transactions you should be more than fine. Also performing a backup of Vivid Reports: CPM on a nightly basis will keep the log file reduced to minimum size as the Vivid Reports: CPM database is set to “simple recovery mode” by default. Also note that in Vivid Reports: CPM, you can purge transactions for historical years but retain the balances for comparison on your reports. Often one to two years of transactions are adequate for detailed analysis.
Vivid Reports: CPM supports Excel 2003 SP2, 2007 and 2010 (including 64 bit versions). There is a different client install for each version of Excel. Only one version of Vivid Reports: CPM can be installed per computer at a time therefore you cannot have Vivid Reports: CPM running in Excel 2003 and Excel 2010 from the same computer. Vivid Reports: CPM is currently not compatible with any other spreadsheet programs such as Star Office, Open Office or Google spreadsheets.
As long as Excel is installed Vivid Reports: CPM will be compatible with the Client O/S email option of Report Automation: The email automation feature is only compatible with Microsoft Outlook at this time.
ERP (Accounting System)
Vivid Reports: CPM is compatible with many different ERPs and versions, including non-SQL based systems. Before you upgrade or change your ERP system please contact us. We can also assist you with the backup and restore of the Vivid Reports: CPM database whenever SQL Server or Server Hardware is upgraded.
Active Directory can be used by Vivid Reports: CPM to make the login more convenient for your users. However, Vivid Reports: CPM has separate security from the ERP and will not utilize the security settings that have already been defined. This is because Vivid Reports: CPM has more granular security settings than the ERP and you can also deploy Vivid Reports: CPM to users without requiring them to have an ERP license.
Vivid Reports: CPM UNITY is a version that provides an open interface to easily integrate the Vivid Reports: CPM platform with virtually any ERP or General Ledger (G/L) data source. UNITY is great for organization that:
- Run older or obscure ERP systems
- Run multiple systems and add new systems as a result of acquisitions
- Run systems that are difficult to integrate with or extract data from
- Need to restructure their G/L or add other elements for reporting without changing their systems
- Want to extend the Vivid Reports: CPM integration or provide Vivid Reports: CPM to their user base