ODBC and JDBC are most popular Data APIs that IT organizations will be familiar with. Although, most ODBC and JDBC connectors talk directly to databases and most of them issue SQL queries in the database’s native dialect, things don’t have to work that way. Even a set of APIs can be translated to behave like a Database / Data API. The translated APIs are then no longer shallow—they can expose raw data in a BI-friendly manner.
Abstracting the REST API using Data APIs (the Database metaphor) is a popular trend that many IT teams are deploying in their organizations to access their business logic from the BI stack. If this sounds complicated, well, it can be if you don’t do it the right way.