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:

  1. 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.

  2. Specify the information on this page as explained in the table below.

  3. 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.