Microsoft Azure SQL Data Warehouse Connector > Synchronization Tasks with Microsoft Azure SQL Data Warehouse > Microsoft Azure SQL Data Warehouse Source Properties in Synchronization Tasks
  

Microsoft Azure SQL Data Warehouse Source Properties in Synchronization Tasks

You can use a Microsoft Azure SQL Data Warehouse object as a single source in a synchronization task. You can configure Microsoft Azure SQL Data Warehouse source properties on the Source page of the Synchronization Task wizard.
The following table describes the source properties for Microsoft Azure SQL Data Warehouse:
Source Property
Description
Connection
Name of the source connection.
Source Type
Type of the source object. Select Single.
Source Object
Name of the source object.
Display technical names instead of labels
Displays technical names instead of business names.
Display source fields in alphabetical order
Displays source fields in alphabetical order instead of the order returned by the source system.
Configure the Microsoft Azure SQL Data Warehouse advanced source properties on the Schedule page of the Synchronization Task wizard.
The following table describes the advanced source properties for Microsoft Azure SQL Data Warehouse:
Advanced Source Property
Description
Azure Blob Container Name
Name of the container in Microsoft Azure Storage to use for staging before extracting data from Microsoft Azure SQL Data Warehouse.
Field Delimiter
Character used to separate fields in the file. Default is a comma (,). Default is 0x1e. You can select the following field delimiters from the list:
~ ` | . TAB 0x1e
Number of Concurrent Connections to Blob Store
Number of concurrent connections to extract data to the staging area in Microsoft Azure Blob Storage. Default is 4.
Quote Character
The Secure Agent Skips the specified character when you read data from Microsoft Azure SQL Data Warehouse.