Global Resource Properties

Connection Settings

Set global resource in the adapter properties, "Global Resource Settings" in the Control Panel, or WebConsole.
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name of the connection setting.
  
Type Required Not available Select the type of database to connect.
  • Cannot select the database of the editing operation.
Required settings
Item name Required/Optional Use of Variables Description Remarks
Hostname Required Only environment variables are available. Enter the host name of database.
  
Port number Optional Only environment variables are available. Enter the port number of database.
The default number is "1433". 		 
Database name Optional Only environment variables are available. Enter the database name.  
User name Required Only environment variables are available. Enter the user name.
  • Specify in format of "user name @ server name".
Password Optional Only environment variables are available. Enter the password.  
Property Action
Item name Description Remarks
Connection Test Checks the connection to the database.  
Display Settings
Item name Required/Optional Use of Variables Description Remarks
Specify the number of tables in the list Optional Not available Select whether to limit the number of tables listed or not.
  • [Checked]: (default)
    Limit the number of tables names listed.
  • [Not Checked]:
    Table names listed are not limited. Fetches all of the table names available.
  
Number of tables Optional Available Enter the number of tables listed.
  • Enabled when [Specify the number of tables in the list] is checked.
  • Defaults to "500" if omitted, or if the value specified is invalid.

Component pool settings

Pooling is not supported.

Security

You can only edit Security Settings from Control Panel, "Global Resource Settings" or WebConsole.