Integration


This is an IBM Automation portal for Integration products. 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 (https://ideas.ibm.com).


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

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.


Add a new idea Subscribe
Status Not under consideration
Workspace App Connect
Created by Guest
Created on Dec 1, 2014

RELATED IDEAS

Full SQL Support in Map Node

SQL statements are supported in the map node but it still does not support the complete SQL standard. E.g. UNION clause, Isolation Level (WITH clause), etc. This makes the map node not very useful in practical scenarios with complex queries.

The Mapping tool is a great way to represent and maintain mapping of different data elements graphically. This makes the code maintainable and easy to change. However, the limitations of the SQL mapping forces customers to shy away from it and go back to coding.

Adding this would really enhance the mapping experience.

Idea priority High
RFE ID 62741
RFE URL
RFE Product IBM App Connect Enterprise (formerly IBM Integration Bus)
  • Admin
    Ben Thompson
    Reply
    |     Nov 26, 2021

    Idea / RFE Review. Apologies for the length of time this RFE has been held in Uncommitted Candidate / Future Consideration status. Unfortunately on this occasion we do not intend to carry this idea further forward. Although this was originally raised against the old mapper codebase in 2014, it is fair to say that even the new mapper has limitations where SQL syntax is concerned. A user can workaround these constraints either through invocation of Java or ESQL from the graphical map, or by executing a stored procedure from the map. Given the low votes, long time period since this was raised, and marginal benefit unfortunately this is unlikely to be prioritized any time soon. Status of the idea is closed.

  • Guest
    Reply
    |     Mar 2, 2017

    Correction the duplicate RFE is 63746

  • Guest
    Reply
    |     Mar 2, 2017

    As noted in the duplicate RFE 41891 since IIB v9 there is support for invoking a Stored Procedure from a Graphical Data map. This approach allows the complex queries to be maintained in the database system and the Graphical data Map to simply invoke the provided procedure.

  • Guest
    Reply
    |     Oct 7, 2015

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - WebSphere
    Product family - Integration
    Product - IBM Integration Bus (WebSphere Message Broker) - IIB

    For recording keeping, the previous attributes were:
    Brand - WebSphere
    Product family - Connectivity and Integration
    Product - IBM Integration Bus (WebSphere Message Broker) - IIB

  • Guest
    Reply
    |     Jan 16, 2015

    Thank you for raising this RFE. The Graphical Data Mapper remains an important part of our strategic vision for IIB, and we agree that extending the range of SQL support it provides when interacting with databases would be a positive step forward, whilst noting that any enhancements we make would need to be applicable for all database versions supported by the maps (or at very least would need to be obvious to the user which SQL features are supported by which databases). Status of this RFE is updated to Uncommitted Candidate.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.