Question:
Hi
I need to load the data from SQL server to BW via DB connect.
Analysis:
step 1. in BW Source system, tried to create the New Source system (DataBase system - Data and MetaData using Db connect)
Step2: CON_NAME: <my_conn_name>
DBMS: MSS
USER_NAME: <db_user>
PASSWORD: <password>
CON_ENV: MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name>
But I am not able to connect to the server. Can any one through the light? how to load the data from SQL server to BW.
Thanks in advance.
Answer:
Hi MK,
What is your current DB? If you're not using MS-SQL on your BW system you'll need to install a suitable DB driver.
Your current config and any error logs would be helpful.
Thule
Answer:
HI Thule,
Thank you so much for your information. We are not using MS Sql as a database. First I will intall the db driver, then I will try.
Thanks for your time
Answer:
You're welcome.
I very recently did the same thing and found this thread very useful :
/forums/viewtopic.php?t=28245&highlight=sql+source+system
You should also take a look at note 512739
Thule
Answer:
Hi Thule
Sorry for my late response. Thank you so much for your information.