Skip to Content
author's profile photo Former Member
Former Member

MYSQL ODBC Connection can't find DB catalog and tables in IDT.

Hi everybody,

I have created a relational connection to a MYSQL 5 database through MYSQL ODBC driver. Connection test is succesfull. There are more than 1 databases in the MYSQL server. However, I realized that if don't choose any database as the default one while creating DSN, I cant see any DB catalog in IDT. If I choose one, I can see the tables only for the regarding database.

Moreover i can still write SQL commands on derived tables in data foundation and get the result regardless of the databases and its tables. But I cant directly use the DB tables as you suppose. I have connected to many MSSQL DB servers before and never experienced such a case. To me, it looks like a bug but maybe it is possible to get this over maybe with a parametric update. BO version is 4.0 SP6 Patch 3.

Has anybody faced such an issue and found any solution?

Thanks for all,

Ceyhun

mysqlODBC.JPG (55.6 kB)
connection.JPG (14.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 09, 2014 at 02:06 PM

    Hi Ceyhun,

    I try this on our test systems. I encounter same situation.

    BO: SAP BO 4.1 SP3

    MYSQL&DRIVER : MYSQL 5.3.X

    This may not be a bug. it may be related MYSQL Driver behavior.

    So, you can try this workaround,

    1. Create a connection for each DB

    2. Create a Multi Source Data foundation.

    3. Use all of required connection in this Data Foundation.

    Best Regards.

    Sinan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sinan,

      Thanks for your interest and suggestions.

      Because of there are 15 different databases in the server and it will be more, it'd be kinda difficult to manage and handle the work load of using Multi Source Data foundation for this case. So, It looks like we will stay by writing sql sentences on derived tables.

      It sounds a bit interesting to me. You can connect to the DB, get the data set by SQL sentences but the tables dont show up under the connection. Maybe, ODBC driver has to be upgraded in coordination of SAP and ORACLE. I will create an OSS message for this and share the outcome here.

      Thanks again,

      Hope to see you soon 😊

      Regards,

      Ceyhun

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.