JDBC Snap Pack
In this page
Overview
The JDBC Snap Pack enables seamless integration and data connectivity with diverse databases through JDBC (Java Database Connectivity) technology. This Snap Pack supports DCL commands (Grant and Revoke).
This Snap Pack supports integration with AWS Athena database; however, it supports only create, alter, insert, and select operations.
Athena JDBC Driver 1.x versions are deprecated, and the Generic JDBC Snaps are incompatible with the Athena JDBC 1.x drivers. Hence, we recommend you to use Athena JDBC Driver 2.x or higher version when connecting to the Athena database.
This Snap Pack contains the following Snaps:
Generic JDBC - Execute: Execute a SQL statement/query against a SQL database.
Generic JDBC - Select: Retrieves data from a SQL database by executing a SQL SELECT statement/query.
Generic JDBC - Update: Updates data in a SQL database by executing a SQL UPDATE statement/query.
Generic JDBC - Insert: Inserts data into a SQL database by executing a SQL INSERT statement/query.
Generic JDBC - Schema List: Obtains a list of schemas for the specified account from the database.
Generic JDBC - Table List: Obtains a list of tables associated with a specified schema from the database.
Prerequisites
Appropriate permissions to perform CRUD operations on the database.
The Snaplex should have access to database IP and Port.
Timestamp format with respect to the database you are connecting must match.
A JDBC driver and .jar files must be installed and configured for the appropriate database to make a successful JDBC connection. The JDBC driver for each type of database you want to connect to may contain typically one .jar file or in some cases multiple .jar files.
Contact your database vendor to get the appropriate driver. Additionally, there are third-party companies that sell commercial JDBC drivers.
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
Supported Versions
This Snap Pack is tested against the following databases:
Database | Version | Driver |
---|---|---|
Cassandra | 3.0 |
|
DB2 | v11.5.4.0 |
|
Informix | Informix Dynamic Server 14.10.FC5DE |
|
MySQL | 5.6.34 |
|
Maria DB | 10.5.5 |
|
Mongo DB | 2.6.12 3.4.2 | |
SQL Server | 11.00.2100, 12.0.20008, 13.0.4224.16, 14.0.1000.169 (Windows AD) 16.0 |
|
Oracle | 19c |
|
SAPHANA | 2.00.040.00.1553674765 |
|
Redshift | RedshiftJDBC42-2.1.0.11 |
|
Snowflake | 3.13.25 | Snowflake JDBC jar |
PostgreSQL | PostgreSQL 9.6.19, PostgreSQL 10.12 |
|
Teradata | 15.10.07.08,16.20.22.01 |
|
Vertica | v10.0 |
|
Supported Objects and Task Operations
This Snap Pack provides support for the following objects and task operations:
Snap | Operation |
---|---|
Generic JDBC - Insert Snap | Database Insert |
Generic JDBC - Execute Snap | Database Query, Database Update |
Generic JDBC - Select Snap | Database Select |
Generic JDBC - Update Snap | Database Update |
Snap Pack History
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
August 2024 | 438patches28052 | Sep 18, 2024 | Latest | Fixed a connectivity issue with the Generic JDBC Snaps that resulted in an error when attempting to connect the JDBC account to a Sybase database using the 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. |
August 2024 | main27765 | Aug 21, 2024 | Stable | Updated and certified against the current Snaplogic Platform release. |
May 2024 | 437patches27416 | Jul 29, 2024 | Latest | Fixed an issue with the Generic JDBC—Insert Snap that exposed sensitive information in the error message when the batch operation was not successful. |
May 2024 | main26341 | May 8, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
February 2024 | 436patches25244 | Feb 26, 2024 | Latest |
|
February 2024 | main25112 | Feb 14, 2024 | Stable | Added the following new Snaps to the JDBC Snap Pack:
|
November 2023 | 435patches24781 | Feb 6, 2024 | Latest | The database connection error message in the Generic Database Account is improved for clarity and readability. |
November 2023 | main23721 | Nov 8, 2023 | Stable | Updated and certified against the current SnapLogic Platform release. |
August 2023 | main22460 | Aug 16, 2023 | Stable | Updated and certified against the current SnapLogic Platform release. |
May 2023 | main21015 | May 10, 2023 | Stable | The Generic Database Account now supports the SSH Tunneling connection. You can now encrypt the network connection between your client and the database server, ensuring a highly secure connection. |
February 2023 | main19844 | Feb 9, 2023 | Stable | Upgraded with the latest SnapLogic Platform release. |
November 2022 | main18944 | Nov 10, 2022 | Stable | The Generic JDBC - Insert Snap previously took a longer time to execute and was aborted after a few minutes, which affected the performance of the Snap. The Snap's performance is optimized now and takes lesser time for execution. |
September 2022 | 430patches17894 | Sep 16, 2022 | Latest | The Generic JDBC Snaps connecting to the DB2 database now take lesser time to execute thereby improving the performance. |
August 2022 | main17386 | Aug 11, 2022 | Stable | Enhanced the Generic Database account Support dynamic values for Account, Advanced, and URL properties. |
4.29 Patch | 429patches16588 | Jun 24, 2022 | Latest |
|
4.29 | main15993 | May 14, 2022 | Stable | Enhanced the Generic Database Account in the JDBC Snap pack to include Netsuite as an option for the Database name field to connect to the NetSuite database. While configuring the account, if you select Netsuite or Autodetect (if the Snap detects the target database as NetSuite) then the Limit rows field in the Generic JDBC - Select Snap is ignored. |
4.28 | main14627 | Feb 12, 2022 | Stable | Enhanced the following Snaps to support DML (Data Manipulation Language) operations (CREATE, ALTER, INSERT, and SELECT) when using AWS Athena database. |
4.27 | main12833 | Nov 13, 2021 | Stable |
|
4.26 | main11181 | Aug 14, 2021 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.25 Patch | 425patches11008 | Aug 4, 2021 | Latest |
|
4.25 | main9554 | May 8, 2021 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.24 Patch | 4.24patches8903 | Mar 13, 2021 | Latest | Fixes the Pipeline execution failure issue when using the JDBC Snaps with a Microsoft Access account by setting the correct quotation handler for the configured account. |
4.24 | main8556 | Feb 13, 2021 | Stable | Enhances the Generic JDBC - Select Snap to return only the fields (provided in the Output Fields) in the output schema (second output view), through a new check box Fetch Output Fields In Schema. If the Output Fields property is empty all the columns are visible. |
4.23 Patch | 423patches8027 | Jan 29, 2021 | Latest | Fixes the multiple connection issue in the JDBC Snap Pack that occurs when the Auto Detect field is enabled for each execution of the Snap by storing a copy of the database name. |
4.23 Patch | 423patches7800 | Dec 21, 2020 | Latest | Fixes an issue with JDBC account through a Test Query option that establishes a database connection upon using Auto detect option for the Database name. |
4.23 | main7430 | Nov 14, 2020 | Stable |
|
4.22 Patch | 422patches7246 | Nov 6, 2020 | Latest | Fixes the file descriptor error in the Snap Pack by removing logging exception which was causing log file spam. |
4.22 Patch | 422patches6772 | Oct 5, 2020 | Latest | Fixes the issue with |
4.22 | main6403 | Sep 12, 2020 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.21 Patch | 421patches6272 | Jan 22, 2020 | Latest | Fixes the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected. |
4.21 Patch | 421patches6144 | Jul 20, 2020 | Latest | Fixes the following issues with DB Snaps:
|
4.21 Patch | MULTIPLE8841 | May 19, 2020 | Latest | Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. |
4.21 | snapsmrc542 | May 9, 2020 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.20 Patch | jdbc8783 | Mar 26, 2020 | Latest | Fixes the Generic JDBC Execute Snap that adds the value of the previous column's field to a NULL field when SELECT queries having duplicate column names are run on the PostgreSQL database. |
4.20 | snapsmrc535 | Feb 8, 2020 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.19 Patch | db/jdbc8405 | Dec 13, 2019 | Latest | Fixes an issue with the Generic JDBC - Update Snap wherein the Snap is unable to perform operations when:
|
4.19 | snaprsmrc528 | Nov 14, 2019 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.18 | snapsmrc523 | Aug 10, 2019 | Stable | Added support for JDBC account Active Directory authentication for SQL server for driver JAR version |
4.17 | ALL7402 | Jun 11, 2019 | Latest | Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. |
4.17 | snapsmrc515 | Jun 11, 2019 | Latest |
|
4.16 Patch | MULTIPLE7123 | Feb 16, 2019 | Latest | Added two new properties, Number of retries and Retry interval, to Execute, Insert, Select, and Update Snaps that enables you to handle retry attempts during a connection failure. |
4.16 | snapsmrc508 | Feb 16, 2019 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.15 | snapsmrc500 | Dec 15, 2018 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.14 | snapsmrc490 | Aug 11, 2018 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.13 Patch | jdbc5231 | May 30, 2018 | Latest | Added binding information for DB2 database connection on the Generic JDBC Snap Pack to ensure that pipelines correctly validate and execute. |
4.13 Patch | jdbc5229 | May 24, 2018 | Latest | Added test connection query for SQLMX database in the JDBC Accounts to check if the database connection is valid. |
4.13 | snapsmrc486 | May 12, 2018 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.12 Patch | MULTIPLE4744 | Feb 27, 2018 | Latest | Added support to execute multiple queries in a single batch for Snowflake, this patch affects Generic JDBC Execute. |
4.12 | snapsmrc480 | Feb 17, 2018 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.11 | snapsmrc465 | Nov 11, 2017 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.10 | snapsmrc414 | Aug 12, 2017 | Stable | Adds Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level. |
4.9.0 Patch | jdbc3242 | Jul 11, 2017 | Latest | Addresses an issue in JDBC Execute Snap with functions not working (fixes by executing commit() at the end of the processing query). |
4.9.0 Patch | jdbc3205 | Jul 6, 2017 | Latest | Fixes auto-commit issue for PostgreSQL SELECT query. |
4.9.0 Patch | jdbc3133 | Jun 29, 2017 | Latest | Fixed error handling of the limit clause by adding Apache Derby support. |
4.9.0 Patch | jdbc3069 | Jun 1, 2017 | Latest | Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap. |
4.9 | snapsmrc405 | May 13, 2017 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.8.0 Patch | jdbc2801 | Apr 3, 2017 | Latest | Addressed an issue with Generic JDBC - Execute Snap holding the resultset in memory, exhausting memory and causing a core dump. |
4.8.0 Patch | jdbc2753 | Mar 27, 2017 | Latest | Potential fix for JDBC deadlock issue. |
4.8 | snapsmrc398 | Feb 11, 2017 | Stable |
|
4.7 Patch | jdbc2195 | Nov 28, 2016 | Latest | Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter. |
4.7 | snapsmrc382 | Nov 23, 2016 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.6 | snapsmrc362 | Aug 13, 2016 | Stable |
Known Issue:
|
4.5.1 | snapsmrc344 | May 18, 2016 | Stable | Resolved an issue with JDBC Select failing with a syntax error when special characters were used. |
4.5 | snapsmrc344 | May 18, 2016 | Stable |
|
4.4.1 | N/A | Mar 18, 2016 | Stable |
|
4.4 | N/A | Feb 13, 2016 | Stable | Upgraded with the latest SnapLogic Platform release. |
4.3.2 | N/A | Jan 15, 2016 | Stable | Resolved an issue with Generic JDBC Update updating null into database when an invalid string value is provided as input for time datatype. |
4.3.1 | N/A | N/A | Stable |
|
4.2.2 | N/A | N/A | Stable |
|
4.2.1 | N/A | N/A | Stable |
|
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.