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
6 replies
Subscribers
11 subscribers
Views
2536 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hi all, We want to import attachments in SQL Server DB to Appian KC and sho
phanibabuk
over 8 years ago
Hi all,
We want to import attachments in SQL Server DB to Appian KC and show them under "Records".
The datatype used in the SQL table for attachments is "image" which is currently deprecated.
We tried casting/converting to base64binary but it didn't work.
Please let us know how can we import these attachments to Appian.
OriginalPostID-167878
OriginalPostID-167878
Discussion posts and replies are publicly visible
Parents
0
Umesh Patel
over 8 years ago
Its strange that even though Image data type is binary, its not treated as BLOB. Otherwise you might be able to leverage smart services to convert it to Base64. Can you try creating a DB view in which you convert image data type to BLOB and then pointing Appian to view?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Umesh Patel
over 8 years ago
Its strange that even though Image data type is binary, its not treated as BLOB. Otherwise you might be able to leverage smart services to convert it to Base64. Can you try creating a DB view in which you convert image data type to BLOB and then pointing Appian to view?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data