ETL is the process of extracting data from various sources, such as log files or operational database tables, transforming the data per the analytical requirements, and then load the transformed data to data warehouse, which supports users’ business intelligence analysis requirements.
￼The ETL Agent is a highly customized software utility designed to extract and pre-process data from multiple sources. Output of the ETL Agent process is a set of CSV files which are then uploaded to the ETL Engine for further processing. This design significantly minimizes number of simultaneous database connections needed.
ETL Engine loads transformed data to data warehouse by through bulk insertion, which improves the overall ETL process throughput.
DrivenBI works closely with its partners to analyze requirements, design schema for data warehouse, and develop ETL process that transports data from partner’s operational data source(s) to the iDMS data warehouse.
iDMS comes with built-in authentication mechanism that utilizes Acegi Security, which provides comprehensive security for enterprise Java application. Furthermore, iDMS also support integrating with external authentication mechanism such LDAP to accommodate partners’ requirements such as single sign-on.
iDMS secures reports and shared data, such as folders, images, data connection, and report’s filter based on users and roles. iDMS offers role-based authorization which makes securing data over a group of users extremely easily. The data in repository is secured based on access control list (ACL) that could be configured at either user level or role level.
iDMS provides friendly web-based administration UI to for users to configure access privileges such as read, write, and delete, against objects residing in iDMS repository.
With JasperReports, iDMS offers reports that have flexible layout and can export reports to different formats (PDF, HTML, XLS, CSV, and RTF). To better support business needs, reports can be parameterized so that users can perform flexible analysis such as analyzing data for a particular period of time or filtering the data by sales per state or sales per person.
DrivenBI actively communicate with its partners throughout the entire life cycle of the report template design process to make sure the produced reports would fulfill business requirements.
User Defined Report
iDMS also offers the capability to create ad-hoc reports geared toward fulfilling more specific analytical needs. iDMS provides a user-friendly AJAX enabled report designer. Users are able to add and remove fields, group and sort data, configure field display order, calculate subtotals, filter results, and so on and so forth. With the report designer, business users can easily create their own reports without burdening IT or application developers.
No analysis is complete without charts. With the easy-to-use analytics designer provided by iDMS, users are able to create charts on the fly. iDMS offers 5 type of charts: pie, bar, stacked bar, lines, and area. Users can specify threshold such as >, >=, <, <=, top N, and bottom N by a specific number or percentage limit. To further refine the results, users are also allowed to add additional filters to narrow down the results showing on the chart. Similar to user-defined report, the analytics designer will save IT or application developers’ effort by letting business users create their own charts to serve their own analytical needs.
Dashboard displays a combination of different types of reports and chart and thereby forming a single, integrated view that illustrates the big picture of users analyses. iDMS provides dashboard designer for users to easily combine different types of reports and/or a mash-up with external content. Dashboards in iDMS automatically refresh in real-time to make sure users always looking at the up-to-date information.
iDMS extends the reporting and analytic functionality with the addition of the drilldown capability. Drilldown provides users ability to interact with their report data via a multidimensional view. Furthermore, iDMS supports hierarchy drilldown by a set of related elements. By applying drilldown to a report, users are able to redirect their focus into detailed data that provides more insights.
With a built-in scheduling service, iDMS has the ability to periodically execute reports and automatically distribute them through emails.
The scheduling service can be configured to run only once, or to run recurrently by specifying intervals such as how many times, every N minutes or hours, and more flexible configuration based on calendar.
Based on user-defined schedule, reports can be exported into various formats (PDF, HTML, XLS, CSV, and RTF) and then saved into iDMS repository. Users can either view the exported reports in iDMS or have them send to others as email attachments. With automatic emailing capability in iDMS, these reports can easily be made accessible to anyone from anywhere, without the need of having an account in iDMS. Ultimately serves the purpose of fast and in time business decision making.