Opening a connection to the MSSQL server - 7.1
MSSql
- EnrichVersion
- 7.1
- EnrichProdName
- Talend Big Data
- Talend Big Data Platform
- Talend Data Fabric
- Talend Data Integration
- Talend Data Management Platform
- Talend Data Services Platform
- Talend ESB
- Talend MDM Platform
- Talend Open Studio for Big Data
- Talend Open Studio for Data Integration
- Talend Open Studio for ESB
- Talend Open Studio for MDM
- Talend Real-Time Big Data Platform
- EnrichPlatform
- Talend Studio
- task
- Data Governance > Third-party systems > Database components > MSSql components
- Data Quality and Preparation > Third-party systems > Database components > MSSql components
- Design and Development > Third-party systems > Database components > MSSql components
Procedure
-
Double-click the tMSSqlConnection component
to open its Basic settings view in theComponent tab.
-
In the Host field, type in the IP address or
hostname of the MSSQL server, 192.168.30.47
in this example.
-
In the Port field, type in the port number of
the database server, 1433 in this
example.
-
In the Schema field, type in the schema name,
dbo in this example.
-
In the Database field, type in the database
name, talend in this example.
-
In the Username and Password fields, enter the credentials for the MSSQL
connection.