To continue configuring a connection to a Microsoft SQL Server database, enter properties as described in the following table.
Property | Type | Description |
---|---|---|
Database Server | Text field | The name of the machine on which the database is installed. |
Database Name | Text field | The name of the database to connect to. |
Instance Name | Text field | If your database has named instances, provide the specific instance that you want to connect to. Otherwise, leave the default value, Default. |
Port | Text field | The number of the port that the database instance is listening to. |
Property | Type | Description |
---|---|---|
TNS Name | Text field | ID that points to the Oracle configuration file that you can edit from the Oracle client |
Property | Type | Description |
---|---|---|
JDBC Driver Class | Text field | The Java class that implements the JDBC driver for your database. |
Driver URL | Text field | A URL pointing to the database instance |
Property | Type | Description |
---|---|---|
Hide NULL values for translatable columns | Check box | If checked, hides fields containing null values from the view. This is useful when the database is sparsely populated, that is, there are many fields wtih null values. If you clear the check box, all fields are shown. |
Database Username | Text field | The username for WorldServer to use when connecting to the database. |
Database Password | Text field | The password for WorldServer to use when connecting to the database. |