Global Resource Properties

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.  
Required settings
Item name Required/Optional Use of variables Description Remarks
Account identifier Required Only environment variables are available Enter the account identifier.
  • Disabled when [Enter URL directly] is checked.
Role name Required Only environment variables are available Enter the role name.
  • Disabled when [Enter URL directly] is checked.
Warehouse name Required Only environment variables are available Enter the warehouse name.
  • Disabled when [Enter URL directly] is checked.
Database name Required Only environment variables are available Enter the database name.
  • Disabled when [Enter URL directly] is checked.
Schema name Required Only environment variables are available Enter the schema name.
  • Disabled when [Enter URL directly] is checked.
Enter URL directly Optional Not available Select whether or not to enter the URL of destination Snowflake database directly.
  • [Checked]:
    Enter the URL directly.
  • [Not checked]: (default)
    Generate URL based on the settings of [Account identifier], [Role name], [Warehouse name], [Database name], [Schema name], and [Login timeout (sec)].
  
URL Required Only environment variables are available Enter the URL.
Standard URL format of Snowflake is “jdbc:snowflake://<Account identifier>.snowflakecomputing.com/<Connection parameters>”.
The adapter supports URL which is supported by the JDBC driver.
  • Enabled when [Enter URL directly] is checked.
Authentication method Required Not available Select the authentication method.
  • [Password AUTH]:(Default)
    Perform authentication by using [User name] and [Password].
  • [Key pair AUTH]
    Perform authentication by using a key pair.
 
User name Required Only environment variables are available Enter the user name.  
Password Optional Only environment variables are available Enter the password.
  • This becomes valid and required when [Password AUTH] is selected for the [Authentication method].
Private key Optional Only environment variables are available Enter the file path of private key.

You can click [Browse] button to launch file chooser and find the file.
  • This becomes valid and required when [Key pair AUTH] is selected for the [Authentication method].
  • Place the setting files under any folder on the DataSpider file system (we recommend placing it under "/data" folder).
  • Specify the file path as an absolute path of the DataSpider file system.
  • Except for the path separator “/”, restricted characters of DataSpider File System cannot be used.
Private key passphrase Optional Only environment variables are available Enter the private key passphrase.
  • This becomes valid when [Key pair AUTH] is selected for the [Authentication method].
Property actions
Item name Description Remarks
Connection test Check the database connection.  
Timeout settings
Item name Required/Optional Use of variables Description Remarks
Login timeout (sec) Optional Only environment variables are available Enter the login timeout.
  • Disabled when [Enter URL directly] is checked.
  • Allowed values are 0-300.
  • Default value is 300. When omitted, or when an invalid value is entered, 300 will be applied.
  • If the value is 0, timeout does not occur.
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

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

Security

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