History | Edit

Available in the Enterprise edition only.

To configure a data source for connecting to a Microsoft SQL server, follow these steps:

  1. Download the appropriate MS SQL JDBC driver from the Microsoft website. For SQL Server 2008 R2 and older, go to http://www.microsoft.com/en-us/download/details.aspx?id=21599. For SQL Server 2012 and 2014, go to http://www.microsoft.com/en-us/download/details.aspx?id=11774.
  2. Open the Preferences dialog box (Options > Preferences) and go to Data Sources.
  3. Click the New button in the Data Sources panel.

    The dialog box for configuring a data source is opened.

    Figure: Data Source Drivers Configuration Dialog Box

  4. Enter a unique name for the data source.
  5. Select SQLServer in the driver Type drop-down menu.
  6. Click the Add Files button and select the Microsoft SQL Server driver file that you downloaded.
    The SQL Server driver file is called sqljdbc.jar.
  7. Select the most appropriate Driver class.
  8. Click the OK button to finish the data source configuration.
  9. Continue on to configure your Microsoft SQL Server connection.