Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Vikram Kaledhonkar
    Reminder: ODBC Export removal on November 1, 2015
    Topic posted June 8, 2015 by Vikram KaledhonkarBlue Ribbon: 750+ Points, last edited June 11, 2015 
    7705 Views, 4 Comments
    Title:
    Reminder: ODBC Export removal on November 1, 2015
    Content:

    Oracle Service Cloud team would like to remind everyone that the ODBC Export functionality has been deprecated since December 2011 (https://cx.rightnow.com/app/answers/detail/a_id/4522/kw/ODBC) and is scheduled to be removed on November 1, 2015.

    If your organization is currently using ODBC Export feature to access Oracle Service Cloud, we want to encourage you to make plans immediately to migrate to replacement ODBC functionality before the November 1, 2015 disablement date.

    There are couple of recommended approaches in order to migrate away from ODBC export feature.

    1)            You can build a data extract integration using Connect APIs that are provided as part of Oracle Service Cloud. Connect APIs, in addition to being more secure, offer backwards compatibility that ODBC export feature does not.

    2)            Customer who wish to take advantage of standard SQL skills can use 3rd party (Progress DataDirect) ODBC/JDBC drivers that allow standard SQL queries to be run against Oracle Service Cloud database. Since this is built on Connect APIs, it conforms to full application security and provides backwards compatibility against database schema changes between releases. Here are more details on Progress driver:

    https://www.progress.com/products/data-sources/oracle-service-cloud-odbc-jdbc

    https://www.progress.com/products/datadirect-cloud/subscriptions

    If you have any questions, we would be happy to discuss with you.

    - Vikram Kaledhonkar

    Comment

     

    • Steve Spence

      Hi, i'd like to know more about this statement in the email sent to me:  "Our Product and Operations Team has noted that your organization continues to access Oracle Service Cloud through the deprecated ODBC Export."  I had thought we'd discontinued use of this so i'd like to know more about what access you are seeing.

      thanks,

      Steve

    • Vikram Kaledhonkar

      Hi Steve,

      Our monitoring tools noticed that your site is still using ODBC access. Perhaps we can work offline to find out what is happening with your site.

      Thanks,

      Vikram

       

    • Dionne Gayle

      Hi, Like Steve above  i'd like to know more about this statement in the email sent to me:  "Our Product and Operations Team has noted that your organization continues to access Oracle Service Cloud through the deprecated ODBC Export."  I had thought we'd discontinued use of this so i'd like to know more about what access you are seeing.

      IF your monitoring tools noticed that our site is still using ODBC access. Perhaps you  can work offline with us  to find out what is happening with our site.

       

      thanks,

      Dionne

    • Chris Warner

      Just a reminder to all ODBC Export users: the November 1 shutdown is just a few weeks away.  If you have any questions or concerns we can address, please reach out to us here or through Technical Support as soon as possible!