Extraction for SQL server

[Former Member]

Hi all,

I have one requirement that Extract data from SQL to BW side.

i know how to extract the dat from r/3 to BW side like creation of data source etc. But i want to how we can do this in SQL side.

can Any one please give step by step solution...

regards

anil

[former_member205352]

Check the below blog

One caution have only 16 characters for your datasource fields from SQL server,its one painstaking stuffs.Create views to avoide this limitation.

Hope this helps.

[former_member619464]

HI Anil,

Look at DB connect functionality!

http://help.sap.com/saphelp_erp2004/helpdata/en/a1/89786c3df35c4ea930a994e884bb4c/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/s-u/transferri...

For more info go through these links

http://help.sap.com/saphelp_nw70/helpdata/EN/42/fdccb72aa95277e10000000a1553f7/frameset.htm

DB Connect Step By Step:

Hope it helps!

Bye,

Ravi