Live Data from Oracle DB

[joshua1990]

Hi experts!

I just have a quick question regarding direct query.

I have access to an oracle database via Oracle Connection or ODBC.

In the past I always used a Dataflow to get the data or - if needed - directly in the dataset from oracle using import.

Now we have a use case where I would like to make live data available for 50 user. 

It is a simple report that would need 1 transactional table from the oracle DB and 2 dimensional table via dataflow.

Is it really as simple as that to just use direct query? Is this everything I should care about?

We have an enterprise gateway and a personal gateway - whatever is needed.

And we work in a PRO workspace - not premium.

[TomMartens]

Hey @joshua1990 ,

it's (almost) as simple as you mentioned.

Because you have two dimensional tables (with data source dataflows) I recommend this architecture:

Create a pbix that contains a dq connection to the Oracle database. Import the two tables from the dataflows.

Instead of ODBC we are using ODAC to connect to Oracle data sources.

Hopefully, this provides an idea of how to tackle your challenge.

Regards,

Tom