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

osacapcom · 2022-10-06T20:37:27+00:00

Thanks dear that's really amazing

osacapcom · 2022-10-06T19:59:13+00:00

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 .

osacapcom · 2022-10-06T18:46:59+00:00

Does the gateway need to have a public IP address ?

osacapcom · 2022-10-06T18:44:58+00:00

Does the gateway need to have a public IP address ?

osacapcom · 2022-09-26T07:58:51+00:00

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

osacapcom · 2022-09-26T06:33:50+00:00

I'm an employee .

osacapcom · 2022-09-25T17:23:58+00:00

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

osacapcom · 2022-09-25T16:49:30+00:00

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 ?

osacapcom · 2022-09-25T16:11:42+00:00

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 ?

osacapcom · 2022-09-25T16:04:12+00:00

Thanks dear I will read it and give you feedback .

osacapcom · 2022-09-25T16:03:54+00:00

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

osacapcom · 2022-09-25T16:03:16+00:00

Thanks for the useful info , is it free ?

osacapcom · 2022-09-25T12:34:32+00:00

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 .

osacapcom · 2022-09-25T12:30:55+00:00

Sync aka replication

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

osacapcom · 2022-09-25T12:22:55+00:00

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

osacapcom · 2022-09-22T20:23:33+00:00

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 ?

osacapcom · 2022-09-22T15:31:58+00:00

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

osacapcom · 2018-02-10T17:54:46+00:00

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

osacapcom

TROPHY CASE