RDBMS Blob Utility

Provides four Smart Services for interacting with RDBMS BLOB and CLOB columns.

• Send File to RDBMS Blob: This smart service allows for sending Appian document to Blob column in RDBMS

Input: Data Source Name Blob SQL Query (Please include "?" as parameter to refer to blob column in the column list and keep it as first parameter (i.e. "INSERT INTO [TABLE_NAME] ([BLOB_COLUMN]) VALUES (?)")) Document to send to RDBMS Blob Output: Success Error Message

• Receive File from RDBMS Blob: This smart service allows for receiving content of Blob column in RDBMS to save into Appian Document

Input: Data Source Name Blob SQL Query (i.e. "SELECT [BLOB COLUMN] FROM [TABLE NAME]") Blob Column Destination Folder Document Name Document Extension Document Description Output: Success Error Message

• Send File to RDBMS Clob: This smart service allows for sending Appian document to Clob column in RDBMS

Input: Data Source Name Clob SQL Query (Please include "?" as parameter to refer to clob column in the column list and keep it as first parameter (i.e. "INSERT INTO [TABLE_NAME] ([CLOB_COLUMN]) VALUES (?)")) Document to send to RDBMS Clob Output: Success Error Message

• Receive File from RDBMS Clob: This smart service allows for receiving content of Clob column in RDBMS to save into Appian Document

Input: Data Source Name Clob SQL Query (i.e. "SELECT [CLOB COLUMN] FROM [TABLE NAME]") Clob Column Destination Folder Document Name Document Extension Document Description Output: Success Error Message

Version 1.0.1: Fix bugs in Send File to RDBMS Blob for non-Oracle DB: Use executeUpdate instead of executeQuery

version 1.2.0 Added New Smart services to support sending and receiving of Clob data Send File to RDBMS Blob Receive File from RDBMS Blob Send File to RDBMS Clob Receive File from RDBMS Clob

Modernized aspects of code base, including improved logging and implementation of try-with-resources Updated all classes to replace deprecated Content Management API usage with newest Appian APIs