In this article we will see how to use ADOMD to interact with an Analysis Services cube.
ADOMD.NET is an extension of ADO.NET. It's a data provider Microsoft .NET Framework that is designed to communicate with Microsoft SQL Server Analysis Services.
Using this extension, we can read the multidimensional schema, query cubes, and retrieve results.
We always talk about STG and ODS in BI archi, so what is the role of these two phases in a BI archi?
- STG (Staging Area): is a set of tables which represent a true copy of the data source and which are purged each time the ETL is run: it is a waiting area, a “boarding room” before the ODS phase; it is in these tables that we can find data in bizarre formats.
- ODS (Operating Data Store): is the place where the transformations, the crossings,… etc; before the power supply of the data warehouse and which uses the STG as a source.
Here is a small SQL script to remove all objects in a schema from a SQL Server database:
Read More Remove all objects from a diagram