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. ...

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