Data Source - SQL Server
  • 07 Dec 2022
  • PDF

Data Source - SQL Server

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This is a help page for setting up data transfer from SQLServer.

Supported Protocols

constraint

Setting items

STEP1 Basic settings

Itemnamerequireddefault
valuecontent
SQL Server connection informationYes-From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
Database nameYes-Specify the name of the database where the data you want to retrieve is stored.
schemaYes-Specify the schema name where the data you want to retrieve is stored.
Transfer MethodYes-Specify the transfer method using query or differential transfer (transfer only incremental data from the previous transfer).
queryNo-Input is required when specifying a transfer using Query as the transfer method.
Describe the query you want to run.
Custom variables can also be used to dynamically determine the setting value during trocco data transfer.
tableNo-This input is required when you specify differential transfer (transfer only incremental data from the previous transfer) as the transfer method.  
Specify the table from which you want to retrieve data.
Columns that determine incremental dataNo-You can enter this if the transfer method is set to Delta Transfer.
The values of the columns specified here are stored in the last transferred record each time they are transferred.
During the second and subsequent transfers, only records whose target column of incremental data is greater than or equal to the value at the time of the previous transfer are transferred.
Specify the name of the unique Auto Incremnt ID column, for example.
If you want to specify multiple columns, separate them with commas.
If not specified, the primary key is used.
Last Transferred RecordNo-You can enter this if the transfer method is set to Delta Transfer.
During differential transfers, data newer than the value specified here is transferred.
If not specified, transfer from the beginning.
Unless you have a specific reason to do so, do not change this value.
Data duplication may occur.
Default time zoneYesUTCIf the column is of type date/time/datetime, specify the time zone in which the time should be.

STEP2 Advanced settings

Item namedefaultvalue content
The number of records that the cursor processes at one time10000You can specify the number of rows to retrieve at one time.
Connection Timeout (seconds)300You can specify the timeout in seconds before the driver connects.
If it is set to 0, it will be 15 seconds, which is the default for SQL Server.
Socket Timeout (seconds)1800You can specify the timeout in seconds before the query runs.
If it is set to 0, there is no timeout.

Was this article helpful?