Data Source - Microsoft SQL Server

Article summary

Did you find this summary helpful?

Thank you for your feedback

summary

Help Page for ETL Configuration of Data Setting from Microsoft SQL Server.

The SELECT privilege for the object to be transferred must be granted to the Connection Configuration user used for ETL Configuration. (e.g., db_datareader authority)
For more information, please refer to the official documentation.
In order to use the Table List and Schema List Suggestions feature, the following permissions must be granted to the Microsoft SQL Server Connection Configuration used in ETL Configuration.
- 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 fail, but if access to the data is granted, data preview and ETL Job can be executed.

item name	indispensable	default value	Contents
Microsoft SQL Server Connection Configuration	Yes	-	Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
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 Incremental Data Transferusing the query. For more information on Incremental Data Transfer, see Incremental Data Transfer Function.
query	Yes	-	Enter if you selected transfer using query as the transfer method. Enter SQL to retrieve transfer data.
table	Yes	-	Enter if Incremental Data Transfer is selected 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