[teiid-issues] [JBoss JIRA] (TEIID-5809) Please add support for deltatoken, not sure if bug or feature request

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13779144#comment-13779144 ] 

Steven Hawkins commented on TEIID-5809:
---------------------------------------

> I do not know these tools. But Debizium looks like something different.

It's for change data capture.  If a source does not expose delta functionality, you need something to capture when and what is changing.

>  Seems like their database layout generator adds two additional columns to each table, "deleted" and "last modified". They also provide a deltatoken command. Exactely like you mentioned. My hope was that there might be some support in Olingo already that I could reuse.

The support in olingo is to just provide the parsed query option - they have no processing logic on their notion of Entity.  The Teiid logic would have to look for the delta tokens and see if the Entities included the appropriate modification properties/procedures - which would require either a name/type based convention and/or extension metadata.  Note that Salesforce exposes similar information via audit fields on each sObject and a procedure to find what has been deleted, so finding the deleted information will vary by backend.

> Are you aware of a javascript based odata frontend which supports offline odata together with Teiid?

Not that I'm aware of.

> Please add support for deltatoken, not sure if bug or feature request
> ---------------------------------------------------------------------
>
>                 Key: TEIID-5809
>                 URL: https://issues.jboss.org/browse/TEIID-5809
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: OData
>    Affects Versions: 13.x
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 13.x
>
>
> Hello Steven,
> I am currently looking into the use of the deltatoken for offline synchronization. It seems like Teiid simply ignores the command. The following example results in the full collection to be 
> returned and not just the differences according to the deltatoken date. Is the deltatoken a feature which should currently work?
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?!deltatoken=2019-10-05T14:01:01Z



--
This message was sent by Atlassian Jira
(v7.13.5#713005)