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
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. Further to the detailed last comment from development made on this RFE in October 2020, this suggestion has not received further voting or commentary, and given the business justification provided via private commment is now long-since outdated on this occasion we do not intend to take this idea further forward.
RFE Review. Apologies for the length of time this RFE has been in the status of Under Consideration. IIB/ACE provides three main approaches for the support of database connections:
a) Bring your own JDBC Driver
b) Bring your own ODBC Driver
c) ODBC Drivers which IIB/ACE includes with its product installation
Approaches (a) and (b) provide a level of support for Sybase IQ, subject to the following restrictions ...
(a) For JDBC database connections we support any JDBC Type 4 driver subject to the following requirements:
- The driver must be a JDBC Type 4 (Pure Java) driver
- Discoverability in the Graphical Data Mapper is not supported
- Automatic determination of field types in Graphical Data Maps is only supported if the driver correctly and fully implements java.sql.PreparedStatement.getParameterMetaData() ) see https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/br40814_.htm for more details.
- Global transaction coordination (XA) is not supported.
(b) For ODBC connection we also offer limited support for drivers that are no supplied as part of the product install image. The statement of support is as follows:
IBM App Connect Enterprise provides support for the ODBC 3.5 API on Windows and Unix platforms. Users may supply compatible drivers for database platforms not covered by the set of databases supported by the included database drivers. In these cases IBM will provide support for this configuration subject to the following limitations:
IBM App Connect Enterprise will undertake to make defect fixes that are a result of an incorrect usage of the ODBC API by IBM App Connect Enterprise.
IBM App Connect Enterprise will only undertake to work around issues related to faulty third party drivers on a best-effort basis.
XA is not supported.
The driver must support the SQLDescribeParam call.
To call Stored Procedures the driver must fully support the SQLProcedures and SQLProcedureColumns API.
On Microsoft Windows platforms the Microsoft Driver Manager must be used to register the DSN for any driver which you wish to use.
On Unix platforms the driver must be supported by version 2.2.14 of the unixODBC driver manager. See http://www.unixodbc.org/drivers.html for a list of drivers which are known to be compatible.
Where a defect is suspected in driver code owned by another IBM product team, ACE L3 service will engage with the relevant product team provided that the user is also entitled to support for that driver.
Where a defect is suspected in driver code provided by a third party, ACE L3 service will share problem analysis information with third party vendors however third party support must be engaged by the user under a valid support contract.
This information is all available in the IBM App Connect Enterprise and IBM Integration Bus System Compatibility Reports:
https://www.ibm.com/support/pages/system-requirements-ibm-app-connect-enterprise-110
https://www.ibm.com/support/pages/system-requirements-ibm-integration-bus-100
Regarding approach (c) ODBC Drivers which IIB/ACE includes with its product installation ... we are open to adding a built-in driver in future for ODBC, and we are pleased to see that there is Progress/DataDirect driver potentially available (https://www.progress.com/odbc/sybase-iq). We will continue to monitor this RFE for its popularity when deciding if in future we go in this direction of type (c) support. Status of the RFE is updated to Uncommitted Candidate (in consideration of future support of c).