topic High data volume in Application Development and Automation Discussions

High data volume

Former Member — Mon, 09 Jun 2008 10:52:15 GMT

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 — Mon, 09 Jun 2008 12:39:27 GMT

> 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 — Mon, 30 Jun 2008 09:51:53 GMT

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