I didn't see any previous posts on this subject and didn't find anything in the IBI documentation but has anyone tried using SQL Server Temporal Tables with WebFOCUS? I have a project where I need to track some trend data but just snapshotting the source table daily for the time periods in question is going to become expensive in terms of storage resources.

I have viable alternative solutions that will work if need be but it would be neat to use this feature in conjunction with WebFOCUS and I think it would save me effort and resources when it comes to building certain types of reports.

This message has been edited. Last edited by: FP Mod Chuck,

Hi DrE

Welcome to Focal Point. It is a great forum to get answers to your development questions.

I found this tidbit in a internal project to support temporal tables.

Just for the record, regarding Temporal support in SQL Server
2016:
MS has implemented only System-versioned tables and has not
implemented Application-time ones (strange move).
They've implemented extensions FOR SYSTEM TIME AS OF, FROM TO
etc. that ANSI provides for querying System-versioned tables.
I'm not sure how valuable this feature will be for our customer
audience. I imagine that Application-time temporal tables would
be more usable

Not sure if this helps you or not. In the mean tim try to access them and see if it works.