RDBMS Blob Utility

Overview

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

Key Features & Functionality

1. Send File to RDBMS Blob
   • Send an Appian document to Blob column in RDBMS
   • Inputs:
     • 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
   • Output:
     • Success
     • Error Message
2. Receive File from RDBMS Blob
   • Recieve content of Blob column in RDBMS to save into an Appian Document
   • Inputs:
     • 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
3. Send File to RDBMS Clob [New]
   • Send an Appian document to Clob column in RDBMS
   • Inputs:
     • 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
4. Receive File from RDBMS Clob [New]
   • Receive content of Clob column in RDBMS to save into an Appian Document
   • Inputs:
     • 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