cancel
Showing results for 
Search instead for 
Did you mean: 

Dump Load Task - Important

Former Member
0 Kudos

Hi,

I need help ASAP.

Can anyone please provide information of how to use the DUMP LOAD TASK.

In my case, data exists in a SAP ERP and I'd like to export this to BPC, the suggestion for making this, is using this task because it will retrieve data from a SQL Table and move it to a SQL proper table in BPC.

The page HELP.SAP.COM provides information but its not clear for me, since it mentions a task called Import SQL, etc... please help !!! I have no idea how to make it work.

Velázquez

Accepted Solutions (0)

Answers (2)

Answers (2)

sorin_radulescu
Employee
Employee
0 Kudos

Dump and Load task has like input always a file which is coming from conversion task.

So I will use always the dump and load task with conversion task because in this way you can change mapping using transformation and conversion file.

First you have to export that data from R3 into a flat file and using conversion and dump and load task you can import data into BPC.

To take data from R3 normally you have two choic.

To export data from R3 into a flat file using standard functionality of R3 (schedule process chain). after that knowing the location of the file you can use that file for import into BPC or you can use SAP connector from BizTalk Server of Microsoft to automate export of data from R3 into BPC.

I hope this will help you.

Regards

Sorin Radulescu

Former Member
0 Kudos

Hi Sorin,

Thanks for the response, it is very helpful !!

One more thing, in the beggining I thought this task retrieved data directy from a table and imported it directly in a BPC table (wb, fac2, fact), this without using a flat file... I came up this concept also because the "Import into SQL Server" task was mentioned to work with Dump & Load.

However, you say that I need a flat file (which has the data), a conversion file (to match data between BPC-R3) and the D&L task. This sounds a lot like using normal import packages... so, what is the difference?

At this moment, im thinking of getting the info from R3 in a flat file and use a "normal" import package for BPC.

If I'd like to directly work with data in SQL tables as mentioned before... which task/package is the best for me ? (not using flat files) Or is it always neccesary to use a flat file?

Thanx in advance, really appreciate your help.

Velázquez

Former Member
0 Kudos

Hi Velázquez,

The Dump load task which is in SSIS as BPC customized task is for the data in BPC tables(WB,FAC2,FACT), it reads trasformation and conversion file that define how you treat data in BPC.

Since you are going to extract data from R3, you need to have RFC, and you can create script(pure SSIS package) to fit to the format of BPC fact table(if the destination table is not a fact table, anyhow you need to change the source data layout to fit to the destination table layout).

Hope this could help.

Regards,

YH Seo

Former Member
0 Kudos

Hi YH Seo,

Thank you so much for the response.

At this point im a little confused about the functionality of packages and tasks, because in this case for importing data into BPC, I think I can use also the normal import data package...

What is the advantage of using this "task" or in which cases would you use it ? Its just that I originally wanted to work with SQL tables, not using flat files... I thought this package retrieved data from the SQL tables that I use with R3, and simply imported it into the proper (WB, FAC2, FACT) BPC table...

It is also important to know that SSIS is brand new for me, therefore creating packages and everything related to the "process" of how this particular task works is difficult to understand.

Regards

Velázquez