BusinessObjects Board

[SOLVED] odata and DateTimeOffset (Delta load)

dataservices job design
#1

hi,

I need to load data from C4C with odata in SAP DS.

I want to perform a delta load, based on a datetime field.

The odata is something like :
http:// … /OpportunityCollection$filter=ETag ge datetimeoffset’2019-10-09T00:00:00Z’

When designing the Data Flow, I select the OpportunityCollection datasource, and then put a Query Transform next to it with the following WHERE Clause :
ETag >= ‘2019-10-09T00:00:00Z’

It does exactly what should be done, and the odata only get the required data from the datasource.

Here’s the problem :
Obviously I cannot use the ‘2019-10-09T00:00:00Z’ constant, and I should use the value I read from my DB instead.

And I cannot get it working.
I tried to provides a varchar, but it’s not the right type, tried to do date conversions, but nothing works.

I know that DateTimeOffset is not supported by DataServices, but there might be some trick to have it working since the 1st example with a constant values works perfectly.

Did someone else try to perform delta load using odata sources with SAP DS ?

~ Yann ~ :fr: (BOB member since 2007-09-11)

#2

After investigation, it appears that the DateTimeOffset is not the cause of this problem, but only the fact that the WHERE clause seems to only manage constant values.

https://help.sap.com/doc/PRODUCTION/01f3c787a6e7499e86e25a556878cbef/4.2.8/en-US/ds_42_adapters_en.pdf

p91 : “The Where clause is of the form operation .”

With this restriction, I cannot use Data Services to load my data from C4C, so I gonna open a ticket to SAP, and I will probably do something else to load my data :hb:

~ Yann ~ :fr: (BOB member since 2007-09-11)

#3

Solved :
Instead of getting the value used for the delta in my Dataflow, I read it outside of the Dataflow, put it in a variable and used that variable in the dataflow.

~ Yann ~ :fr: (BOB member since 2007-09-11)