How to Define "BLOB" dataType of SQL in Appian CDT

mohammedz

Certified Associate Developer

over 8 years ago

Guyz,

I have a table in database with three columns
ID - Number
Document - BLOB
Name - VARCHAR

The Document column is of "BLOB" DataType....
Now I need to create a CDT and Map it to the Table
To do so what should be the dataType in my CDT or XSD Definition

Appreciate ur response....!!!!

Discussion posts and replies are publicly visible

Top Replies

ankitb0003 over 8 years ago +1

I have used the following definition for CLOB, It worked for me. it should be same for BLOB. <xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian…

Parents

0 Stefan Helzle
A Score Level 3
over 8 years ago

To store documents in DB there is some plugins available.

forum.appian.com/.../blob

You will have to check compatibility of these plugins as they are for 7.10. To access the data from Appian you can just skip the document field as the plugin uses SQL queries to read and write data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

To store documents in DB there is some plugins available.

forum.appian.com/.../blob

You will have to check compatibility of these plugins as they are for 7.10. To access the data from Appian you can just skip the document field as the plugin uses SQL queries to read and write data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data