Opening a connection to the MSSQL server
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.