Business Intelligence Service configuration
Business Intelligence supports two types of Data Sources:
- Database
- File (Excel, CSV)
Depends on which one you want to use, go to a right section of this tutorial. A configuration of Business Intelligence Service you can find in Data Sources tab of the Control Panel.
In order to create a database data source, you must prepare a database connection. Open tab Database connections. You will be able to see a list of existing connections:
In order to add a new one, click New Database Connection button. You have to see a creation form. Business Intelligence Service supports connection to following databases:
- H2 - embedded in the application
- Oracle
- PostgresSQL
- MySQL
- MSSQL
We are going to integrate with more databases, as well as NoSQL databases.
Having created a database connection, you can begin to create a database data source. Go to Database Data Sources tab. You will see a list of existing data sources:
In order to create a new one, click New Database Data Source button. You have to see a new form of data source creation:
There are some fields, you have to fill out:
