Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: create database repository for kettle pdi-ce-8.1.0.0-365 does not provide backend.

  1. #1
    Join Date
    Sep 2006
    Posts
    17

    Default create database repository for kettle pdi-ce-8.1.0.0-365 does not provide backend.

    Hello all,

    today I trieed to set up a data base repository to store my transformations for kettle pdi-ce-8.1.0.0-365 in oracle.
    I can not setup a repository.
    I was able to setup a oracle connection whitch was successful created.

    What I did (OS = Windows 10):
    DB-Action:
    -----------
    create user tdw_kettle identified by xxxx;
    GRANT connect TO tdw_kettle;
    GRANT resource TO tdw_kettle;

    GUI-Action:
    -----------
    start Spoon.bat
    go to the upper right corner of the gui and select "Connect" - Button
    go to "Other Repositories" link
    select "Database Repository" link
    go to "get startet"
    Set "Display Name"
    Select "Database Connection" --> create a database connection (oracle) --> test --> ok
    Select "Back"
    Select Launch connection on startup
    Select "Finish" button
    Get a message box "Congratulations!"
    Select "Connect now"
    Enter standard credentials admin/admin
    Get the following Error "You don't getting a connection to the server........"

    Please, where go I wrong.
    Do I have to setup a server?
    Using previous Kettle Versions are provided by creating a repository from scretch.

    Is there a discription how to set up the kettle repository for pdi 8.1.

    Thank you so much for any recommendations or help in advance?

    T.

  2. #2
    Join Date
    Sep 2006
    Posts
    17

    Default

    Hi,

    the solution is:
    -- Make shure you run the following script (is located in current pdi-8.1.0.0 server path/named = ....your_workspace\pentaho-server\data\oracle10g\create_jcr_ora.sql)
    -- The content of the following script create the expected user (please adapt to you schema and db name, it is only for Oracle DBMS)
    -- I use the mentioned jcr_user, don't now if it is no problem using another user, I think it will be the problem
    ===== start =====
    set escape on;

    create tablespace pentaho_tablespace
    logging
    datafile 'ptho_ts.dbf'
    size 32m
    autoextend on
    next 32m maxsize 2048m
    extent management local;

    drop user jcr_user cascade;

    create user jcr_user identified by "password" default tablespace pentaho_tablespace quota unlimited on pentaho_tablespace temporary tablespace temp quota 5M on system;

    grant create session, create procedure, create table, create trigger, create sequence to jcr_user;

    --CREATE ADDITIONAL REPOSITORY TABLES

    conn jcr_user/password;
    commit;
    ===== end =====

    After that, run the steps from my initial Thread above and use the new created user and login with admin/admin.

    Hope this helps

    T.

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 - 2017 Pentaho Corporation. All Rights Reserved.