Dozie & Associates

OLAP allows users to discovery new insights using BI applications like Business Objects and Microsoft SSRRS and SSAS.  MOLAP  traditionally can be implemented as cube  but newer technologies has made it possible to design MOLAP in a  tubular format similar to pivot tables with the introduction of SSAS 2012 which is much easier. MDX queries can be called within Stored Procedures, User-defined Functions and Views using linked server. This gives the user the ability to manage the output in various format. Users  without knowledge of MDX queries  can utilized these database objects for various reports.  Learning  to write MDX queries can be hard for non technical experts. The link server has to be created first in the process between the host SQL Database and SSAS Cube. For this demonstration SQL Server 2008 is being utilized. Normal MDX query Notice the difference between MDX and regular TSQL or SQL Statements. You have to...

In the following series SSIS would be utilized to extract data from Stored Procedure which contain query that is linked with SSAS MDX query via linked Server. Talend requires additional components while SSIS has fewer components but the output is the same. First process in extracting the query through SSAS via Linked Server is to create a linked server. Linked Server Second process is to create the stored procedure to extract the data. Stored Procedure definition with the MDX and regular SQL qeury Third process is to create an SSIS package. In the Control Flow component you need  two task which the Execute SQL Task and Data Flow task.  The fourth step is to create the database connection to the source and destination systems. In this case only one database system is being utilized. Another big difference between SSIS and Talend is that Talend  works well with JDBC but JDBC is allowed in SSIS rather .NET, OLED, ODBC etc which makes t...