OLE DB for OLAP (Object Linking and Embedding Database for Online Analytical Processing abbreviated ODBO) is a Microsoft published specification and an industry standard for multi-dimensional data processing. ODBO is the standard application programming interface (API) for exchanging metadata and data between an OLAP server and a client on a Windows platform. ODBO extends the ability of OLE DB to access multi-dimensional (OLAP) data stores.[citation needed]
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]
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]
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]
The OLAP Report – Independent research resource for organizations buying and implementing OLAP applications
December 17, 2023
olap, this, article, does, cite, sources, please, help, improve, this, article, adding, citations, reliable, sources, unsourced, material, challenged, removed, find, sources, news, newspapers, books, scholar, jstor, february, 2012, learn, when, remove, this, t. This article does not cite any sources Please help improve this article by adding citations to reliable sources Unsourced material may be challenged and removed Find sources OLE DB for OLAP news newspapers books scholar JSTOR February 2012 Learn how and when to remove this template message OLE DB for OLAP Object Linking and Embedding Database for Online Analytical Processing abbreviated ODBO is a Microsoft published specification and an industry standard for multi dimensional data processing ODBO is the standard application programming interface API for exchanging metadata and data between an OLAP server and a client on a Windows platform ODBO extends the ability of OLE DB to access multi dimensional OLAP data stores citation needed Contents 1 Description 2 See also 3 References 4 External linksDescription editODBO 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 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 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 See also editXML for AnalysisReferences editExternal links editMicrosoft Developed ODBO standard MSDN Multidimensional Expressions Reference The OLAP Report Independent research resource for organizations buying and implementing OLAP applications Retrieved from https en wikipedia org w index php title OLE DB for OLAP amp oldid 1166019356, wikipedia, wiki, book, books, library,
