The future of ODBC, OLE DB, and OLE DB for OLAP (ODBO)

April 4, 2012 facebooktwittergoogle_plusredditpinterestlinkedinmail by in Interoperability   JDBC   Multi-Dimensional Data Connectivity   ODBC   OLAP   OLE DB for OLAP   Relational Database Connectivity   XML for Analysis   XMLA  

With Simba being the leader in data access and data analytics and having worked on many data connectivity standards, people often ask me about which open data access standards they should invest in.

For relational connectivity, the two data access standards of course are ODBC and JDBC.

For multidimensional connectivity, the data access standards are ODBO and XMLA.

This past week as Microsoft launched SQL Server 2012, they sounded the death knell for OLE DB.  OLE DB was supposed to replace ODBC but in fact, it is now ODBC that is replacing OLE DB.  Deja vu.

Stephen Swoyer at TDWI wrote a very good article explaining what I have summed up above.  You can read what Stephen wrote about Microsoft's directions on ODBC, OLE DB, and ODBO.