tMSSqlOutput – Talend Components V8.0.1.20211103_1602

tMSSqlOutput
Name: tMSSqlOutput
Icon: tMSSqlOutput
Description: Inserts or updates lines into an MSSQL table
Author: Talend
Version: 8.0.1.20211103_1602
Download:

tMSSqlOutput V-8.0.1.20211103_1602 – Direct download

Example: Coming soon…
Install Instructions:
  • 1.Close your studio
  • 2.Extract the content of tMSSqlOutput.zip in a temporary folder
  • 3.Copy the content of tMSSqlOutput 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:
  • Databases/DB Specifics/MS_SQL_Server
Connectors:
  • FLOW
  • FLOW
  • ITERATE
  • SUBJOB_OK
  • SUBJOB_ERROR
  • COMPONENT_OK
  • COMPONENT_ERROR
  • RUN_IF
Returns:
Name Type Description
NB_LINE id_Integer Number of line
NB_LINE_UPDATED id_Integer NB Line Updated
NB_LINE_INSERTED id_Integer NB Line Inserted
NB_LINE_DELETED id_Integer NB Line Deleted
NB_LINE_REJECTED id_Integer Number Of Rejected Lines
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’)
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.

Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x