Loading to SAP BW Tables Directly

system · February 8, 2012, 7:50pm

I have been requested to find out if non-SAP flat file data can be loaded directly into SAP BW tables using data services and avoiding use of process chain on BW side ?

DS 4.0
BW 7.0

Thank you

softsys (BOB member since 2005-05-13)

system · February 10, 2012, 1:40pm

Yes and No. Yes we can load all data into an InfoSource or a DataSource (BW 7.3 required for the latter). And as these are nothing else than tables, the answer is yes.
But your question sounds more like “Can I load the data directly into a cube model?” No, BW does not allow that. Would love to but I am forbidden.

Werner Daehn (BOB member since 2004-12-17)

system · February 13, 2012, 12:01am

Ok, here is my scenario. I am trying to load some data from SQL Server 2008 database through a source in BW that is Data Services source.

I have the RFC configuration working between Data Services 4.0 and BW 7.3.

In RSA1, under Modelling, I have created a Data Source to load Customer data. The source system is Data Services. In the Extraction tab the Adapter is set automatically to Load using RFC from Data Services and I have selected the source object of DBO.ODS_CUSTOMER.

In the Proposal tab, I have only selected 3 columns. In the Fields tab those same 3 columns are selected and they are:
CUST_ID, CUST_CLASSF and NAME1.

I have mapped these 3 columns to 3 infoobjects that I defined previously.

Data Type and Length all match.

What do I do next to load the SQL Server customer data into BW from this data source?

When right-clicking on the data source I can ‘Create Transformation’, ‘Create Data Transfer Package’ or ‘Create InfoPackage’.

If I select Create InfoPackage, I give it a name and then it automatically fills in all the required tabs for me. I can then execute a Data Services job from this InfoPackage. In Data Services Management Console, I can see that the InfoPackage has been executed, but it doesn’t finish successfully and fails with the following error message, which I do not understand:

(14.0) 02-13-12 10:42:20 (E) (8740:3504) RES-020104: |SESSION ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|DATAFLOW ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|STATEMENT <GUID::‘dae4a319-f7ec-47b4-9b93-e8f841c346ab’ LOAD TABLE “DS_SOURCE@NBICLNT200”.“”.“ZDSCUSTOMER_TRAN@DS_SOURCE” INPUT(“ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200”)>
Cannot read from a file. Specify columns for file format DS_SOURCE@NBICLNT200. Notify Customer Support.

All i want to do is load some data into BW, using Data Services 4.0 and where the source is a sql server database table. I am not sure what I am missing. I cannot find any straight forward documentation on how you load data from Data Services into BW.

Many thanks to anyone who can put me onto the right steps of setting this up.

aposullivan (BOB member since 2004-07-23)

system · February 14, 2012, 1:37am

Thanks Werner.
My next question is load to BW 7.0 using DS 4.0 can be done only thru either master or transaction structures ? There is no other way to load like flat file target ?

Thanks

softsys (BOB member since 2005-05-13)

system · June 4, 2012, 7:30pm

Hi, just for future queries, I faced the same issue here and solved, in my case, the Data Services job that BW create automatically is missing the target object, I create then a new BW target Data Store and import this target object manually, after that works running the job directly from BW

Best Regards,

Rodrigo.

rodrigocpz (BOB member since 2008-03-26)

system · June 11, 2012, 11:10pm

I have a custom DSO in SAP BW. I have data in an external sql server which needs to be loaded into this DSO. I created a SAP BW as Target Data source in data services and imported this DSO as a transaction source.

I created a data flow which reads data from the sql server and loads into this target table. The job fails giving error message

Can I load directly to the DSO table ? If so, why the error.
If not , does it always have to be a data source ?

SAP BW : 7.3
SAP DS: 4.0 (14.0.2)

Anup

anup_kumar_n (BOB member since 2008-04-29)

system · June 11, 2012, 11:19pm

Anup, based on my experience, you can load just a PSA as it’s considered a Data Source on BW

rodrigocpz (BOB member since 2008-03-26)

system · June 12, 2012, 12:38am

rodrigo, figured that out now. But for some reason, data services job is giving error as mentioned earlier. Anybody get that ? I am not able to get a single record inserted into the PSA.

anup_kumar_n (BOB member since 2008-04-29)

system · April 30, 2013, 9:34am

Dear aposullivan,

Have you got any solution for your scenario, because i got same issue .

Could you please provide steps to resolve the issue.

Issue #
|SESSION ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|DATAFLOW ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|STATEMENT <GUID::‘acca2fd9-443f-4617-b92d-8c4db33f1b28’ LOAD TABLE “REPO@BPDCLNT200”."".“DS_TRAN@REPO” INPUT(“ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200”)>
Cannot read from a file. Specify columns for file format REPO@BPDCLNT200. Notify Customer Support.

Thanks,

Siva.dwh (BOB member since 2008-11-13)

system · May 2, 2013, 11:05am

Hi aposullivan,

In your scenraio

Data types are not mismatch - BODS & BW
Quality of data is not loading
File format is not specified properly
Ex BODS - 2012.MON
But BW will not support above format.
It will support 2012.MM only.

like that same columns from both sides and relavant data type is required.

Thanks,

Siva.dwh (BOB member since 2008-11-13)

system · June 9, 2013, 10:47am

DS - Ability to direct write to ABAP tables.

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=34503CB9-F213-4EF9-8603-E500CB16D712&idea_id=2F931BA4-3B5D-472E-BDDF-7689E33B47C8

bmvrus (BOB member since 2011-05-08)