Creating a Data Store by using SQL Server Database
This is a very simple document to create SQL Server Connection in SAP BODS.
Please go through it and provide your comments.
We can create a SQL Server Connection in two ways:
1. Microsoft SQL Server :
Right Click on Data Services as shown below:
Click on New
Select the options and provide the necessary login credentials of SQL Server Database.
Click On Apply and OK to create the connection.
2. ODBC Connection:
Select the Administrative Tools from Control Panel\All Control Panel Items
Click on Add to create new ODBC Connection.
We can use User DSN and System DSN. But System DSN is recommended.
Select SQL Server
Click on OK.
We can use this ODBC connection in BODS Data Store SQL Server connection as shown below: