Page Comparison

Label*

Default Value: N/A
Example: Generic Database Account

String

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
Example: vertica-jdk5-6.1.2-0.jar

String/Expression

Specify the JDBC driver to use. Click the Upload icon to upload the JDBC driver that must be used for the account.

JDBC Driver Class*

Default Value: [None]
Example: com.vertica.jdbc.Driver

String/Expression

Specify the JDBC Driver class name to use.

JDBC URL

Default Value: [None]
Example: jdbc:vertica://Snaplogic.com/database

String/Expression

Specify the JDBC URL to use.

Username

Default Value: N/A
Example: Snapuser

String/Expression

Specify the database username to use.

Password

Default Value: N/A
Example: nb*#!@09

String/Expression

Specify the database password to use.

Database name

Default Value: Auto detect
Example: Oracle

String/Expression

Choose a database to which the account must be connected. The available options are:

• Auto detect: If you select Autodetect and if the Snap detects the target database as NetSuite then the Limit rows field in the Generic JDBC - Select Snap is ignored.

• PostgreSQL

• Redshift

• NetSuite: If you select NetSuite, then the Limit rows field in the Generic JDBC - Select Snap ignored irrespective of whether you provide a value or not.

• MySQL

• Oracle

• SQL Server 2012

• SQL Server 2008

• SAPHana

• Apache Hive

• DB2

• SQLMX

• Apache Derby

• Spark SQL

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
Example: Select 1

String/Expression

Activates on selecting Auto detect for Database name.

Specify a custom query to validate the database connection.

Advanced properties*

Min pool size*

Default Value: 0
Example: 0

Integer/Expression

Specify the minimum number of idle connections a pool will maintain at a time.

Max pool size*

Default Value: 15
Example: 10

Integer/Expression

Specify the maximum number of idle connections a pool will maintain at a time.

Max idle time*

Default Value: 60 
Example:100

Integer/Expression

Specify the number of minutes a connection must remain in the connection pool before being discarded.

Checkout timeout*

Default Value: 10000
Example:10000

Integer/Expression

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
Example:

• maxAllowedPacket

• encrypt

• selectMethod

String

Specify a name for the URL property to be used by the account. For instance:

• If you want the account to use trust certificates, specify the URL Url property name as trustServerCertificate and the URL property value as true.

• If you do not want the account to use encryption, specify the URL Url property name as encrypt and the URL property value as false.

• If you want to specify the method for selecting and navigating data in the database, use the URL Url property name as selectMethod, and to specify the type of cursor to be used, use the URL property value as cursor.

Url property value

Default Value: N/A
Example: 

• 1000

• false

• cursor

String

Specify a value for the URL property name.

Auto commit

Default Value: Selected

Checkbox

Select this checkbox to commit a batch immediately after the batch executes. So, only the current executing batch will be rolled back if the Snap fails.
If you deselect, then a transaction is started for the Snap run and committed upon run success. The transaction is rolled back if the Snap fails

Fetch size*

Default Value: 100
Example: 100

Integer/Expression

Specify the number of records to retrieve from the DB at a time.

Batch size*

Default Value: 50
Example: 10

Integer/Expression

Specify the number of query statements to execute at a time. SELECT queries are not batched.

• If the Batch Size is one, the query is executed as-is, that is the Snap skips the batch (non-batch execution).

• If the Batch Size is greater than one, the Snap performs the regular batch execution.