When data sources in the ODX Server do not automate primary keys, you need to manually define the primary key. By default the Data Type is set to Unknown which typically matches nothing. As a result you need to explicitly choose the type, but oftentimes you only care about the field in a table whatever the type is.
I propose to add an ‘Any’ option and having this be the default.
