How to Configure a Microsoft SQL Server Data Source

Available in the Enterprise edition only.
The steps for configuring a data source for connecting to a Microsoft SQL server are as follows:
  1. Open the Preferences dialog box and go to Data Sources.
  2. 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

  3. Enter a unique name for the data source.
  4. Select SQLServer in the driver Type drop-down menu.
  5. Add the Microsoft SQL Server driver file using the Add Files button.
    The SQL Server driver file is called sqljdbc.jar. In the The Driver files section lists download links for database drivers that are necessary for accessing Microsoft SQL Server databases in Oxygen XML Editor.
  6. Select the most appropriate Driver class.
  7. Click the OK button to finish the data source configuration.
Parent topic: How to Configure Microsoft SQL Server Support