Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at

Status Future consideration
Workspace Optim
Created by Guest
Created on Sep 6, 2023

enable to fabricate data for tables with circular dependency.

Currently IBM Optim TDF tool doesn't support tables with circular dependency. it doesn't even accept the tables with circular dependency to add into TDF project.   

We would like IBM to enable TDF to generate data for tables with circular dependency. 

Needed By Quarter
  • Guest
    Sep 6, 2023

    This is a reasonable requirement and Optim Product Management agrees it is desirable.

    Some considerations:

    • The alternative and sometimes only solution is to defer referential integrity (RI) relationship checking.

    • There is a workaround, to disable one relationship in the cycle, in the test environment, while fabricating with TDF. Oracle has an RI ENABLE and also a DISABLE command. This is one form of deferring RI relationship checking. The client in this case has rejected this option for internal reasons.

    • There are some cycles that cannot be supported at all via SQL DML, for certain databases. Some DBMSes cannot defer RI checking until COMMIT, but enforce RI immediately upon insert. For those DBMSes, take the case where there are 2 tables where each row in table A has 1 and only 1 RI related row in table B, and each row is both parent and child to the other. In this case there is no way that SQL DML (Insert or Update) can be used to insert the cyclical data, whether we change TDF or not. The only way to make this work is to again defer RI checking. You can use a load utility. Load utilities defer the check until after loading.

    Bottom line, there are cases where TDF (or any tool or user) cannot create cycles without deferring checking. So we view this as an acceptable temporary restriction and will evaluate when to work on lifting it in future.