...
Please at first read about flex.bi cubes, dimensions and measures - you will need to understand the multi-dimensional data model to be able to map source file columns to cube dimensions and measures.
On this page:
| Table of Contents |
|---|
Create new source application
...
In Database type, select database server type (MySQL, PostgreSQL, MS SQL, and Oracle are supported).
In flex.bi Enterprisebi Enterprise, you can also select Generic JDBC database type and specify the JDBC driver class name and JDBC URL. Please copy the corresponding JDBC driver jar file to flexbi_private/lib directory and restart flexrestart flex.bi Enterprise bi Enterprise after that.
Specify database server Host and optional Port parameter (depending on the selected database type, some other optional parameters might be available). Specify the Database name and database Username and Password that should be used. For Oracle database in the Database name field, provide database SID or Service Name.
...
If an incremental import is used, then it will be required to specify a Source ID column in the source columns mapping step. Source ID column value should provide a unique results row identifier. It is used to identify when some existing imported rows in flexin flex.bi should be replaced with updated source data during the incremental import.
...