I have a Postgresql running on my localhost and I try to install but I can not disable the option to install with example data (mySQL only). And I do not have an option to install without.
How to do that?
To configure new dataset you just need to add entry in settings.properties file, also example database classicmodel currently works in MySql only also example database classicmodels which comes out of box with OPNBI server is currently written in MySql only
Adding new database connection to Active Intelligence Server
1.To add a new database connection, open settings.properties file from the following location:
..\apache-tomcat\webapps\Opnbi\WEB-INF\classes\settings.properties2.(find external.db.2) Add the following line below and make necessary changes as required:
Example Syntax:
external.db.3=jdbc,mysql,classicmodels,false,com.mysql.jdbc.Driver,jdbc:mysql://localhost:3306/classicmodels,root,rootExplanation for Above Syntax:
Field Name:Explanation
external.db.3It is the serial number for database connection needs to be updated each time
jdbcThe protocol for the connection
mysqlThe subprotocol which specify type of database
classicmodelsDatabase name
falsewhether to use connection properties or jndiurl
com.mysql.jdbc.DriverDriver class name
urlUrl to connect to datasource
usernameUsername of the database
passwordPassword of the databaseExample you can try adding:
external.db.3=jdbc,mssql,databasename,false,driver class name ,url
You will require to updatedatabasename,driver class name,urlExample for mssql you can try adding:
external.db.3=jdbc,mssql,AdventureWorks,false,com.microsoft.sqlserver.jdbc.SQLServerDriver,jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=AdventureWorks2014;integratedSecurity=true
3.Then you must add jdbc driverfile in following location
.\apache-tomcat\webapps\opnbi\WEB-INF\lib