Stack Overflow
Stack Overflow

Questions tagged [mongodb-biconnector]

16 questions
5
votes
1 answer

Im trying to connect a BI Connector Instance on Docker to my DB in Mongo Atlas

I'm trying different ways to connect to Mongo Atlas but it haven't been possible. I may be forgetting something but the documentation is no very detailed. Maybe I need to pay to have that feature? Currently this is my mongosqld.conf…
DLCry
  • 51
  • 1
3
votes
0 answers

Cubejs : Error: 19488:error:1408F10B:SSL routines:ssl3_get_record:wrong version number:c:\ws\deps\openssl\openssl\ssl\record\ssl3_record.c:332:

I am trying to connect Cubejs to MongoDB through MongoDB BI Connect. My mongosqld command is as follows ./mongosqld --config mongosqld.conf -u useradmin -p xxxx --auth --sslMode requireSSL --sslPEMKeyFile mongo.pem I have created mongo.pem file by…
user3863585
  • 53
  • 1
  • 1
  • 4
2
votes
0 answers

How to connect a mongodb bi connector through python?

How to connect a mongodb bi connector through python? Is pymongo can do it? If yes can please provide some example with the authMechanism PLAIN(LDAP)? I had try to connect with the pymongo but seems like it does not work for mongodb bi connector as…
wei jian ng
  • 33
  • 4
2
votes
0 answers

Library not loaded: /usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib (LoadError) whem trying to run mongosqld in Mac M1

The error is showing whenever I try to launch mongosqld. I know the Question is repetitive. But what I've tried I'm showing. Error showing in terminal is this: Library not loaded: /usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib Referenced from:…
Mihir
  • 145
  • 11
2
votes
0 answers

Mongo DB BI Connector locally with remote db

I'm trying to create an ODBC connection with a remote mongoDB in order to connect MS Power BI with this mongo via ODBC. By reading the mongoDB Connector documentation here…
Leo Franco
  • 31
  • 2
1
vote
1 answer

Can pymongo use to connect mongodb bi connector in python?

Can pymongo use to connect mongodb bi connector in python? I had tried to connect a mongodb bi connector as the code below: from pymongo import MongoClient # Replace 'localhost' with the hostname or IP address of your BI Connector server host =…
wei jian ng
  • 33
  • 4
1
vote
0 answers

unable to make connection using mongosqld to remote mongodb via mongodb BI connctor

I have a remote mongodb server running, I dont have control over it. I have given read credential for it to use it in tableau for reporting. C:\Program Files\MongoDB\Connector for BI\2.14\bin>mongosqld --mongo-uri "mongodb://
Deepak nigam
  • 99
  • 1
  • 15
1
vote
0 answers

Mongosqld runs fine, but ODBC fails on test and PowerBI throws error 10060. Connector not working. Windows to two seperate RHEL Servers

The Goal I need to get data from a MongoDB updated every 15 minutes to use to build into a PowerBI report. The Gear I am connected from my windows machine via ssh to an RHEL server (server a). This server is running powerbi connector (SQLD) which is…
codeaboard
  • 63
  • 7
1
vote
2 answers

MongoDB Bi connector not able to update max_num_global_tables system variable

I have a MongoDB installed in the ec2 machine, which has around 50 databases. I have set up a Bi connector in order to connect to the tableau. But it is only mapping up to 4000 tables, and because of that it's not mapping all the dbs. Here's the…
Jerin A Mathews
  • 8,572
  • 4
  • 26
  • 49
0
votes
1 answer

[MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.5]parse sql 'UPDATE

I am trying to use MongoDB ODBC driver to update an asset into the database. Currently, I am using Power Automate and here is my code that is not working (select statment is working fine): Connect String: Provider=MSDASQL;Persist Security…
Florin Hristache
  • 1
0
votes
0 answers

MongoDB ODBC configuration for MongoDB BI Connector

I’m trying to setup MongoDB BI Connector to use it for Tableau. I have already running mongosqld and it is connecting successfully from windows cmd to aws documentdb, but when I try to setup MongoDB ODBC Data Source it shows Connection failed…
user17051040
0
votes
1 answer

After create MongoDB view, ODBC can't display this view

For example, I have a MongoDB with 3 collections and 1 view. Collections: products, catalogs, projects Views: view_project_product_catalog After I create a new view in DB and reconnect BI connector, I still can't see the new view in ODBC…
Charles Wu
  • 904
  • 1
  • 9
  • 19
0
votes
2 answers

MongoSQLd not starting on Windows

I'm very new user of Mongo and I'm trying to enable MongoDB connector for BI. I want to change my connect address, but it only connects to 127.0.0.1... I made a config file (net: bindIp: '192.168..' port: 27**8) I follow steps describe into…
Barsian
  • 1
  • 3
0
votes
1 answer

how to connect to multiple mongo instances from a single mongosqld at the same time

I have 2 mongo server say MONGO_A and MONGO_B (both in different servers) and in one server, I have a mongosqld.conf file with which I am able to access one MongoDB (say MONGO_A) in Tableau at a time. I wanted to know if it is possible for the…
Nithin
  • 1
  • 4
0
votes
2 answers

Time Zone in Kubernetes Pods Using Environment Variable

I am trying to update my pod time to Asia/Kolkata zone as per kubernetes timezone in POD with command and argument. However, the time still remains the same UTC time. Only the time zone is getting updated from UTC to Asia. I was able to fix it using…
Aniesh
  • 31
  • 1
  • 3
1
2