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,

Arjun