Transfer source - Microsoft SQL Server

Article summary

Did you find this summary helpful?

Thank you for your feedback

summary

Help page for setting up data transfer from Microsoft SQL Server.

The SELECT privilege for the object to be transferred must be granted to the user whose connection information will be used to set up the transfer. (e.g., db_datareader authority)
For more information, please refer to the official documentation.
In order to use the Table List and Schema List Suggest function, the following permissions must be granted to the Microsoft SQL Server connection information used in the transfer settings.
- The table list is obtained from sys.databases. Authorization as described in the manual below is required.
  https://docs.microsoft.com/ja-jp/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-ver16# permissions
- The list of schemas is obtained from the information schema view. Authorization as described in the manual below is required.
  https://docs.microsoft.com/ja-jp/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact -sql?view=sql-server-ver16#permissions
If the above permissions are not granted, the Suggest function will result in an error, but if access to the data is granted, data preview and transfer jobs can be executed.

item name	indispensable	default value	Contents
Microsoft SQL Server Connection Information	Yes	-	From the previously registered connection information, select the one that has the necessary authority for this transfer setting.
database	Yes	-	Specify the name of the database in which the data you wish to retrieve is stored.
schema	Yes	-	Specify the name of the schema in which the data you wish to retrieve is stored.
Transfer Method	Yes	Transfer using query	Select either transfer or differential transferusing the query. For more information on differential transfer, see Differential Transfer Function.
query	Yes	-	Enter if you selected transfer using query as the transfer method. Enter SQL to retrieve transfer data.
table	Yes	-	Enter this field if you selected differential transfer as the transfer method. Enter the name of the table containing the data you wish to transfer.
Default time zone	Yes	UTC	If the column was of type date/time/datetime, specify which time zone the time should be in.

item name	default value	Contents
Number of records processed by the cursor at one time	10000	You can specify the number of rows to retrieve at a time.
Connection timeout (seconds)	300	You can specify a timeout in seconds before the driver connects. When set to 0, the default for Microsoft SQL Server is 15 seconds.
Socket timeout (seconds)	1800	You can specify a timeout in seconds before the query is executed. When set to 0, there is no timeout.

Was this article helpful?

Table of contents