Global Resource Properties

For any information regarding SQL Server(ODBC)Adapter Global Resource properties, see here.

Connection Settings

Connection settings for a Global Resource can be managed in the property setting dialog for each adapter, in the 'Global Resource Settings' within the Control Panel, or from 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 out of the operation database on editing.
Required settings
Item name Required / Optional Use of Variables Description Remarks
Proxy server Required Only environment variables are available. Enter JDBC Proxy Server host name/IP address.  
Proxy port number Required Only environment variables are available. Enter JDBC Proxy Server port number.  
ODBC data source name Required Only environment variables are available. Enter the name of the ODBC data source.  
Database name Optional Only environment variables are available. Enter the database name.
  • If omitted, or different from the database specified with the ODBC data source, refers to database specified with ODBC database.
User name Optional Only environment variables are available. Enter the user 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 a number of tables listed.
  • Enabled when [Specify the number of tables in the list] is checked.
  • Defaults to 500 if omitted.Defaults to 500 if omitted, or if the value specified is invalid.

Components Pool Settings

Pooling is not supported.

Security

Security settings can be managed in 'Global Resource Settings' within Control Panel or from WebConsole.