The future of ODBC, OLE DB, and OLE DB for OLAP (ODBO)April 4, 2012 by Amyn Rajan 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.