Global Resource Properties

Sales and support for SQL Server (ODBC connection) adapter are finished.
For details on the global resource properties of SQL Server (JDBC connection) adapter, refer to here.

Connection Settings

The connection settings of global resource can be configured from the property settings of each adapter or “Global Resource Settings” of the control panel.
Basic settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not available Enter the name of the connection settings.  
Type Required Not available Select a destination database type.
  • You can only select the database of the editing operation.
Required settings
Item name Required/Optional Use of variables Description Remarks
Proxy server Required Only environment variables are available Enter the host name / IP address of JDBC Proxy Server.  
Proxy port number Required Only environment variables are available Enter the port number of JDBC Proxy Server.  
ODBC data source name Required Only environment variables are available Enter the ODBC data source name.  
Database name Optional Only environment variables are available Enter the database name.
  • When it its omitted or differs from the database specified in ODBC data source, the database specified in ODBC data source is referred to.
User name Optional Only environment variables are available Enter the user name.  
Password Optional Only environment variables are available Enter the password.  
Property actions
Item name Description Remarks
Connection test Check the database connection.  
List settings
Item name Required/Optional Use of variables Description Remarks
Limit the number of tables in list Optional Not available Select whether or not to limit the number of tables to display.
  • [Checked]: (default)
    Limit the number of tables to display in the list.
  • [Not checked]:
    Do not limit the number of tables displayed in the list and get all of the table names.
  
Number of tables in list Optional Available Enter the number of tables to display in the list.
  • Enabled when [Limit the number of tables in list] is checked.
  • Default value is 500. When omitted, or when an invalid value is entered, 500 will be applied.

Component Pool Settings

Component pool is not supported.

Security

The security settings can be configured in “Global Resource Settings” of the control panel.