Historically, one of the barriers to even starting BI projects was the sheer volume of work that would come with it. In the present day, many of us have custom inhouse BI solutions that are too complex to update or modify with the changing needs of our company. We shudder to think what would happen if we needed to adjust to new business processes, change the level of granularity in a fact table, or implement new measures. By automating ETL code generation, the Jet Data Manager, JDM, allows developers to focus on data modeling and transformation, but recreating an already finished Data Warehouse and Cube from scratch--complete with measures, dimensions, and hierarchies--may still be too significant a deterrent to invest in converting to the JDM. With the ability to reverse engineer OLAP cubes and create the supporting DataWarehouse, the JDM reseats itself as a superior Data Automation tool, even for vendors with significant capital invested in an existing multidimensional project executed with other backend tools. As indicated in the video, once reverse engineering is complete, developers will still need to define the ETL for data extraction and transformation. But fortunately, the JDM has a myriad of features that will facilitate recycling existing code, including the ability to create custom views, integrate stored procedures, user defined functions and scripts. Rebuilding your BI project using the Jet Data Manager allows the best of two worlds, you can recycle significant portions of existing code, while taking advantage of the JDM's major selling points including automatic project documentation, versioning, ease of integrating multiple datasources, scheduling tools, and of course automated ETL code generation. Although the process of rebuilding a project may seem unpleasant, your ability to respond to user's business needs is unparalleled, and truly TIME to implement customizations is where the JDM outshines competition.
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
Categories
All
|