Home » Developer & Programmer » Reports & Discoverer » migrate discoverer reports to powerbi
migrate discoverer reports to powerbi [message #672328] Thu, 11 October 2018 08:31 Go to next message
desmond30
Messages: 32
Registered: November 2009
Member
I am being assigned the task of migrating set of existing discoverer reports to micrsoft powerbi

My question is this:
1. Is it as simple of extracting the sql from the discoverer files and using those sql in the powerbi (or whichever tool I am migrating the reporting to ?)
2. During this migration, does the "EUL Layer" play any role at all, or can I totally ignore that layer and just use the extracted sql from existing discoverer ?

Re: migrate discoverer reports to powerbi [message #672329 is a reply to message #672328] Thu, 11 October 2018 08:39 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
desmond30 wrote on Thu, 11 October 2018 06:31
I am being assigned the task of migrating set of existing discoverer reports to micrsoft powerbi

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

What proof of concept testing was done prior to making the decision to migrate to POWERBI?
Re: migrate discoverer reports to powerbi [message #672330 is a reply to message #672329] Thu, 11 October 2018 08:55 Go to previous messageGo to next message
desmond30
Messages: 32
Registered: November 2009
Member
I have 64 bit powerbi desktop, and a 64 bit oracle 12c client, I am able to login to oracle from powerbi desktop and connect, and work.
Re: migrate discoverer reports to powerbi [message #672331 is a reply to message #672330] Thu, 11 October 2018 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
desmond30 wrote on Thu, 11 October 2018 06:55
I have 64 bit powerbi desktop, and a 64 bit oracle 12c client, I am able to login to oracle from powerbi desktop and connect, and work.
what is the result when you COPY a SELECT statement from Discoverer & PASTE into POWERBI?
Re: migrate discoverer reports to powerbi [message #672332 is a reply to message #672331] Thu, 11 October 2018 09:12 Go to previous messageGo to next message
desmond30
Messages: 32
Registered: November 2009
Member
I know the copy and paste works, my question is about EUL layer ...does something extra needs to be done apart from copy paste
Re: migrate discoverer reports to powerbi [message #672342 is a reply to message #672328] Fri, 12 October 2018 01:22 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Are you familiar with Discoverer? What the End User Layer is, and how it is generated? You can be reasonably certain that Power BI will not have any facilities for maintaining it. I would suspect (knowing nothing about the product) that Power BI has its own similar function: a means of generating a set of views that will present data to users in a meaningful fashion.
I would guess (and it is only a guess) that you will need to design your Power BI environment from the the beginning, discarding the Discoverer configuration.
Re: migrate discoverer reports to powerbi [message #672346 is a reply to message #672342] Fri, 12 October 2018 03:18 Go to previous messageGo to next message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
The EUL is real views in an actual schema isn't it?
So you could point Power BI at that schema. It probably won't let you modify the views, but you can always do that manually.
Re: migrate discoverer reports to powerbi [message #672349 is a reply to message #672346] Fri, 12 October 2018 03:33 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Yes, that is all it is: views in a schema that anything can query. But Uncle Oracle has (of course!) wrapped it up in massive administration structure, and I really wouldn't want to query the views directly. There is too much chance of mis-interpreting data. For example, if rows are never deleted but rather flagged as "inactive", will the views include or exclude them? Power BI will not know, Discoverer would. That sort of thing would make me inclined to start again with a new tool.
Re: migrate discoverer reports to powerbi [message #672350 is a reply to message #672349] Fri, 12 October 2018 03:35 Go to previous message
cookiemonster
Messages: 13291
Registered: September 2008
Location: Rainy Manchester
Senior Member
Fair enough. I've never actually used discoverer so am not in a position to comment on the intricacies of it's schema.
Previous Topic: password protected report
Next Topic: Reports not running
Goto Forum:
  


Current Time: Fri Oct 19 22:59:42 CDT 2018