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
8 subscribers
Views
1725 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Has Anyone successfully execute read only queries from the Appian KDB Content da
Kami
over 10 years ago
Has Anyone successfully execute read only queries from the Appian KDB Content database? We understand this is unsupported but we need to find a way to extract very basic document metadata and, long story short, we want to do it directly from the kdb. Any tips on clients, setting up an odbc connection, q-queries for extracting document physical URL and folder names would be helpful. ...
OriginalPostID-93976
OriginalPostID-93976
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 10 years ago
What meta-data you're looking for that you cannot access via the ContentService API?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Kami
over 10 years ago
We can access via the content service but we don't have java resources to create a plugin (this is the long story).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Kami
over 10 years ago
-document physical url
-display names of folder path (including subfolders) to the document
-document display name
for 2.5 million documents across (approx) 14 knowledge centers
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
Even if we ignore the fact that accessing KDB directly is not a supported or recommended approach, it'll be easier for you to use the JAVA API to write your required service compared to finding expertise in KX.
I suggest you contact your Appian account executive and discuss your issues so we can assist you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Kami
over 10 years ago
Yes, we are doing that. My question still stands, if anyone has used Q-queries please let me know, any help will be appreciated.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel