High data volume

[Former Member]

Hi Friends

My client have 4 business units and they want to consolidate the 4 b units data into a single BI system for global reporting.

One B unit's database is around 250gb and my bais team says it's a problem to transfer high data volumes using LAN network from R/3 to BI system.

How could we transfer high volume data from R/3 into BI system?

Regards,

Chama.

[markus_doehr2]

> One B unit's database is around 250gb and my bais team says it's a problem to transfer high data volumes using LAN network from R/3 to BI system.

It's very unlikely that you will transfer those 250 GB data to the BI system.

> How could we transfer high volume data from R/3 into BI system?

Create a high speed interconnect (GBit LAN or higher).

Markus

[Former Member]

Hello,

Did you think also about export/import of data from one database to other?

From oracle 10g you may also use data pump. (It is faster than clasical exp/imp!)

Export is stored to dump file, which is easier manipulate.

Best regards,

Peter