tMSSqlInput – Talend Components V8.0.1.20211103_1602

tMSSqlInput

Name:

tMSSqlInput

Icon:

Description:

Reads an MSSQL table and extracts fields based on an SQL query

Author:

Talend

Version:

8.0.1.20211103_1602

Download:

Example:

Coming soon…

Install Instructions:

1.Close your studio
2.Extract the content of tMSSqlInput.zip in a temporary folder
3.Copy the content of tMSSqlInput into your studio installation path to components folder: Talend-Studio -> plugins -> org.talend.designer.components.localprovider_8.0.1.20211104_0248 -> components

Release Date:

20070327A

Families:

Connectors:

Returns:

Name	Type	Description
NB_LINE	id_Integer	Number of line
QUERY	id_String	Query

Imports:

NAME	MODULE	REQUIRED_IF
Driver-jTDS	jtds-1.3.1-patch-20190523.jar	(DRIVER == ‘JTDS’) AND (USE_EXISTING_CONNECTION == ‘false’)
Driver-mssql-jdbc	mssql-jdbc.jar	(DRIVER == ‘MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
Talend_MssqlUtil	talend_DB_mssqlUtil-1.4.jar	true
adal4j	adal4j-1.6.5.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
commons-lang3	commons-lang3-3.10.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
commons-codec	commons-codec-1.14.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
gson	gson-2.8.6.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
oauth2-oidc-sdk	oauth2-oidc-sdk-6.5.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
json-smart	json-smart-2.4.7.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
nimbus-jose-jwt	nimbus-jose-jwt-8.11.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)
javax.mail	javax.mail-1.6.2.jar	(ACTIVE_DIR_AUTH == ‘true’) AND (DRIVER==’MSSQL_PROP’) AND (USE_EXISTING_CONNECTION == ‘false’)

Overview:

Component get from Talend

Thank you for watching.

Tutorial And Tips & Tricks.