How to Connect SQL Server
  • 1 Minute to read
  • Dark
    Light

How to Connect SQL Server

  • Dark
    Light

NOTE:

Network setup required. Make sure to white list the following IP address to allow incoming connections from the Dataddo application to your server.

  • 52.17.68.150
  • 52.30.37.137
  • 52.214.115.147
  • 54.77.45.35
  • 52.210.57.95
  • 18.200.46.19

Create a new Data Destination

  1. Sign in to your Dataddo account and click on Destinations at the top of the page.

  2. Click on Create Destination in the top right corner.

  3. From the list of destinations, choose Universal SQL server. You can type the name of the connector into the search bar to find it faster.
    Data destinations - selection

  4. Fill out all the files on the sign-in page to give DAtaddo all the necessary information to connect your data, and click on Save
    Universal SQL - add new destination

How to Create a New Data Flow

  1. Click on Flows at the top of the page.

  2. Click on Create Flow in the top right corner.

  3. Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.

  4. Once you select your data source, click on Add Destination.

  5. From the list of destinations, select the new destination. You can also type the name into the search bar.

  6. Configure the destination by filling out necessary fields.
    Universal SQL - new flow
    NOTE: Remember to set the synchronization time for the flow with a little delay after the synchronization of your source to let the data load.

  7. You can Name your flow by typing the name into the top.

  8. You can see a Data Preview to make sure of your configuration.
    Flow - preview

  9. Click on Save flow.

How to Configure the Data Flow

  1. Click on the three dots next to the flow and choose Config.

  2. The window pops up with the configuration details. Follow the instructions to finish the configuration.
    Universal SQL - flow config

Congratulations, your new Data Destination & Flow are ready!


Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.


Was this article helpful?