SQL Azure Destination Connector

The SQL Azure destination connector writes extracted and transformed data from DataSync into a Microsoft Azure SQL Database. It serves as the storage destination for your reporting and analytics. Once your destination connection is ready, create your extraction to define what data gets loaded and how.

Create the destination connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Destination Connections, click New.
4. Select SQL Azure.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any advanced parameters.
7. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: SQL Azure.
Server	Server name where the Azure SQL Database is hosted. Example: salesdb.database.windows.net.
Database	Name of the Azure SQL Database to connect to. Example: SalesData.
Username	Login account for accessing the database. Example: dbadmin@salesdb.
Password	Password for this account.
Timeout	Time in seconds to wait before a connection attempt or query execution times out.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
Property	Connection string property that defines the action or behavior. Example: ReadOnly.
Value	Value for the property. Example: True.
Type	Visibility settings: Visible or Encrypted.