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.properties

    2.(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,root

    Explanation 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 database

    Example you can try adding:

    external.db.3=jdbc,mssql,databasename,false,driver class name ,url
    You will require to updatedatabasename,driver class name,url

    Example 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