Setup Guide - Microsoft SQL Server

Follow this setup guide to connect Microsoft SQL Server Data Warehouse to DataChannel.

Prerequisites

  • Have a Microsoft SQL Server database configured and reachable from the DataChannel IPs. Contact support for the list of IP addresses to whitelist incase required.

  • Create a user for DataChannel with SELECT rights on the tables / views you want to pull data from.

  • In case of a heavily utilized production database, it is advisable to connect the read-only replica to pull data from an active Microsoft SQL Server account with permissions to access data from accounts you’d like to sync. This account needs to be a admin account with delete privileges.

Setup instructions

  1. Select a data destination for your Microsoft SQL Server Data. If you have not yet added a data warehouse, go to data warehouse tab and add a warehouse.

    Data Warehouse once selected cannot be changed.

  2. Authorise DataChannel to connect to your Microsoft SQL account using the + icon with your Name, DB Host, Username, Password, DB Port and DB Name.

    mssql new creds

  3. Click on + Data Pipeline to start adding data pipelines to your account.

    mssql data source detail

  4. Details of individual objects and reports are available here. .

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.