Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Loading Data Warehouse

  1. #1
    Join Date
    Mar 2012
    Posts
    5

    Default Loading Data Warehouse

    Hi all,
    I became interested in Pentaho and I just recently purchased the book Pentaho Solutions.
    My interest is in particular in the development of the front end of BI, the creation from metadata using Pentaho Metadata Editor to reports and so on. Ignoring the process of data warehousing.
    So I need to use a data warehouse already complete to practice.

    Here is my question...the site of the book mentioned above comes with two files(wcm.sql and wcm_dwh.sql) for a local database.
    Unfortunately I can not load these into my MySQL database.

    I hope someone can help me out.
    Last edited by luke.sky; 03-08-2012 at 10:05 AM.

  2. #2
    Join Date
    Sep 2011
    Posts
    190

    Default

    Quote Originally Posted by luke.sky View Post
    Unfortunately I can not load these into my MySQL database.
    It would be helpful to know why not :-)
    What's the error message?

  3. #3
    Join Date
    Mar 2012
    Posts
    5

    Default

    Quote Originally Posted by mbvt View Post
    It would be helpful to know why not :-)
    What's the error message?
    Sorry i forget it.

    At first I tried to load the file from the command line using the command "SOURCE wcm.sql" but only gave me a constant error message for each line analyzed.
    After that, thinking it was a mistake caused by file size (> 200 mb), I tried using the program "dbForge Studio Exprese" and gives me error "Operation CREATE USER failed for 'wcm' @ '%'".
    I don't understand how to proceed.

  4. #4
    Join Date
    Sep 2011
    Posts
    190

    Default

    I just downloaded the files and tried for myself in in testdb.
    I'm having the same problems with both wcm.sql and wcm_dwh.sql
    Maybe contacting Roland or Jos directly helps?

  5. #5
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    lol i dont think so mbvt. There is clearly no problem with the sql files themselves - this is just a user who doesnt know what they need to do.

  6. #6
    Join Date
    Mar 2012
    Posts
    5

    Default

    Quote Originally Posted by codek View Post
    this is just a user who doesnt know what they need to do.
    That is right. Damn you're a very cool man, isn't it?


    I was not born learned, and I want to learn ... any criticism is good for me.


    Now the only clue that the book gives me before starting working on the database is:


    "... we decided to Develop a freely available LGPL-licensed sample database with enough complexity and realistic amount of data in it to be useful as source for a data warehouse project .... The basis of the data sets and scripts to create the schema and create the transaction data can be downloaded from the companion website of this book. "


    If I misunderstood something please be more specific and help me understand how I have to use these scripts.

    P.S. mbvt thanks for trying

  7. #7
    Join Date
    Mar 2012
    Posts
    5

    Default

    Quote Originally Posted by codek View Post
    There is clearly no problem with the sql files themselves
    but above all, why do you say this? have you tried the files?
    I study computer engineering so I do not think to be too stupid, I can not even open the file with a text editor, as it is too heavy, to see what are the commands.

    bah sorry but you made me really pis*** off

  8. #8
    Join Date
    Mar 2012
    Posts
    5

    Default

    I just wanted to let you know that I have solved ... I managed to open the file with PSPad ... I simply create a user manually as specified in the script.
    I then ran the script through dbforge, and simply ignoring the error on the user creation on wcm@% ...


    I want to apologize for my reaction codek, but it was a hard week

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.