Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Loading date Information from Oracle to BI 7.0 via UDConnect.

Hi all,

Can you please help me in understaning an issue that I am facing.

1) We have a table in Oracle in which we have a field called 'Reading Date'.

This field is of type DATE(7). But, it contains value in the format : '12/31/2006 7:01:00 PM'.

Now, is there any way by which we can load this information into BI 7.0?

I tried to load this using an infoObject of type DATS(8).

But, then time information does not get loaded.

Then, I tried an infoObject of type CHAR(20).

But, that also yields the same result.

2) Is it possible to do a delta load using UDConnect even if we do not have a time-based or date-based field in the table of the source system?

Can you please suggest?

Not what you were looking for? View more on this topic or Ask a question