rtdi / JDBCoData

An oData service for databases
Apache License 2.0
8 stars 5 forks source link

Can JdbcOdata be used as an ODATA source from MS PowerBI? #10

Open pbeltranl opened 2 years ago

pbeltranl commented 2 years ago

Hi,

It works against a custom relational database which is awesome.

I am now able to query tables and see records, count, metadata... from the browser.

How could this be used as a data source from MS PowerBI or other industry reporting & analytic tools?

Any guidance would be very much appreciated!

Pablo.

Bartman0 commented 1 year ago

did you try?: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-odata

It should work, unless Power BI uses some specific stuff that this library can't handle. I am using the library to support external data source querying from Salesforce successfully. With Snowflake as an underlying database, but you could use any JDBC capable database of course.

See: https://github.com/Bartman0/snowflake-odata

One important remark: I refactored it to work at the schema level, and not at the individual table level. But you could cherry pick stuff from there to get a working service in a Docker container. That's how I deploy it.

wernerdaehn commented 1 year ago

FYI: I have added a second kind of endpoint to expose all tables of a schema at once.

wernerdaehn commented 1 year ago

@pbeltranl Did you make any progress in testing it?