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
7 subscribers
Views
1616 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I have integrated DB2 datasource with Appian. I want to access a table that is a
ankitt
over 10 years ago
I have integrated DB2 datasource with Appian. I want to access a table that is already present in the database(Table name - "Abc") and I created a CDT with the same name("Abc") and created a datastore, but I am still not able to access the table.
I think this problem has occurred because while creating a new datastore or querying any table, Appian converts all uppercase alphabets into lowercase and in my database tablename has got uppercase alphabets also. So that is why it is not mapping my CDT ("Abc" which will be referred as "abc") to DB2 Table ("Abc").
Is there any solution to this problem?...
OriginalPostID-125255
OriginalPostID-125255
Discussion posts and replies are publicly visible
0
Stefan Helzle
A Score Level 3
over 10 years ago
You can use JPA annotation to tell Appian how to map the CDT to DB tables. There is a very good chapter in the documentation on integration existing DB structures.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 10 years ago
forum.appian.com/.../Defining_a_Custom_Data_Type.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ankitt
over 10 years ago
Thank you> It worked for me.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel