The Parameter Settings section of the Inbound SQL Server Environment contains the top-level parameters displayed in the following table.
Table 40 Inbound SQL Server Adapter Environment Properties
Name |
Description |
Required Value |
---|---|---|
Description |
Enter a description for the database. |
A valid string. The default is SQLServer DriverManager. |
ServerName |
Specifies the host name of the external database server. |
Any valid string. |
PortNumber |
Specifies the I/O port number on which the server is listening for connection requests. |
A valid port number. The default is 1433. |
DatabaseName |
Specifies the name of the database instance used on the Server. |
Any valid string. |
User |
Specifies the user name that the Adapter uses to connect to the database. |
Any valid string. |
Password |
Specifies the password used to access the database. |
Any valid string. |