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

?

1 2 3 4 5 6 7 8 9

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

?

1 2 3 4 5 6 7 8 9

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 !

?

1 2 3 4 5 6 7 8 9

Dialect: MySQL/MariaDB Read Only: Read Only Type: JDBC   URL: jdbc:mysql://host:port/databasename Username: username Password: password   Driver: com.mysql.jdbc.Driver