Integration
Hide about this portal
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
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
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.
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.
Correction the duplicate RFE is 63746
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.
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
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.