Jet Data Manager (JDM)

The Data Warehouse Automation (DWA) platform for Jet Analytics. With the JDM you can transform and validate data from different data sources, consolidate them in a data warehouse, and build Online Analytical Processing (OLAP) cubes using a drag-and-drop interface. When you execute or deploy a BI project, the Jet Data Manager also automatically generates the underlying SQL code of your solution. With the Jet Data Manager you can access data from a variety of sources including ERP systems (such as Microsoft Dynamics), CRM applications, SQL databases, spreadsheets, and plain text files. The data is stored in a data warehouse in Microsoft SQL Server and can be viewed in your preferred front-end application such as Excel, Microsoft’s Power BI, the Jet Analytics mobile dashboard builder, or other third party applications.

» Business Intelligence Glossary