Knowage BI - SQL Server DataSource

Question

我有一个关于知识的问题(开源BI软件 - www.knowage-suite.com(。

谁能告诉我如何使用SQL Server连接创建数据源？

问候 托马斯

Answer 1

0> put MSSQL JDBC driver into `./<your_knowage_installation_directory>/lib` folder
1> log in (on web-UI) as administrator  
2> data source  
3> click on red '+' sign  
4> give a label and choose your dialect (SQL-Server)
5> fill your credential (need SQLSErver auth, not active directory)
6> insert into JDBC this: `jdbc:sqlserver://<YOUR_SERVER_IP>`  
7> insert `com.microsoft.sqlserver.jdbc.SQLServerDriver` as driver
8> create your dataset as a query (remember `use <your_db_name>` at the beginning of your query)

链接到 MSSQL JDBC 驱动程序

Answer 2

下面给出了安装Knowage和设置数据库的步骤。

安装 MySQL1。 sudo apt-get install mysql-server

阿拉伯数字。 修改/etc/mysql/mysql.conf.d/mysqld.cnf 并更改 从

bind-address            = 127.0.0.1 
to
bind-address            = *

3. MySQL -u 根 -p

ALTER USER 'root'@'%' IDENTIFIED BY ''mypswd ';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY ''mypswd';
FLUSH PRIVILEGES;
service mysql restart

安装爪哇

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer
sudo apt-get install oracle-java8-set-default 
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export PATH=$JAVA_HOME/bin:$PATH

安装知识1。下载知识

wget http://download.forge.ow2.org/knowage/Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip
unzip Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip

2. 创建交换内存 (https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04(

sudo swapon --show
free -h
df -h
sudo fallocate -l 4G /swapfile
ls -lh /swapfile
sudo chmod 600 /swapfile
ls -lh /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile
sudo swapon --show
free -h  

3. 设置 Knowage

   sh Knowage-6_2_0-RC-CE-Installer-Unix-20180509.sh -c 
   
   Used existing MySQL DB and it created knowage_ce with following tables.
   

4. 在 conf/服务器中添加数据库源.xml

   <Resource name="jdbc/knowage" auth="Container"
   type="javax.sql.DataSource" 
   driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost:3306/knowage_ce"
   username="root"
   password="mypswd" 
   maxActive="20" maxIdle="10"
   maxWait="-1"/>
   

5. 下载 MySQL 连接器并复制到 lib dir

   cp mysql-connector-java-5.1.46.jar /home/babbarkrishan/knowage/Knowage-Server-CE/lib/
   

6. 在/bin 中启动知识服务器

   sh startup.sh
   

希望它能解决您的问题。

问候

克里山