Has anybody tried to access EWB database with Microsoft PowerBI? How do you handle credentials?

George wrote:

> Has anybody tried to access EWB database with Microsoft PowerBI? How do you handle credentials?

I go the other way.  I present data I get from the powerBI azure cloud data instance.  I can do things faster and better in EWB than in PowerBI when you combine with the incredible graphing and other javascript tools available.

My users love my things, and they initially think they want PowerBI because of the marketing, but the really want data presented in useful ways.  They end up cursing PowerBI for its horrible speed and many limitations.  It can ALMOST do a lot of things well, but a real programer can do it all better.

Erick
EWB Programming Books and Component Library
http://www.erickengelke.com

erickengelke wrote:

George wrote:

> Has anybody tried to access EWB database with Microsoft PowerBI? How do you handle credentials?

We do export some local databases to PowerBI, but they are all MySQL based.  I think it uses an ODBC connector, not sure.  I don't know if there are ODBC connectors for Elevate's database, though I believe you can go the other way, and use MySQL for EWB server.  That's not something I've tried.

Erick
EWB Programming Books and Component Library
http://www.erickengelke.com

<<

George wrote:

Has anybody tried to access EWB database with Microsoft PowerBI? How do you handle credentials?

>>

Can you clarify what you are asking exactly ?  Only "EWB database" is the internal one for config/users/etc which is not accessible by external means today AFAIK.

For user data EWB can use EDB, DBISAM or OLE DB so it will depend on what you're actually using.

for EDB there are ElevateDB Data Access Components, DBISAM similarly has an ODBC driver.

Raul

Raul wrote:

Can you clarify what you are asking exactly ?  Only "EWB database" is the internal one for config/users/etc which is not accessible by external means today AFAIK.

For user data EWB can use EDB, DBISAM or OLE DB so it will depend on what you're actually using.

for EDB there are ElevateDB Data Access Components, DBISAM similarly has an ODBC driver.

Raul

Some of my clients are using PowerBI for their reporting and I was asked if it would be possible to connect to the datasets published by EWB. I am not sure if it possible to process the Authentication API of EWB within PowerBI in order to access these resources.

I would appreciate any help on this.

<< George wrote:

Some of my clients are using PowerBI for their reporting and I was asked if it would be possible to connect to the datasets published by EWB. I am not sure if it possible to process the Authentication API of EWB within PowerBI in order to access these resources.

I would appreciate any help on this.

>>

George,

Not directly no - EWB dataset API is specific to EWB and PowerBI would not know what to do with the payload.

However as I mentioned those datasets underneath would be either EDB, DBISAM or OLE DB - not sure what you're using specifically - and it would be possible to access to the underlying data using appropriate connection option (EDB would be EDB DAC, DBISAM would be DBISAM ODBC driver and OLE DB PowerBI supports directly).

Or if data is simple then just provide an option in your EWB app to export data into one of the data formats PowerBI support natively and you users can just get the data file as load into PowerBI.

Raul

Thanks Raul