J
Jeff Leinbach
Guest
This is a defect in the user interface for the OData Schema Editor in the DataDirect Cloud data source configuration page. It is possible to use synonyms with OData interface by manually adding the values to the OData Schema Map configuration parameter. For example, my Oracle data source has the following setting where GTABLE is my table and GSYN is a synonym for that table: {"schemaName":"TESTSCHEMA","includedTables":["GTABLE","GSYN"],"tableMapping":[{"name":"GTABLE","key":["INTEGERCOL"]},{"name":"GSYN","key":["INTEGERCOL"]}]} Perhaps the synonyms are not being returned because they do not have a primary key defined on them. By default OData requires a primary key to be defined on the table so that each entity can be uniquely identified. For this particular example, I had to explicitly list INTEGERCOL as the primary key on my table.
Continue reading...
Continue reading...