Requirements
- A private flex.bi installation that is supported on Mac OS X, Linux and Windows.
- Java SE 7 or Java SE 8 should be installed.
- MySQL (version 5.x), PostgreSQL (version 9.x), MS SQL (version 2008 or later) and Oracle (version 11g or later) are supported as a private flex.bi database.
Installation
Ask flex.bi support to provide a download URL for the latest private flex.bi full distribution .zip file.
Unzip the downloaded full distribution .zip file in directory of your choice. It will create a flexbi_private subdirectory where all private flex.bi files will be located.
| Note |
|---|
On Windows there exists a length limit for the file path - 260 characters. Flex.bi has a deep nested directory structure. System full file paths may exceed this limitation if the flexbi_private directory is located deeply in a directory hierarchy. We recommended to create flexbi_private folder directly in the root folder for Windows installations. |
Directory structure
The flexbi_private directory contains the following subdirectories and files:
...
| Panel |
|---|
PostgreSQLYou need to create a separate user flexbi_private with database creation rights for flex.bi: | Code Block |
|---|
CREATE ROLE flexbi_private PASSWORD 'secret' LOGIN CREATEDB; |
If you do not want to add the CREATEDB role to the flexbi_private user then manually create the flexbi_private database with flexbi_private user as the owner. Each new flex.bi account will store data in a new flexbi_jira_dwh_N schema (where N is account ID number) in the same database. Please tune PostgreSQL memory parameters. The following postgresql.conf settings are recommended: | Code Block |
|---|
shared_buffers = 1024MB
wal_buffers = 32MB |
The parameter shared_buffers will specify how much database data PostgreSQL can store in the memory - adjust it to your available server memory (the more data PostgreSQL will store in the memory the less disk input/output operations will be performed). The parameter wal_buffers affects the performance of writing transaction logs to disk.
|
...
| Panel |
|---|
Microsoft SQL ServerCreate a MS SQL Server user flexbi_private – if you use SQL Server Management Studio then select SQL Server authentication and uncheck Enforce password policy. In addition from Server Roles select dbcreator (to allow the creation of new databases) or manually create the flexbi_private database with flexbi_private user as the owner. Each new flex.bi account will store data in a new flexbi_jira_dwh_N schema (where N is account ID number) in the same database. OracleCreate an Oracle database user flexbi_private: | Code Block |
|---|
CREATE USER flexbi_private IDENTIFIED BY secret DEFAULT TABLESPACE users;
GRANT CONNECT, RESOURCE TO flexbi_private; |
In this configuration all flex.bi data will be stored in one flexbi_private schema. |
...
