IBM Analytics Ideas

Welcome to the idea forum for IBM Analytics Clients! 

 

IBM Employees:

The correct URL for entering your ideas is https://hybridcloudunit-internal.ideas.aha.io

 

Clients:

Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

 

If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.  https://ibm.biz/AnalyticsIdeasPortalRegister

 

Build in Support for Teradata Temporal Tables

The current CDC product for a DB2 Linux implementation supports the use of DB2 Temporal Tables.  We can replicate data from VSAM, DB2 zOS, and IMS to DB2 Linux Temporal Tables without any extra effort.  Under a similar use case, we have instances where we would like the VSAM, DB2 zOS, and IMS data to be delivered to a Teradata target that is using temporal tables.  Temporal table support in Teradata would eliminate the need to keep archive tables with triggers on the main tables to track changes over time.  The main table would store the current record and the archive tables would contain the historical records.  This would allow for querying a smaller set of records if just looking for the current record versus querying all of history each time.   Our environment has a lot of IBM mainframe data sources feeding DB LUW, Teradata and SQL Server warehouse/analytics targets. 

 

Ideally this request would extend beyond Teradata as well and be implemented as part of the SQL Server CDC product.  I can sense that may be next for use.  First and foremost would be to extend the capability to Teradata. 

  • Kevin Janes
  • May 23 2018
  • Future Consideration
Role Summary This data applies to CDC Admin and Database Admin roles.
  • Aug 3, 2018

    Admin Response

    IBM Response.

     

    Thank you for submitting this idea. We think the requirement is valid but the work has not been committed.

    To help us prioritize, IBM will monitor to idea for additional user votes and/or comments.

  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions