In this article
...
Use this account type to connect MySQL Snaps with datasources that use MySQL Dynamic accounts. This account deals with the dynamically calculated values. You can specify the account properties as expressions referencing pipeline parameters. The values for dynamic accounts are not stored; hence, use them when requested.
Prerequisites
- None.
Account Settings
Use the Create Account window\Settings tab to create MySQL Dynamic accounts:
Parameter Name | Data Type | Description | Default Value | Example | ||||
---|---|---|---|---|---|---|---|---|
Label | 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 Driver Class | String | The class name of the JBDC driver. | N/A | com.mysql.jdbc.Driver | ||||
JDBC JARs | N/A | List of JDBC JAR files to be loaded. Click the + button on the right of the field to add a row.
| N/A | ../shared/sqljdbc4-2.0.jar | ||||
JDBC Driver | String | The software component enabling an application to interact with a database. | N/A | .../shared/jsonappend.json | ||||
Account properties | N/A | Required. Input required for the application to connect to the database. | N/A | N/A | ||||
Hostname | String | Required. The Server address to which the application must connect. | N/A | mysql.awerwe.us-east-1.rds.amazonaws.com | ||||
Port Number | Integer | Required. Database server's port number to which the application must connect. | 3306 | 3306 | ||||
Database name | String | Required. The database name to which the application must connect. | N/A | information_schema | ||||
Username | String | Required. 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 | EricJones | ||||
Password | String | Required. 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 | N/A | ||||
Configure SSH Tunnel | String | SSH configuration to connect to MySql through SSH Tunneling. If selected, the configuration details of the SSH Tunnel must be provided. | Not selected | N/A | ||||
SSH Hostname | String | The SSH Server address to connect to. | N/A | N/A | ||||
SSH Auth Mode | String | A drop-down menu to select the authorization mode for the SSH Tunnel. The valid options are:
| Password | Password | ||||
SSH Username | String | Name of the SSH user to connect with. | N/A | N/A | ||||
SSH Password | String | SSH user password to connect to the SSH Tunnel. | N/A | N/A | ||||
KeyStore | String | The path to the key store file. The location of the key store file can be in SLDB or any other unauthenticated endpoint such as https://... Click to select the appropriate file from the file browser. | N/A | N/A | ||||
PassPhrase | String | The password to access the private key from the key store. | N/A | N/A | ||||
KeyStore Password | String | The password to access the key store. | N/A | N/A | ||||
Key alias | String | The alias for the private key to be used from the key store. | N/A | N/A | ||||
Advanced properties | N/A | Advanced input required for connecting to the database. | N/A | N/A | ||||
Auto commit | N/A | 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 | ||||
Batch size | Integer | 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 | ||||
Fetch size | Integer | Required. Number of rows to fetch at a time when executing a query.
| 100 | 100 | ||||
Max pool size | Integer | 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 | ||||
Max life time | Integer | 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 | ||||
Idle Timeout | Integer | 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 | ||||
Checkout timeout | Integer | 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 | ||||
URL properties | N/A | Input regarding URL properties. | N/A | N/A | ||||
URL property name | String | URL property name | N/A | zeroDateTimeBehavior | ||||
URL property value | String | URL property value | N/A | convertToNull |
Limitations
- None.
Troubleshooting
...