Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
6 subscribers
Views
1791 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
We have a requirement to have an Appian document (file) inserted into a database
Howard
over 9 years ago
We have a requirement to have an Appian document (file) inserted into a database record. I noticed that there is a plugin to convert the document into base64 and be inserted into a database record, but that is for version 7.10+. Unfortunately, we are currently on 7.8. Does anyone know another method to get an Appian document into a database record?
OriginalPostID-205251
OriginalPostID-205251
Discussion posts and replies are publicly visible
0
Eliot Gerson
Appian Employee
over 9 years ago
Could you please elaborate a bit on your use case for having the document stored in the database? Typically, you should have the document stored on the server and use the Document ID to reference the document when necessary.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Howard
over 9 years ago
The application group that is requesting this does not have a server to store documents. They currently store the workflow data into a database and they want to also store the document into a varbinary(max) field and the document name into a nvarchar(256) field. According to the application group, this file can be recreated with a program that runs outside of Appian with these two fields at a later time.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eliot Gerson
Appian Employee
over 9 years ago
This is approach is not recommended, for performance reasons. I'll follow up with you separately and we can discuss this in more detail.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel