etl process with bxbwebsuite

BXBwebsuite

E T L(Extracting, Transforming & Loading)

process

After logged in, the user has to choose the Database option from the module menu, available at the upper left corner of the screen.

This option is available only for Professional edition users.

BXBwebsuite ETL process

First of all, a datasource connection has to be defined.

Depending on the “Type” (MySQL, Oracle, SQLserver, TXT or ODBC), different properties must be informed

BXBwebsuite ETL process

BXBwebsuite ETL process

A SQLserver connection example

BXBwebsuite ETL process

A MS-Access connection example

Once the datasource is saved, desired cubes can be configurated.

Cube name is required and optionally some user permissions can be set up for this cube.

BXBwebsuite ETL process

The next step is to write the SQL script defining which fiels has to be transferred from the datasource to the cube.

Note: The SQL syntax depends on the

datasource technology

BXBwebsuite ETL process

BXBwebsuite ETL process

The Metadata tab offers the possibility to turn some numeric fields (columns) in dimension, define a friendly label for it ...

BXBwebsuite ETL process

... and decompose date fields inyear, quarter, month, week etc.

BXBwebsuite ETL process

An automatically generated measure(line counter) can also be added.

A toolbar is also availabe to:- Save the cube configurations- Undo the last operation- Load data on the cube- Preview the data from the datasource- Create calculated columns (through formulas

using the columns generated by the SQL script) - Delete the cube

BXBwebsuite ETL process

The data can also be loaded on the cube through an automated process.

BXBwebsuite ETL process

BXBwebsuite ETL process

This screen allowsto configure theload frequencyfor each cube.

More details you can find in the Developer’s guide, by clicking on the Help button (?), on the upper right corner of the screen.

BXBwebsuite ETL process

Thanks for your attention !