Canvas can connect to any Data Warehouse, Data Mart or any other database containing business data. Canvas supports Oracle, DB2, Sybase, SQL Server and MySQL databases.
Canvas is an Enterprise Java Web application, and a pure Java implementation that can be installed and configured on various application servers on any Operating System with Java EE Virtual machine environment. This gives the advantage of installing the software on your existing software infrastructure instead of investing on the new one.
Canvas is an easy-to-use, yet powerful Business Intelligence tool which can be used by an average user. Business users can search data from the database even without the knowledge of SQL. With a short learning curve, users can set up templates, catalogs and dashboards for frequent access of analytical information.
Canvas provides option to preformat Excel files, which are the most widely used business file format, to get the desired reports.
Canvas is designed to protect huge amounts of data and analysis assets in your organisation using powerful access control management functions that also tracks the action of each user.
Query Builder is a powerful component in Canvas that helps you generate queries with just a few clicks. It allows to search for required data from relevant tables easily without writing tedious SQL commands.
SQL Editor allows you to manually write SQL Queries thus providing full control to the query writer. This is the most favourite functionality of Canvas of for advanced users who wants full control on what they do.
Data search done using Query Builder or SQL Editor can be saved as Templates for reusing them. Result of a query can be directed to a pre-formatted Excel workbook to get customized report instantly.
Canvas has many useful analysis functions where data can be grouped, sub totalled, and filtered as required.Canvas dashboards feature shows various interpretations of the data in the form of charts and data grids.
All the data in the world won’t help if it cannot be easily interpreted. Canvas Dashboard provides various styles to represent query templates graphically.
A user friendly design propels Canvas to be used by everyone in a company it can be used by Employees, Managers, Leaders, Management Members and IT Administrators