Skip to content
  • There are no suggestions because the search field is empty.

Microsoft SQL Server Data Connection Setup

Setting up a Microsoft SQL Server connection should only take 5-10 minutes.

There may be fees associated with setting up a new data connection. Please contact your account team to confirm pricing.

Pre-Implementation

To connect you will need the BUCS Remote Agent installed on the machine where your Microsoft SQL Server data is located. Remote Agent installation instructions can be accessed here.

Implementation

1. Connect to MSSQL Server

Go to BUCS Customer Portal > Connection Management > Connection Hub. Locate or search for the Microsoft SQL Server connector and click Connect.

 

 2. Name Connection

Enter a Name for your connection on the first page of the connection wizard and then click Next. The connection name should be descriptive and specific to the connection you want to establish. 

 

3. Provide Connection Details

Provide your Microsoft SQL Server Username and Password and the Server Name and Database where your Microsoft SQL Server data is located. Enter the Application Name of the data source you are connecting. Click Save. 

The Username and Password can be associated to an existing user or you can setup a new dedicated BUCS user in your Microsoft SQL Server account.

4. Connection Established

If the connection was established successfully you will see a Connection Established message and data from Microsoft SQL Server will continuously sync to BUCS.  If the connection was not successful, you will be asked to try again.

NOTE: If you don't see your data appear in the BUCS platform in 24 hours, please contact your account team.