Knowage 6.2 Config Datasource (JDBC)

Oracle 11g

Stop Knowage and Download Oracle JDBC Driver
Copy file ojdbc6.jar to library directory and Start Knowage

Dialect: Oracle
Read Only: Read Only
Type: JDBC

URL: jdbc:oracle:thin:@//host:port/servicename
Username: username
Password: password

Driver: oracle.jdbc.driver.OracleDriver

---

PostgreSQL 11

!! Please set your PostgreSQL 11 allow remote connection
Stop Knowage and Download PostgreSQL JDBC Driver
Copy file postgresql-42.2.5.jar to library directory and Start Knowage

Dialect: PostgreSQL
Read Only: Read Only
Type: JDBC

URL: jdbc:postgresql://host:port/databasename
Username: username
Password: password

Driver: org.postgresql.Driver

---

MySQL 5.7.25

!! Please set your MySQL 5.7.25 allow remote connection
Stop Knowage and Download MySQL JDBC Driver (Connector J)
Copy file mysql-connector-java-8.0.15.jar to library directory and Start Knowage
* By default MySQL JDBC Driver is already have in library directory please check !

Dialect: MySQL/MariaDB
Read Only: Read Only
Type: JDBC

URL: jdbc:mysql://host:port/databasename
Username: username
Password: password

Driver: com.mysql.jdbc.Driver