Microsoft SQL Server properties - Cloud

Talend Cloud Apps Connectors Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Inventory
Talend Data Preparation
Talend Pipeline Designer
Content
Administration and Monitoring > Managing connections
Design and Development > Designing Pipelines
Last publication date
2024-03-21
Properties to configure to connect to a Microsoft SQL Server database.

Microsoft SQL Server connection

Property

Configuration

Selection Select or enter Microsoft SQL Server.
Configuration
Engine Select your engine in the list.
Main If Define JDBC URL is disabled If this option is disabled, enter each parameter that identifies the database to be used in the corresponding fields.

Click Load default values in order to help you pre-fill the fields with the default values associated with this type of database.

Note: Use the host name of the target system instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate with the target system.
If Define JDBC URL is enabled If this option is enabled, enter the JDBC URL that identifies the SQL Server database.

The expected format is the following: jdbc:sqlserver://<host>[:<port>]/<database_name>

Note: Use the host name of the target system instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate with the target system.
User name Enter the user name used to connect to the SQL Server database.
Password Enter the password used to connect to the SQL Server database.
Advanced Force protocol If Define JDBC URL is disabled, you can enable this option to define the JDBC driver protocol.
Connection timeout Sets the maximum number of seconds that a user will wait for a connection to be available. If this time is exceeded and the connection is still unavailable, an exception is thrown.
Connection validation timeout Sets the maximum waiting time in seconds for a connection to be considered as alive.
Description Enter a display name (mandatory) and a description (optional) for the connection.

Microsoft SQL Server dataset

Property Configuration
Dataset name Enter a display name for the dataset. This name will be used as a unique identifier of the dataset in all Talend Cloud apps.
Connection Select your connection in the list. If you are creating a dataset based on an existing connection, this field is read-only.
Type Select the type of dataset you want to create:
  • Query: to query the data in your existing tables.
  • Table name: to access the table located in your database using its unique name.
  • Table streams: to access the specific table where changes are tracked using its unique name.
Main Query Enter the SQL query to access the data of your choice located in your Microsoft SQL Server table.
Table name Select or enter the unique name of your Microsoft SQL Server table.
Table streams Select or enter the unique name of your Microsoft SQL Server table, as well as the the name of the table stream to indicate the type of changes tracked in the table.

For more information on table streams and CDC, read the Snowflake documentation.

Advanced Fetch size Specifies the amount of data sent during one single communication step with the database. In the Fetch size field displayed, you need to enter the size in KB.

Additional JDBC parameters might be displayed depending on whether the connector is used as a source or destination dataset, read this section to know more about these parameters.