You are here

SkyVault Analytics 1.1 » Installing and configuring SkyVault Analytics » Installing SkyVault Analytics

Step 6. Creating the Data Integration (DI) database

Use this information to create your Data Integration (DI) database for SkyVault Analytics. A separate database is required for the data warehouse that is used to store data processed by the ETL jobs.
You must have a basic configuration of either PostgreSQL, as specified in Installing PostgreSQL or MySQL Server, as specified in the initial Analytics installation.
  1. Create a database as required by the DI server using the script provided:
    1. For PostgreSQL: 

      psql -U postgres < data-integration/db-scripts/postgresql/create_di.sql
    2. For MySQL: 

      mysql -u root -p < data-integration/db-scripts/mysql5/create_di.sql

    This script sets up a database called pentaho_di and grants permissions to a user pentaho_di with the password pentaho_di.

    For security reasons, we recommend that you change these details in a production environment.

  2. Navigate to ba-server/tomcat/conf/context.xml and check that the credentials match those that you have specified for the database you have just created.

    Edit the username and password attributes in the jdbc/alfrescoDataSource Resource element to match the changes that you made in the create_di.sql file.

  3. Start the Analytics server. From the ba-server directory of the Analytics installation directory, run the following command: 

    ./start-pentaho.sh
    and check that the command line output has no errors.
  4. As the new administrator user that you created in the BA server setup, check that the installation has been successful by entering this URL: 

    http://server:port/pentaho/Home

    where server and port are the server and port number where the Analytics server is installed.

    If the installation is successful, you will see a Pentaho landing screen.

    If not, see the troubleshooting tips for guidance: Troubleshooting Analytics.

  5. If you are using MySQL, update the default data source used by the BA server.

    By default, PostgreSQL is set as the BA server data source. If you are using MySQL, you must change the connection type in the Pentaho User Console to reflect this:

    1. Log in to the Pentaho User Console (BA server) as a user that is a member of the ANALYTICS_ADMINISTRATORS group.

      Enter the following URL: 

      http://server:port/pentaho/Home
      where server and port are the server and port number where the BA server is installed.
    2. Click Manage Data Sources to display the list of configured data sources.

      If you cannot see any files or the SkyVaultDS data source, the bootstrap content has not been imported. See the troubleshooting guidance for more information.

    3. Highlight the SkyVaultDS entry and select Edit from the menu.
    4. In the Database Type field, change the value to MySQL.
    5. Click OK to save your changes.
Parent topic: Installing SkyVault Analytics

© 2017 TBS-LLC. All Rights Reserved.