Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PowerBI MongoDB BI connector - MySQL auth

Hi All! So, as stated in the title: I want to connect PowerBI to my MongoDB using the BI Connector. The BI Connector (installe don the server side) basically provides a way to connect to MongoDB as...
  • Anonymous's avatar
    Anonymous
    8 years ago

    I have found a solution: connecting via ODBC.

    Installing the MySQL ODBC driver and creating an ODBC DSN using the ANSI connector fixes the problem, as the interface lets you specify the auth plugin to be used.

    Tested succesfully: I can retrieve data from MongoDB to PowerBI using the BI connector and mongosql_auth plugin.

laciodrom_80's avatar
laciodrom_80
Helper IV
8 years ago

 

Anonymous

 

Hi,

 

I'm getting some issue connecting by mysql: I've succesfully created schema.drdl and established mongosqld connection on 3307 port: 

OpenSSL version: OpenSSL 1.0.1u  22 Sep 2016
waiting for connections at 127.0.0.1:3307

But when I try to connect by mysql client

mysql 'user=myUser?source=myDb' --default-auth=mongosql_auth -p -h localhost --port 3307

I've got this error: ERROR 1043 (08S01): error performing authentication: unable to saslStart conversation 0: (AuthenticationFailed) Authentication failed.

 

I'm using MySQL community edition, you? Should I use the enterprise one and performing a connection from mysql with authentication and TLS/SSL? (https://docs.mongodb.com/bi-connector/current/connect/mysql/)

 

Thanks in advance!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi.

    I managed to do it with the community edition.

    Are you sure your user is defined on the database "myDb", and not on the "admin" DB?