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?
https://www.odata.org/
Connect OData in looker
Userlevel 7
+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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.