BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

[SOLVED] odata and DateTimeOffset (Delta load)


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
~ Yann ~
Senior Member
Senior Member



Joined: 11 Sep 2007

Posts: 54
Location: Strasbourg


flag
PostPosted: Wed Oct 09, 2019 11:45 am 
Post subject: [SOLVED] odata and DateTimeOffset (Delta load)

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 ?


Last edited by ~ Yann ~ on Fri Oct 11, 2019 3:58 am, edited 1 time in total
Back to top
~ Yann ~
Senior Member
Senior Member



Joined: 11 Sep 2007

Posts: 54
Location: Strasbourg


flag
PostPosted: Thu Oct 10, 2019 3:41 am 
Post subject: Re: odata and DateTimeOffset (Delta load)

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 <column> operation <constant>."

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 banghead.gif
Back to top
~ Yann ~
Senior Member
Senior Member



Joined: 11 Sep 2007

Posts: 54
Location: Strasbourg


flag
PostPosted: Fri Oct 11, 2019 3:57 am 
Post subject: Re: odata and DateTimeOffset (Delta load)

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.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0299 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0262)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo