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.
Upgraded the JOOQ library of the JDBC Snap Pack from v3.9.1 to v3.17.x. Learn more.
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 |
---|---|---|---|---|
November 2024 | 439patches29008 | Nov 28, 2024 | Latest |
Breaking change: With the Behavior change: Earlier, the ROWID columns were displayed in binary (Base64 encoded data) form in the output. With the |
November 2024 | main29029 | Nov 13, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
August 2024 | 438patches28541 | Oct 22, 2024 | Latest | The JDBC Snap Pack version
|
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 |
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 |
|