Generic Database Account
In this article
Overview
You can use this account type to connect JDBC Snaps with data sources that use the Generic Database account.
Prerequisites
None.
Limitations
None.
Known Issues
Generic JDBC Snaps connecting to the Informix database through the Generic Database account can cause thread leaks because of JDBC driver implementations.
Workaround: To avoid these thread leaks, do the following:
Use the Informix JDBC driver 4.50.4.1 version or a later version.
Configure the following URL properties in the account settings:
Url Property name: IFMXCONNECTION_CLEANER_THREADS
Url property value: 0
Breaking Change
Your existing pipelines that use JDBC Snaps to integrate with Oracle or Redshift databases using the bundled Oracle or Redshift JDBC drivers will stop functioning with the 438patches28052.
Workaround
You must manually upload the Oracle or Redshift JDBC driver in the JDBC Database account to run your pipelines successfully.
Download the drivers:
OJDBC: Maven Repository: com.oracle.database.jdbc » ojdbc6 » 11.2.0.4
Redshift: Maven Repository: com.amazon.redshift » redshift-jdbc42 » 2.1.0.11
Account Settings
Asterisk ( * ): Indicates a mandatory field.
Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.
Expression icon (): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon (): Indicates that you can add fields in the field set.
Remove icon (): Indicates that you can remove fields from the field set.
Field Name | Field Type | Field Dependency | Description |
---|---|---|---|
Label* Default Value: N/A | String | N/A | Specify a unique label for the account. |
Account properties* | The information required to create a connection to the database. | ||
JDBC JARs | Use this field set to define JDBC Drivers. This field set consists of the JDBC Driver field. | ||
JDBC Driver*  Default Value: N/A | String/Expression | N/A | Specify the JDBC driver to use. Click the Upload icon to upload the required JDBC driver that must be used for the account.
|
JDBC Driver Class* Default Value:Â [None] | String/Expression | N/A | Specify the JDBC Driver class name to use. |
JDBC URL Â Default Value:Â [None] | String/Expression | N/A | Specify the JDBC URLÂ to use. |
Username
| String/Expression | N/A | Specify the database username to use. |
Password  Default Value: N/A | String/Expression | N/A | Specify the database password to use. |
Database name  Default Value: Auto detect | String/Expression | N/A | Choose a database to which the account must be connected. The available options are:
If you use PostgreSQL JDBC driver to connect to Redshift database, the Auto detect option automatically detects the PostgreSQL database instead of Redshift. The behavior of the JDBC Snaps is optimized for the selected database. |
Test Query  Default Value: N/A
| String/Expression | Activates on selecting Auto detect for Database name. | Specify a custom query to validate the database connection. |
Configure SSH tunnel  Default Value: Deselected | Checkbox | N/A | Select this checkbox to connect to the database server through the SSH tunnel. After the operation is completed, the tunnel is closed. Learn more about SSH Tunneling Testing with PostgreSQL. |
SSH auth mode  Default Value: Password | Dropdown list | N/A | Select an option to specify the mode for authenticating the user on the SSH tunnel. The available options are:
|
SSH hostname Default Value: N/A | String/Expression | N/A | Specify the IP address or the domain name of the SSH server to which you want to connect. |
SSH username Default Value: N/A | String/Expression | N/A | Specify the SSH username that is authorized to connect to the database. This username is used as the default username when retrieving connections. |
SSH password Default Value: N/A | String/Expression | Appears if SSH Auth Mode is Password. | Specify the password for the SSH username for connecting to the SSH tunnel. |
Private key file URL Default Value: N/A | String/Expression | Appears if SSH Auth Mode is KeyFile (Private Key File). | Specify the location of the private key file. The file can be in SLDB, on the host machine that is hosting the JCC, or at any other remote location. Click the File browser icon to upload the file from your local system. You can also upload the file using any protocol such as HTTPS, FTP, SLDB, and SFTP. |
Private key* Default Value: N/A -----BEGIN RSA PRIVATE KEY----- ……………….. -----END RSA PRIVATE KEY----- | String/Expression | Appears if SSH Auth Mode is KeyFile (Private Key String). | Specify the private key for authentication. |
Private key passphrase Default Value: N/A Â | String/Expression | Appears if SSHÂ Auth Mode is KeyFile. | Specify the passphrase that is to be used to decrypt the private key. Â |
SSH port Default Value: N/A | Integer/Expression | N/A | Specify the SSH port to connect to any of the following database servers:
|
Advanced properties* | |||
Min pool size* Â Default Value: 0 | Integer/Expression | N/A | Specify the minimum number of idle connections a pool will maintain at a time. |
Max pool size*  Default Value: 15 | Integer/Expression | N/A | Specify the maximum number of idle connections a pool will maintain at a time. |
Max idle time* Â Default Value: 60Â | Integer/Expression | N/A | Specify the number of minutes a connection must remain in the connection pool before being discarded. |
Checkout timeout* Â Default Value: 10000 | Integer/Expression | N/A | Specify the number of milliseconds to wait for a connection to be available in the pool. |
Url properties | Use this field set to define URL properties to use in the JDBC URL. | ||
Url property name  Default Value: N/A
| String | N/A | Specify a name for the URL property to be used by the account. For instance:
|
Url property value Default Value: N/A
| String | N/A | Specify a value for the URL property name. |
Auto commit Default Value: Selected | Checkbox | N/A | Select one of the options for this property to override the state of the Auto commit property on the account. The Auto commit at the Snap-level has three values: True, False, and Use account setting. The expected functionality for these modes are:
|
Fetch size* Default Value: 100 | Integer/Expression | N/A | Specify the number of records to retrieve from the DB at a time. |
Batch size* Default Value: 50 | Integer/Expression | N/A | Specify the number of query statements to execute at a time. SELECT queries are not batched.
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
| Snap displays this error when the endpoint database driver lacks an implementation for the isValid() or any other method. | To address this issue, consider the following troubleshooting methods:
|
Snap Pack History
Related Content
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.