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