Skip to Content

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

/wp-content/uploads/2014/11/1_0_589408.png

Select the options and provide the necessary login credentials of SQL Server Database.

/wp-content/uploads/2014/11/1_589459.png

Click On Apply and OK to create the connection.

2. ODBC Connection:


Select the Administrative Tools from Control Panel\All Control Panel Items


/wp-content/uploads/2014/11/2_589469.png

Click on Add to create new ODBC Connection.

We can use User DSN and System DSN. But System DSN is recommended.

Select SQL Server

/wp-content/uploads/2014/11/odbc1_589471.png

/wp-content/uploads/2014/11/odbc2_589484.png

/wp-content/uploads/2014/11/odbc3_589485.png

/wp-content/uploads/2014/11/odbc4_589486.png

/wp-content/uploads/2014/11/odbc5_589493.png

Click on OK.

ODBC Connection

/wp-content/uploads/2014/11/odbc6_589495.png

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

/wp-content/uploads/2014/11/odbc7_589499.png

Thank You.

Best Regards,

Arjun

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Doros Georgiou

    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?

    (0) 

Leave a Reply