Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: themarchkid; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Okay. Thanks a lot for the suggestion. In 3.9,...

    Okay. Thanks a lot for the suggestion.

    In 3.9, while deploying the reports, we used to keep the reports generated using PRD in the physical folder "Pentho solutions" of bi server.
    We were able to...
  2. File handling and deployment in Pentaho 5.1

    Hi,

    We have been using Pentaho BI Server 3.9 for deploying the ETL and reports. We used subversion to check in the ktr and kjb files in our remote server, and executed the jobs using kitchen from...
  3. Generate date of past sundays using Calculator Step

    I need 15 rows as result each will be the date of sundays back from today.

    Rather than in query, can I generate it using the Generate rows and calculator steps?
  4. Replies
    1
    Views
    862

    http://infocenter.pentaho.com/help/topic/customizi...

    http://infocenter.pentaho.com/help/topic/customizing_pentaho_guide/customizing_pentaho_guide.pdf

    ...
  5. Replies
    1
    Views
    862

    Customizing the BI Server Report GUI

    Is it possible to customize the GUI which we see while viewing the reports?

    In the sample steel wheels report, the Pentaho GUI provides drop down lists to select the filters.
    Can we change the...
  6. Replies
    0
    Views
    466

    CUSTOM Interface FOR KETTLE

    Is it possible to customize the interface of the BI server reports? [eg : jquery effects to the drop down lists for choosing a filter etc]?
  7. Fixed. After deploying in server and...

    Fixed.

    After deploying in server and executing, The error log says:
    "java.io.File parameter must be a directory. /home/Pentaho_3.9_server/biserver-ce/tomcat/bin/simple-jndi "


    Found out that...
  8. Thanks. Almost done. Will be uploading in git

    Thanks. Almost done. Will be uploading in git
  9. In your case keep it inside [B]D:/tomcat/. ...

    In your case keep it inside [B]D:/tomcat/.

    Which ever folder is specified in the error log, keep simple-jndi in that folder.
  10. Thanks :) It worked when executed locally in...

    Thanks :) It worked when executed locally in eclipse.But while deploying, where should we keep the "simple-jndi" folder with jdbc.properties.While developing, it worked when i put in in the current...
  11. Replies
    4
    Views
    5,971

    Hi sarath, I tried the same using jsp..and...

    Hi sarath,

    I tried the same using jsp..and tried calling kettle job using the kettle java API. But I cannot execute it as I get the following error. I have included all the jar files necessary to...
  12. Embedding PDI : Calling kjb file from JSP Web Page

    Hi I have a kettle Job with a number of sub transformations and jobs. It requires some parametrers to be passed as arguments.
    I am trying to call the job from a jsp web page. I tried the following...
  13. As I said, keep the simple_jndi folder with the...

    As I said, keep the simple_jndi folder with the jdbc.properties file in the project folder.
  14. Replies
    0
    Views
    489

    Calling .kjb files from.JSP web page

    removed
  15. Sorry for the silly question. Issue fixed when I...

    Sorry for the silly question. Issue fixed when I copied simple-jndi folder and jdbc.properties file to my eclipse workspace :p;)
  16. JNDI error While calling kettle job from Java code

    My project calls a kettle job from the Java API.

    I have a kettle job with a number of transformations and jobs within.
    I am passing command line arguments to the job. Using java API I pass...
  17. Java GUI integration with Pentaho Transformations

    I have an ETL job designed in PDI spoon. I want to provide a GUI for giving the start and end date filters from a dropdown box and on a button click, it should connect to PDI and execute the...
  18. Replies
    1
    Views
    1,613

    PDI 5.1 Community Edition and EE Trial

    I want to try pentaho DI 5.1. I got the community edition package in a zipped file [pdi-ce-5.1.0.0-752] and I am able to launch spoon.But is Penataho DI server a part of the zip file?

    The info...
  19. How to set Table outpt Step for Multiple Input queries: Kettle JAva API

    redo
  20. Replies
    0
    Views
    552

    Creating database using PDI java API

    Is it possible to create a database using the kettle java API?

    We can connect to a particular database using DatabaseMeta and Database classes.
    But I need to create a new database and add tables...
  21. "jdbc:jtds:sqlserver://abc.efg.com:1433/msdb;insta...

    "jdbc:jtds:sqlserver://abc.efg.com:1433/msdb;instance=myinstance;user=xxx;password=xxx";
  22. Now I tried connecting without the xml string as...

    Now I tried connecting without the xml string as follows:

    DatabaseMeta targetDBInfo = new DatabaseMeta("target","MSSQL","Native","serveraddress","dbname","1433","user","pwd");

    But still...
  23. How to change target database: [Kettle Java API]

    I am using the following xml string to generate transformation:

    databaseXML = {
    "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
    "<connection>" +
    ...
  24. I am using the following xml string to generate...

    I am using the following xml string to generate transformation:

    databaseXML = {
    "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
    "<connection>" +
    ...
  25. No.I am getting the teradata specific exception...

    No.I am getting the teradata specific exception in console as a log text. I set log level to DETAILED as well.

    But my question is how to get the teradata exception in program within a catch block....
  26. How to get database specic exceptions from transformation

    I need to get the exceptions thrown by the source database (Teradata) when there is an error in the query, which is executed by the transformation step.

    I am getting the exception in the...
  27. I need to get the exceptions thrown by the source...

    I need to get the exceptions thrown by the source database (Teradata) when there is an error in the query, which is executed by the transformation step.

    I am getting the exception in the...
  28. Get system info step worked.I used...

    Get system info step worked.I used SystemDataMeta. Thanks Gutlez :) ! !
  29. :) gutlez...Thank you for you suggestion. I've...

    :) gutlez...Thank you for you suggestion. I've also thought of getting familiar with the GUI but can you give any help regarding which step to use, for adding additional columns in the target...
  30. Can you provide some links about generated...

    Can you provide some links about generated values. My table doesn't have an identity column. What I am getting in my target table is , data populated in the columns which I have specified in the...
  31. tableoutputmeta.setGeneratedKeyField() what it does?

    I have a table output step defined as follows:

    TableOutputMeta toi = new TableOutputMeta();
    toi.setDatabaseMeta(targetDBInfo);
    ...
  32. Custom ETL using Embedding PDI Java APIs :Issues

    I need to transfer millions of rows from teradata to MSSQl server.

    I have coded a customized java code for data transfer by embedding Pentaho kettle transformation APIs.
    What I did:

    I used...
  33. Thanks :) I got the number of records from the...

    Thanks :) I got the number of records from the log .

    @nivinjacob
    <<The log file name can be specified in the 'Logging settings' tab of a Job/Transformation entry.>>

    but I am not using...
  34. Embedding PDI in Java: How to get No. of records transfered

    I am using Pentaho DI for developing a custom tool for data transformation.

    1.How can I get the count of total no of rows inserted into the target database?

    2. How can I route the log...
Results 1 to 34 of 35
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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