I am creating a document in a process model, then biringing that inside an interface and storing it inside a local variable. Now i am trying to put that document along with other fields in a CDT. The table attached with the CDT has a blob data type for the document field, Will appian automatically handle the conversion. If no is there any way to solve this issue ?It is a txt doc.
Discussion posts and replies are publicly visible
No. In Appian we typically store the physical document in the file system. For management purposes, I typically store some additional data in a record.
Thank you for this info, if this way is not possible then can we
can we directly connect with appian db as a usual jdbc db to save the file
and then assign it some id and use it for saving in our table
this will reduce the burden of files to be saved in appian objectsinstead we save in db and then refer it using some primary key
I do not consider it a good practice to store files into the database. This is what a file system is made for.
Okay, So the only way is to store the file in appian internal system and put some metadata like doc id in the db table.
That's not what I said. You can also store files in an S3 storage, SharePoint, or somewhere else. But storing binary files in a relational database is not something I would want to do.
rudraksht548412 said:put some metadata like doc id in the db table.
This is what I successfully do in all my projects. And I never had any complaints.
Got it, Thank you so much for your help