Paginated Report Builder

[kpavang]

Hi,

I'm trying to create a new report with the new Power B report builder tool with Oracle as a datsource. When creating a new dataset the option to choose the "tables" is grayed out? I can just write/import  a sql query or a stored procedure.

Is it the limitation when using Oracle as suupose to other data sources?

Thanks!

PG.

[chrisfin]

Yes, this is related to the specific driver used for the Oracle provider.  There has always been limitations like this for non-Microsoft SQL datasources in RB.

[kpavang]

Thanks for the reply @chrisfin . Do you know if there anything in the roadmap to update the oracle driver used to be able to select tables. TIA. - PG.

[luisrh]

This is probably a limitation of the driver that you are using.    Some other DBs drivers also don't have that capability.

The best thing is to use a view or define the SQL directly - even for SQL Server which is a first class citizen when it comes to supporting table views and SQL generation from that view.

good luck!

Luis

[kpavang]

Thankyou @luisrh 

[luisrh]

You are welcome.   I doubt that there will be support for Oracle downstream the way you expect on the report builder side.   There are enough differences between the SQL syntax and if the Oracle native drivers don't support some of the features that the builder requires,  then it will also be a problem.   My suggestion is you use a tool outside that may generate the SQL for you, then you can paste into ReportBuilder query.   Query Builder is such a tool -

https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_Querybuilder/sqld...

Good luck!

Luis