Skip to Content
Author's profile photo Arjun Rao

Creating a Data Store by using SQL Server Database

Creating a Data Store by using SQL Server Database

Hi All,

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.

ODBC Connection


We can use this ODBC connection in BODS Data Store SQL Server connection as shown below:


Thank You.

Best Regards,


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      For option 1. How can I change the version of the server on an existing data source. So what I am saying in more detail is,let 's suppose, I have a data source setup for Microsoft SQL Server 2008 but the  datasource was upgraded to Microsoft SQL Server 2014. How can I alter the version of the DS datasource without affecting the already implemented functionality?