View source for OLE DB for OLAP

'''OLE DB for OLAP''' (Object Linking and Embedding Database for Online Analytical Processing abbreviated '''ODBO''') is a [[Company:Microsoft|Microsoft]] published specification and an industry standard for multi-dimensional data processing. ODBO is the standard [[Application programming interface|application programming interface]] (API) for exchanging metadata and data between an OLAP server and a client on a [[Software:Microsoft Windows|Windows]] platform. ODBO extends the ability of [[OLE DB]] to access multi-dimensional (OLAP) data stores.{{Citation needed|date=February 2012}}

==Description==
ODBO is the most widely supported, multi-dimensional API to date. Platform-specific to Microsoft Windows, ODBO was specifically designed for Online Analytical Processing (OLAP) systems by Microsoft as an extension to Object Linking and Embedding Database ([[OLE DB]]). ODBO uses Microsoft’s Component Object Model.{{Citation needed|date=February 2012}}

ODBO permits independent software vendors (ISVs) and corporate developers to create a single set of standard interfaces that allow OLAP clients to access multi-dimensional data, regardless of vendor or data source. ODBO is currently supported by a wide spectrum of server and client tools.{{Citation needed|date=February 2012}}

When exposing the ODBO interface, the underlying multi-dimensional database must also support the MDX Query Language.  [[XML for Analysis]] is a newer interface to MDX Data Sources that is often supported in parallel with ODBO.{{Citation needed|date=February 2012}}

==See also==
*[[XML for Analysis]]

==References==
{{reflist}}

==External links==
*[http://www.microsoft.com/ Microsoft] – Developed ODBO standard 
*[http://msdn2.microsoft.com/en-us/library/ms145506.aspx/ MSDN] – Multidimensional Expressions Reference 
*[http://www.olapreport.com/ The OLAP Report] – Independent research resource for organizations buying and implementing OLAP applications 

[[Category:Computer programming]]
[[Category:Online analytical processing]]

{{Sourceattribution|OLE DB for OLAP}}