How to Configure a Microsoft SQL Server Data Source

The steps for configuring a data source for connecting to a Microsoft SQL server are the following:
  1. Go to menu Preferences > Data Sources .
  2. Click the New button in the Data Sources panel.

    The dialog for configuring a data source will be opened.

    Data Source Drivers Configuration Dialog
  3. Enter a unique name for the data source.
  4. Select SQLServer in the driver type combo box.
  5. Add the Microsoft SQL Server driver file using the Add button. The SQL Server driver file is called sqljdbc.jar. In the Download links for database drivers section there are listed the URLs from where to download the drivers necessary for accessing Microsoft SQL Server databases in Oxygen.
  6. Select the most suited Driver class.
  7. Click the OK button to finish the data source configuration.