How to connect Universal SQL Server

Dataddo supports streaming data to SQL data storage.

Getting your data to SQL servers is an easy task to do with Dataddo.

NOTE:

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

34.248.161.212 

52.17.0.197

52.49.81.223

First, you need to create a Data Flow. You can do this either by navigating to Sources, picking the Source that you want to use and clicking on Add to flow

flow_source

OR by navigating to Data Flows.

1. Data flow buttonAnd clicking on New flow.

New Data Flows-pngAdd the required source by clicking on Add Source.

New Source Flow-png

Select the source that you want to connect to your destination. 

5. Choosing Source for flow

Now click on Add Destination, to select a destination from below.6. Selecting Destination

Click on create a new destination to create a new Universal SQL destination.

7. Creating New DestinationNow select Universal SQL Server

1. Selecting Universal SQL

Fill the configuration boxes based on your SQL server database, host and credentials, then click on Connection Check.

2. Filling MySQL InfoFinally, once all the information is correct, you can click on Create Flow. 

Free consultation available!
Feel free to contact us if you encounter a problem during configuration. We're happy to help you configure your integrations with your database app of choice!