I know that the old database connectivity node is being deprecated. I am trying to query a database by way of creating a query rule. I created a data type but the table I will be connecting to has no primary key. I find myself at a lost when I create the necessary XSD file and do not designate a primary key. I cannot get my data store to verify mappings. If I select a field in the table to be the primary key, I only get one record from the database table as a match. The field I designate as the primary key is the employees ID in the table.
Unfortunately, none of the fields in that table are a primary key so I realize that is why I only get one match if I force the issue. If I cannot make use of the deprecated database node, what solutions are available in SAIL to bring back all the records I need?
I am attaching a screenshot of the error I received when trying to verify mappings.
If this attachment is not viewable, the message says:
Discussion posts and replies are publicly visible