IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
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. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

new DBlink for cplex OPL optimization studio

Dear developers. I thought that this idea either was already posted or perhaps is considered inside other idea related with ODX, but anyway I do want to ensure that next enhancement to cplex optimization studio get done: until opl 12.6.3. the fetching of data for the model from database engines like SQL was using  DBlink, which could be imperfect but it did work, but the deprecation of it has been a terrible fact for those teams that we cannot spend time migrating the connection/fetching of data to the DB using python/java/etc. Our request is the implementation of a new interface like dblink that should allow to the modeler a quick connection to the DBs like SQL, oracle, etc. without many lines of codes in python when a large-scale model is required. Remind that a large problem is connected to many and big tables, and python is nice, but for responsiveness to stakeholders when you need changes quickly, python data management, is not the most efficient for large scale problems. if you create that new dblink, it is a powerful enhancement that you also can move to ODX. Remind that data science is not just a lot of code in python, it is also the capability to deliver answers to the Company fast and efficiently with easy tools, also explain easily the results of cplex and create confidence in the stakeholders with an intelligible code as we had with DBlink when fetching data. Thanks in advance

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 14 2018
  • Planned for future release
Idea Priority High
Customer Name Raincarbon, Hydroquebec and EDF
  • Attach files
  • Admin
    PRIYANKA JAIN commented
    14 Aug 03:39pm

    Planned for COS 20.1.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    30 Jul 09:20am

    While currently there is no direct replacement for the old DBLink functionality, there are some solutions based on Java. These are available in public github.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Dec, 2018 05:59pm

    I totally agree with your demand.  This kind of changes affect us negatively.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Dec, 2018 05:59pm

    Definitely a DB link should be available, we have developed several models over the past few years for which now we are not able to connect OPL 12.6.8.  IBM, this kind of changes in technology should not affect negatively customers, I am 100% agree to develop new methods of integration but customers should migrate to them in their own pace.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    14 Dec, 2018 05:59pm

    Yes, please.  My data is in a SQL database and I can't possibly rewrite the import in Python.  I can't use 12.8 improvements without a database link.

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