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
Anonymous
Parents Comment Children
No Data