to be
a problem slover

mongodb bi connector

In order to connect mongoDB to tableau or other BI tools, you need install MongoDB BI Connector.

Official document

https://www.mongodb.com/docs/bi-connector/current/installation/

Prerequisites

https://www.mongodb.com/docs/bi-connector/current/tutorial/install-bi-connector-rhel/

rpm -qa | grep -i openssl

Download

https://www.mongodb.com/try/download/bi-connector

Install

tar -xvzf mongodb-bi-linux-{arch}-{platform}-{version}.tgz
sudo install -m755 bin/mongo* /usr/bin/

Config

systemLog:
  logAppend: true
  path: "/data/mongosqld/logs/mongosqld.log"
  verbosity: 2
mongodb:
  net:
    uri: "<mongodb_host>:<mongodb_port>"
net:
  bindIp: 0.0.0.0
  port: 3307

Start

mongosqld --config /data/mongosqld/mongosqld.conf

Add to systemd (optional)

sudo sh -c 'cat > /usr/lib/systemd/system/mongosqld.service <<EOF
[Unit]
Description=mongosqld service
[Service]
Type=simple
User=ec2-user
WorkingDirectory=/home/ec2-user
ExecStart=/usr/bin/mongosqld /data/mongosqld/mongosqld.conf
Restart=always
RestartSec=1
[Install]
WantedBy=multi-user.target
EOF'
sudo systemctl enable mongosqld
sudo systemctl start mongosqld

Connect

After mongosqld been installed, you can connect it by mysql client, tableau, etc.

You can query mongoDB by sql.

bindIp: 0.0.0.0
port: 3307
赞(10) 打赏
欢迎转载,注明出处:刘世明的博客 » mongodb bi connector

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下作者

支付宝扫一扫打赏

微信扫一扫打赏