Skip to Content
author's profile photo Former Member
Former Member

Loading History data from ORACLE to BW

hi,

i have been very helpful by this forum and have been awarding points when i recieved the help. thanks for the co operation...

we need to extract data from oracle 7.3 to BW 3.5 . the problem is BW3.5 is not compatible with oracle 7.3. To connect with BW using DB connect oracle should atleast be 8.1.

Now we have planned to download data from oracle to flat files and load into bw...but the problem is the records are in millions, so we need to download into many files and load into BW.

The alternatives which are thinking are:

1) creating .csv files (say 10 files which will hold all the data to be loaded) from ORACLE and load it in BW individually

2) If all the files craeated above is kept in one central location, can we use the process chain to load all the files in sequence?

I guess Process chain and Infopackage group can not be used for the files stored on local workstation. Is it possible to put the files on Apllication server...if yes, how?

We are looking for the easy, fast and best way to do the same, so any inputs on this would be appreciated.

Regards

Milind

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2005 at 01:54 PM

    Tpo transfer the file you need an ftp address (ask your basis guys); than you can open that adress with explorer and drag and drop the file.

    Than you can create a process chain with 10 infopackege to load all file automatically.

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Milind,

      you reasoning is right and you ca do it everything you're planning to do...

      Follow Paolo's suggestion to put your files on application server...

      About possible perfromance issues, read this SAP suggestyions too:

      (from OSS Note 130253)

      "(...)

      Tip 5:

      If possible, load the data from a file on the application server and not from the client workstation as this reduces the network load. This also allows you to load in batch.

      Tip 6:

      If possible, use a fixed record length when you load data from a file (ASCII file). For a CSV file, the system only carries out the converison to a fixed record length during the loading process.

      Tip 7:

      When you load large data quantities from a file, we recommend that you split the file into several parts. We recommend using as many files of the same size as there are CPUs. You can then load these files simultaneously to the BW system in several requests. To do this, you require a fast RAID."

      Hope it helps!

      Bye,

      Roberto

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.