I am attempting to integrate with external tables and views as data store entiti

rogerp63

Certified Senior Developer

over 8 years ago

I am attempting to integrate with external tables and views as data store entities for queries only (no updates). These tables use composite PKs. Appian is attempting to add a new column for a_id as the primary key. Since Appian doesn't support composite PK's I've attempted to identify a column w/ @Id, but apparently Appian realizes this is not a unique key and continues to attempt to add a_id. Is this possible with a table that uses composite PK?

Discussion posts and replies are publicly visible

0 Tom Ryan
Appian Employee
over 8 years ago

As you have probably already seen, make sure to keep in mind the best practices outlined in the documentation: forum.appian.com/.../Database_Schema_Best_Practices.html

That said, you should be able to map the XSD to the existing table using JPA annotations. Can you attach the XSD and the database table definition?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rogerp63
Certified Senior Developer
over 8 years ago

I think I figured it out. Even though I cannot add multiple PK's through the design interface, I was able to add the @Id to each of the fields in the XSD file and update the cdt.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel