Adding a SQL data source
Open DataBase Connectivity (ODBC) is a standard database access method that allows you to access and modify data from any application, regardless of which database management system is handling the data.
To add a Microsoft SQL Server Data Source:
On the left navigation panel, go to the section Services > ODBC Data Source, then click Add SQL Data Source. The ODBC Data Source Add page is displayed.
Specify the information on this page as explained in the table below.
Click Add. The SQL Server data source is added and is displayed on the List OBDC Data Source page.
SQL data source options
Option
Description
Data Source Name (DSN)
The name used by your script to connect to the source database.
ODBC Driver Name
Microsoft SQL Server is the default driver.
DSN Description
The description of the data source.
Associated SQL Server
The host name of the remote/local SQL Server.
Default Database Name
The name of the default database to be used, if database name was not provided in the ODBC connection.