String

Required. The name for the account. Preferably, update the account name if your project includes more than one account of the same type.

N/A

MySQL_DynamicAccount

JDBC URL Source

String

Select the source of the JDBC URL. 

• Snap Generated: The JDBC URL that SnapLogic generates using the details you provide in the Account Settings dialog. If you choose this option, the Host Name, Port Number, and Database Name fields are displayed.

• User Provided: Allows you to specify custom JDBC URLs. When you choose this option the Custom JDBC URL field appears.

Snap Generated

 User Provided

JDBC driver class 

String 

The class name of the JBDC driver.

N/A

com.mysql.jdbc.Driver

JDBC JARs

List of JDBC JAR files to be loaded. Click the + button on the right of the field to add a row.

String

Upload the JDBC driver and other JAR files that you want to use into SLDB. For more information about JDBC drivers and downloading the appropriate driver for your account, see Downloading the JDBC Driver.

N/A

Project Spaces/my_diagnostic_space/my_diagnostic /sqljdbc4-2.0.jar

Account properties*

Fieldset

Required. Input required for the application to connect to the database.

String/Expression

Required. Appears when the JDBC URL Source is Snap Generated. 

The Server address to which the application must connect.

N/A

_hostname

Integer/Expression

Required. Appears when the JDBC URL Source is Snap Generated. 

Database server's port number to which the application must connect.

3306

_port

String/Expression

Required. Appears when the JDBC URL Source is Snap Generated. 

The database name to which the application must connect.

N/A

_database 

String/Expression

Required. Appears when the JDBC URL Source is Snap Generated. 

The user name that is allowed to connect to the database. It is used as the default user name when retrieving connections. The user name must be valid in order to set up the data source.

N/A

_username

String/Expression

Required. Appears when the JDBC URL Source is Snap Generated. 

The password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid in order to set up the data source.

N/A

_passsword

Custom JDBC URL

String

Appears when the JDBC URL Source is User Provided.

Specify the JDBC URLs that you want to use to connect to your MySQL Account.

Use this option if you want to use complex JDBC URLs (involving multiple hosts and advanced options) to connect to your MySQL instance. For example, if you want to connect to MariaDB, you can enter a JDBC URL like the one below:

jdbc:mariadb://test1sp007.hq.xyz.com:6519,test1sp007.hq.company.com:6519/example

N/A

 jdbc:mariadb://a.com:3306,b.com:3306/db

Checkbox/Expressions

Select this checkbox if Snap must create an SSH tunnel dynamically to connect the JCC node to the MySQL server. Once the operation is completed, the tunnel is closed.

If selected, the configuration details of the SSH tunnel must be provided.

Not selected

N/A

Dropdown List/Expressions

Select the mode for authenticating the user on the SSH tunnel. The associated properties are displayed. 

The valid options are:

• Password: If selected, the SSH Hostname, SSH Username and the SSH Password properties must be configured.

• KeyFile: If selected, the SSH Hostname, SSH Username, KeyStore, KeyStore Password, Key alias, and Private Key Passphrase properties must be configured. 

This value is considered only if the Configure SSH Tunnel check box is selected.

Password

Password

SSH hostname*

Strings/Expressions

The IP address or the domain name of the SSH server to which you want to connect.

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_sshhostname

Strings/Expressions

The SSH username for connecting to the tunnel. 

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_sshusername

Strings/Expressions

The password associated with the SSH user name. This field is required if Auth Mode is Password.

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_sshuserpassword

Strings/Expressions

The location of the keystore file. This field is required if SSH Auth Mode is KeyFile.

The file can be in SLDB, on the host machine that is hosting the JCC, or at any other remote location. For a local file, click

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_keystorepath

Strings/Expressions

The password required to access the keystore file. This field is required if SSH Auth Mode is KeyFile.

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_keystorepassword

Strings/Expressions

The identifier or label of the private key to be used from the keystore. This field is required if the SSH Auth Mode is KeyFile.

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

_keyalias

Strings/Expressions

The password associated with the private key. If no value is provided, the keystore password is used. 

This value is considered only if the Configure SSH Tunnel check box is selected.

N/A

N/A

Advanced properties

Fieldset

Advanced input required for connecting to the database.

Checkbox/Expressions

Auto-commit property for the database. 

When selected, each of the batches is committed immediately after it is executed. If the Snap fails, only the batch being executed at that moment is rolled back.

When deselected, the Snap execution output is committed only after all the batches are executed. If the Snap fails, the entire transaction is rolled back, unless the Snap finds invalid input data before it sends the insert request to the server, and routes the error documents to the Error view.

Selected

Selected

Integer/Expressions

Required. Batch size defines how many SQL statements can be executed in a single batch. For example, when inserting 100 records with batch size as 40, there will be 100 insert statements, and they are executed in 3 batches, the first and second batches contain 40 insert statements each and the third batch contains 20.

It is part of the JDBC standard, there is no maximum limit on the batch size. However, the JDBC drivers do not necessarily follow the standard and could throw exceptions if the batch size is too large for a specific driver. Reduce the batch size if you see an exception saying that the batch size is too large.

50

50

Integer/Expressions

Required. Number of rows to fetch at a time when executing a query.

100

100

Integer/Expressions

Required. Maximum number of concurrent connections a pool will maintain at a time. The number of max pool size depends on how many concurrent connections you need. Each MySQL Snap holds a separate connection when running. For a pipeline that has 4 MySQL Insert, 2 MySQL Execute, and 1 MySQL Update Snaps, the max pool size should be no less than 7 to make sure that the pipeline is executed successfully.

50

50

Integer/Expressions

Required. The maximum time (in minutes) of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed.

30

30

Integer/Expressions

Required. The maximum time (in seconds) a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool.

5

5

Integer/Expressions

Required. The number of milliseconds to wait for a connection to be available when the pool is exhausted. A value of 0 waits forever. An exception will be thrown after the wait time has expired.

10000

10000

N/A

Input regarding URL properties.

N/A

N/A

String/Expression

URL property name

N/A

zeroDateTimeBehavior

String/Expression

URL property value

N/A

convertToNull