![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Wed, Jan 25 2023 12:18 PM | Permanent Link |
George | Has anybody tried to access EWB database with Microsoft PowerBI? How do you handle credentials?
|
Wed, Jan 25 2023 3:45 PM | Permanent Link |
erickengelke | 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 |
Wed, Jan 25 2023 3:49 PM | Permanent Link |
erickengelke | 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 |
Thu, Jan 26 2023 5:37 PM | Permanent Link |
Raul ![]() | <<
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 |
Mon, Jan 30 2023 11:57 AM | Permanent Link |
George | 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. |
Mon, Jan 30 2023 8:35 PM | Permanent Link |
Raul ![]() | << 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 |
Wed, Feb 1 2023 9:58 AM | Permanent Link |
George | Thanks Raul
|
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |