| Info |
|---|
Note: This tutorial has been made with SQL databases. Please adapt your actions if you use a different database type. |
...
1/ Launch SQL Server Management Studio. | |||
| 2/ Click on "New query". |
| ||
3/ Copy and past the script "01 Datawarehouse main database creation" in SQL Server Management Studio and replace DATAWAREHOUSE_NAME (don't replace the punctuation marks) by the desired name for your datawarehouse database.
|
| ||
| 4/ Click on "Execute". You should have a confirmation message "Command(s) completed successfully". |
|
...
| 1/ Always in SQL Server Management Studio, click again on "New query" to open a new request tab. | |||
2/ Copy and paste the script "02 SpagoBI cache database creation" in SQL Server Management Studio and replace SPAGOBI_DATABASE_NAME (don't replace the punctuation marks) by the desired name for your datawarehouse database.
|  | ||
| 3/ Click on "Execute". You should have a confirmation message "Command(s) completed successfully". |
|
...
Create Datasources and add MIA streams to populate the Datawarehouse database
Prerequisites:
- User MIA exist MIA to read/write on the Axiodis database.
- Datasource called Axiodis exist to access to the Axiodis database.
1/ Go to Admnistration → Axiodis interfacing → Module MIA → Datasources. | |||
| 2/ Click on the "Add" button to create a new Datasource. | |||
3/ Set a datasource called AxiodisDB with the settings below. This datasource will connect to the Axiodis database. URL: Set with your Axiodis database access URL and port. Ex: GCSQL01:1533 Type: Choose your database type. SQL Server in our example. Password: Set with the password to access to the Axiodis database. Timezone: Set the timezone of your country. Schema: Set with "dbo". DatabaseName: Set with your Axiodis database name. Ex: REC_V6_STABLE_IC1 Username: Set with the username to access to the Axiodis database. Ex: REC_V6_STABLE_IC1 |
| ||
4/ Set a datasource called Infocentre with the settings below. This datasource will connect to the datawarehouse database. Populate with the settings used above to create datawarehouse database. URL: Set with your Axiodis database access URL and port. Ex: GCSQL01:1533 Type: Choose your database type. SQL Server in our example. Password: Set with the password to access to the Axiodis database. Timezone: Set the timezone of your country. Schema: Set with "dbo". DatabaseName: Set with your Axiodis database name. Ex: REC_V6_STABLE_IC1 Username: Set with the username to access to the Axiodis database. Ex: REC_V6_STABLE_IC1 |  | ||
5/ Add the AxiodisBI streams in the MIA streams directory: C:\Program Files\Optilogistic\Axiodis6\...\data\mia\flux
| |||
6/ In Axiodis, check settings and change them in needed. Initial settings: IC-STD-01.xml → Launch once per day at 12:30 am. IC-STD-02.xml → Launch once per day at 12:15 am. IC-STD-03.xml → Launch every 2 hours.
|
|
...