Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Participant

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,


1 Comment
Labels in this area