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
5 replies
Subscribers
7 subscribers
Views
3029 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
MySQL data ttype for serialized data
sathishkumars
over 8 years ago
Software: Appian 16.3, on-cloud, MySQL.
Use Case: Store the incoming requests (JSON) of a POST webAPI (asynchronous) in MySQL table' column, which can then be processed later (for example - store the requests in table in business hours and process them out side of business hours, to reduce the load on server at business hours). I am using externalize() and internalize() functions.
Query: What column type should be used to store serialized data in a MySQL db? And what data type should be used in Appian ? I assume, we can use varbinary, blob, text or JSON in MySQL and Text in Appian ? But from Appian's perspective what is considered the best and why ?
OriginalPostID-262593
Discussion posts and replies are publicly visible
Parents
0
Stefan Helzle
A Score Level 3
over 8 years ago
If you are not allowed to store customer data in cloud then Appian in cloud probably might not be the best solution for your use case. Externalize or base64 is NO encryption. Check this plugin:
forum.appian.com/.../summary
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
If you are not allowed to store customer data in cloud then Appian in cloud probably might not be the best solution for your use case. Externalize or base64 is NO encryption. Check this plugin:
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data