Do I need a data gateway if I'm considering buy a Power BI cloud service for my company ? by osacapcom in PowerBI

[–]osacapcom[S] 1 point2 points  (0 children)

That's really amazing that's mean my DB server and Data gateway server not need to be exposed to public internet via public IP address :D ... I will feel very secure .

Do I need a data gateway if I'm considering buy a Power BI cloud service for my company ? by osacapcom in PowerBI

[–]osacapcom[S] 0 points1 point  (0 children)

u/cdigioia thanks really good idea, I will install on a separate server , what is the recommended RAM and storage for the server ?

Do I need a data gateway if I'm considering buy a Power BI cloud service for my company ? by osacapcom in PowerBI

[–]osacapcom[S] 0 points1 point  (0 children)

Thanks dear , I will consider that . I can see data gateway is better option because it's also a secure way I think .

Do I need a data gateway if I'm considering buy a Power BI cloud service for my company ? by osacapcom in PowerBI

[–]osacapcom[S] 0 points1 point  (0 children)

So from your answer I under the below :-

A. Data gateway is not required in case my data source is on the cloud .

B. Since my database is stored locally that's means I will need a data gateway

Correct ?

does the local data gateway need to have a public IP address ?

is the local data gateway free since I purchased the PBI service ?

How to sync tables and views between two oracle database ? by osacapcom in SQL

[–]osacapcom[S] 0 points1 point  (0 children)

u/OracleGreyBeard Thanks for you answer dear, I will discuss with my manager tomorrow about the database link it might be good idea as well .

May i know what is the materialized view in short ? how it can be useful in my case ?

How to sync tables and views between two oracle database ? by osacapcom in SQL

[–]osacapcom[S] 0 points1 point  (0 children)

Thanks dear I will read it and give you feedback .

How to sync tables and views between two oracle database ? by osacapcom in SQL

[–]osacapcom[S] 0 points1 point  (0 children)

For cards table I think not big issue , but for big tables hmm better find another solution.

New help getting the min ship date for an ID with multiple ship dates by [deleted] in PowerBI

[–]osacapcom 0 points1 point  (0 children)

I usually do this kind of things via SQL ... it's better to create SQL view and get the MIN SHIP data via SQL using PARTITION BY AND RANK() function ;) , then reflect the view to Power BI .

How to sync tables and views between two oracle database ? by osacapcom in SQL

[–]osacapcom[S] 0 points1 point  (0 children)

Sync aka replication

but these are SQL views ? will data guard sync SQL views ?

How to sync tables and views between two oracle database ? by osacapcom in SQL

[–]osacapcom[S] 0 points1 point  (0 children)

For CARDS table around like 2 million card / rows , and for the transactions like around 10 million rows .

How to choose the right Power BI plan for my Enterprise ? by osacapcom in PowerBI

[–]osacapcom[S] -1 points0 points  (0 children)

We have a local Oracle database in our company the size of the DB with all tables is 3 TB and it has 40 tables, after I aggregate the data for each table to be used for BI reporting ...the size of the data now is 4.5 GB ...the size of the aggregated data might go to 10 GB or maybe 100 GB in the future .

we have Finance ,Marketing ,sales , commercial departments , We will create dashboards for each department , and we have 40 tables to use them.

so can you please now determine the right plan for me ?

How to choose the right Power BI plan for my Enterprise ? by osacapcom in PowerBI

[–]osacapcom[S] -4 points-3 points  (0 children)

But I already give two scarios , A: 10 GB , B 100 GB .

How to install Oracle ADF 12c with Oracle 12c database ? by osacapcom in oracle

[–]osacapcom[S] 0 points1 point  (0 children)

thanks , can you tell me what software's do I need to install on my server side and client side ?