Connect OData in looker

  • 25 June 2019
  • 1 reply

Popular BI Tools like MS Excel, Tableau, etc all support Odata connections for bringing in data. Does looker too support OData connection? If yes, how?

1 reply

Userlevel 7
Badge +1

Trying to wrap my head around OData, so I might be totally missing the mark. It looks like OData is a way to interact REST APIs that lends a little more structure, kind of creating a DB-like environment while still directly hitting the API? Correct me if I’m wrong 🙂.

Looker only supports connecting to databases that speak SQL, so you’d have to incorporate an ETL step to get data from your OData source into a DB. A nice Looker rule of thumb is that if it speaks SQL, Looker can read from it directly, and if it’s not SQL, then you’ll need some kind of intermediary step to get it in a SQL database.