--- title: "Data Source - Microsoft SQL Server" slug: "data-source-sql-server" updated: 2024-09-19T08:14:37Z published: 2024-09-19T08:14:37Z canonical: "documents.trocco.io/data-source-sql-server" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - Microsoft SQL Server ## summary Help Page for ETL Configuration of Data Setting from Microsoft SQL Server. ## constraints - 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](https://docs.microsoft.com/ja-jp/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16). - 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](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](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. ## Setting items ### STEP1 Basic settings | 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 Transfer****using the query**. For more information on [Incremental Data Transfer](/docs/incremental-data-transfer), see [Incremental Data Transfer Function](/docs/incremental-data-transfer). | | 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. | ### STEP2 Detailed settings | 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. |