Configuring the destination as Microsoft SQL Server

If you select Microsoft SQL Server as your target database, configure it from the Administration tab in the Helix Data Connector UI.

To configure the destination as Microsoft SQL Server

1. On the Helix Data Connector UI, navigate to the Administration tab and select Configure destination, as shown in the following image:
   
2. On the Destination UI screen, click Configure destination.
3. Enter the following details for the destination:

   Field	Description
   Destination type	Select Microsoft SQL Server from the list.
   Destination Name	Specify a name for the destination.
   Host	The target database host details, either an IP address or a hostname.
   Port	The port number for database connectivity.
   Database Name	The name of the target database.
   Database Schema	The schema within the target database.
   Username	The administrator user name for Microsoft SQL Server.
   Password	The password for the administrator user.

4. Click Save. 
   Clicking Save first tests the connection. If the connection fails, an error message is displayed. Verify the destination parameters and connection settings, update any incorrect values, and resolve the error. If the connection is successful, the destination is configured as shown in the following image:
   
   
    

Related topics

• Syncing data from BMC Helix SaaS to a destination database
• Configuring advanced settings
• Configuring the dataset and sync interval