Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

MySql database connection with Oracle DVD

Received Response
121
Views
10
Comments
A-92500
A-92500 Rank 3 - Community Apprentice
in Oracle Analytics Forum

Summary

MySql database connection with Oracle DVD

Content

I use MySql Community Edition ...It fails to save the connection when tried to connect to Oracle DVD ..Is there any other way to connect to Oracle DVD and fetch the tables? Or is it web services can be accessed via Oracle DVD? Do give some ideas

Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics & AI Coach

    ​ Philippe's tweet kind of spoiler'ed that already. Does that mean we should have it after KScope?

  • A-92500
    A-92500 Rank 3 - Community Apprentice

    I searched for the answer and then posted this question ...it needs MySql Enterprise Edition currently...and so just wanted to know was there any update on this or else any alternate solution for this....Thanks for the Info Sir

  • Gianni Ceresa
    Gianni Ceresa Mod

    As Adam said: search for it and you get the answer.

    As apparently you didn't ... in the meantime of generic ODBC/JDBC support you can A) export to Excel from MySQL and load your excel or B) move your data to another supported database.

  • A-92500
    A-92500 Rank 3 - Community Apprentice

    Okay thankyou ... until then is there any alternate solution to access the database?

  • Adam Bloom-Oracle
    Adam Bloom-Oracle Mod

    This question has been asked before - if you search the forum you will find the answer.

    Currently the driver does not support Community edition.  You'll have to wait until we support generic ODBC/JDBC then use your own driver.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics & AI Coach 
    Varuna_A wrote:but its like querying the tables and adding as a data source for the projects

    As opposed to what?

  • A-92500
    A-92500 Rank 3 - Community Apprentice

    Now it works out !! Thank You!

  • A-92500
    A-92500 Rank 3 - Community Apprentice

    Hi, This new version Of Oracle DVD supports the MYSQL database in JDBC(Beta) but its like querying the tables and adding as a data source for the projects.

    Also can we connect MySql Database to Oracle DVCS ?

  • Kranthikumar Kommuri
    Kranthikumar Kommuri Rank 3 - Community Apprentice

    Hi,

    Generic ODBC/JDBC driver support has been added in the new version of DVD. You can now connect to sql server.

  • Hemant Agarwal2412
    Hemant Agarwal2412 Rank 1 - Community Starter

    Hi, I am new to ODV and I am able to connect my db via ODBC. But while fetching the data its showing special characters.

    I have used MySQL and via Table Data import wizard I have imported the data.

    Encoding tried - utf-8/utf16/cp 1250.

    Please can some help me to fix this.

    Regards