How to configure SQL Server for Data Source

How to configure SQL Server for Data Source

Once the file is created, select the Data Source shortcut from shortcut toolbar as shown below.

 

datasrc-2

 

On Manage Data Source window, Select SQL Server from Connections pane and enter the connection details

 

Click on Test Button to verify the the connection

 

Once Successful, Click on OK.

 

datasrc-3

 

Note: No need to enter user name or password if 'Authentication Mode' is selected as "Windows Authentication".

 

The Connection Name will be displayed in the home tab of a process file as shown in the image below:

 

datasrc-5

 

 

Next:

How to configure connection with Oracle Database