Skip to Content
0
Former Member
May 29, 2008 at 05:35 AM

DB Connect-data Featching problem

37 Views

Hi all,

I make the connection between SQL2000 server and R3 server data coming from SQL to r3 and its visible in T-code -RSDBC .

But i am facing 2 problems

1. In SQL server if table name is in small latter or table fields in small latter it give error i mean to say if i run t-code RSDBC and take table name which saved in sql in small latter it show error.

2. If table name is in capital letter then every thing OK .After replication , that data source shown in BW

i follow these things for making query at Bex

1 create InfoObject ,application component ,infosource , transfer rule and assign sql data source to infosource , make basic cube and then update rule and infopkg.

when i schedule the data ,data from sql server not come in to BW server every thing is fine connection from sql server is ok, transfer rule is ok but i am unable to get data in info pkg or psa .

So can anybody tell me what the reason behind this and how can i featch the data from sql to BW ???

Thanks and regards

Ankit Modi