Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. Replies
    3
    Views
    831

    Working with a Jade database

    Hi Everyone,

    Does anybody have an idea of how to work with a Jade database? It is an OO database and it behaves very strangely, even for an OODB.

    We have a legacy ERP system that quite frankly...
  2. Replies
    0
    Views
    1,716

    Getting up to date

    Hi Everyone,

    Its been a few years for me since I have deployed a BI server and I am seeing that the current version is WAY in advance of where I last used Pentaho (3.5). Can anyone recommend a...
  3. Replies
    4
    Views
    5,624

    Hi Burcu, Doing a C# app with Kettle /PDI is...

    Hi Burcu,

    Doing a C# app with Kettle /PDI is going to be a hell of a lot of work. If you are determined to head down this path you might want to consider some machine translation tools to assist...
  4. Replies
    24
    Views
    3,023

    Hi Marabu, I started with Kettle / PDI back in...

    Hi Marabu,

    I started with Kettle / PDI back in 2007 or maybe even a little earlier. I used to be quite competant at using the tools but I havent practiced for a couple of years due to a change in...
  5. Replies
    24
    Views
    3,023

    Hi Marabu, The process works quite nicely...

    Hi Marabu,

    The process works quite nicely without MS Access. The tables that were migrated across to MySQL have fed the process perfectly and the whole thing ran without a hitch.

    I dont know if...
  6. Replies
    24
    Views
    3,023

    Hi Marabu, Yeah did all that. All the normal...

    Hi Marabu,

    Yeah did all that. All the normal MS Access tricks. I ended up taking a different approach to solve the issue. I made the assumption given the evidence at hand that the issue was not in...
  7. Replies
    24
    Views
    3,023

    Hi Marabu, Yeah I get what your saying but...

    Hi Marabu,

    Yeah I get what your saying but that isnt an issue here. The sub job is being processed one row at a time. The variables are being set correctly and pased on correctly. What is...
  8. Replies
    24
    Views
    3,023

    Hi Marabu, Tried to get to the bottom of this...

    Hi Marabu,

    Tried to get to the bottom of this ETL injection problem. The Metadata Extractor step is pumping out the row(s) after the cleanup step into the injection step. I verified this with a...
  9. Replies
    24
    Views
    3,023

    Test deployment works sometimes but not others...

    Hi Marabu,

    I have buillt a few transformations and jobs to migrate approximately 1500 tables worth of data into a normalised storage table. They were all created with custom code when ripping data...
  10. Replies
    24
    Views
    3,023

    Hi Marabu, Just a passing thought given what I...

    Hi Marabu,

    Just a passing thought given what I now know about the ETL Metadata Injection step: Since the step runs the target transformation as its default, I can turn this feature off. If I were...
  11. Replies
    24
    Views
    3,023

    Marabu, thankyou. I get it. This working example...

    Marabu, thankyou. I get it. This working example is simple and perfect. I didnt realise that the ETL Metadata Injection step actually runs the target transformation. I would have been doing the...
  12. Replies
    24
    Views
    3,023

    Hi Marabu Thanks again for getting back to me...

    Hi Marabu

    Thanks again for getting back to me on this. I have experimented some more with the Meta Data Injection and seem to be getting nowhere. I must be missing something in my understanding of...
  13. Replies
    24
    Views
    3,023

    Hi again Marabu, Just an add-on thought. Does...

    Hi again Marabu,

    Just an add-on thought. Does this also mean that I will have to worry about reading all the sheetnames and columns from an excel file? Seems a bit chicken and egg if this is...
  14. Replies
    24
    Views
    3,023

    Hi Marabu, I have had a chance to play with...

    Hi Marabu,

    I have had a chance to play with the ETL MetaData Injection step but I'm finding myself at a loss for a successful implementation. I have done some further reading on this tonight and...
  15. Replies
    24
    Views
    3,023

    Hi Marabu Thanks for the pointer. I will have...

    Hi Marabu

    Thanks for the pointer. I will have a play with that step over the weekend and come back on this. I have not used this step before so I need to do a little reading up on it first. I am...
  16. Replies
    24
    Views
    3,023

    Hi marabu In teh first stage of the process I...

    Hi marabu

    In teh first stage of the process I have a single field (the raw text), but later on after some processing I will have an unknown number of fields due to the various types of document...
  17. Replies
    24
    Views
    3,023

    This is a sample of the desired output

    Hi marabu,

    Thanks for getting back to me. The source files (incoming data) are not under my control, hence the need to break them up this way. The 'raw' files are often PDF, which I push through a...
  18. Replies
    24
    Views
    3,023

    Transposition of fields to rows

    Hi Everyone

    I am exploring a data storage scenario that I would like a little guidance on. The scenario is that a file may be received with any number of columns(fields), and this needs to be...
  19. Thankyou for the helpful pointers

    Thanks Marabu, most helpful. You have me back on track and I really appreciate your help. Played with PDI all day yesterday getting ready for a data migration and it's coming back to me. I had...
  20. Repeat a value till the next identified increment in unstructured text

    Hi Everyone

    It's been a very long time for me since I have used PDI and I am seeing a lot of work has been done since the days of version 2.x Kudos to all the developers and Matt for keeping this...
  21. Replies
    22
    Views
    13,408

    Not quite following you...

    Hi Taqua,

    You stated:

    Are you referring to $TOMCAT_HOME ? Or some other environment variable? Can you elaborate on this for clarity for me? Example maybe?

    Cheers

    The Frog
  22. Replies
    22
    Views
    13,408

    rdbms for repository

    Hi Guys,

    The change in settings.xml for the repository is to have the BI server use a repository that is stored on a database server instead of saving everything in individual files. I use a...
  23. Replies
    22
    Views
    13,408

    Kettle part solved

    OK, the kettle stuff is simply this: The
    /opt/pentaho/pentaho-solutions/system/kettle/settings.xml file needs to be told about how to login to a repository. That means you need to change the...
  24. Replies
    22
    Views
    13,408

    Had a bit of a dif through and discovered a few...

    Had a bit of a dif through and discovered a few issues with the install. Several components are failing, and they seem to be centered around two areas. One is kettle and the other is reporting.
    ...
  25. Replies
    22
    Views
    13,408

    Hi Martin, You have been going through the...

    Hi Martin,

    You have been going through the same stuff I have just been doing. And stopped at the same place! I am going to have a crack at the kettle stuff this weekend and see what I come up...
  26. Got logging up and running

    Hi again,

    I dont know what the cause of the logging not showing up is / was but it is working again and it shows me a few issues. Basically it seems that there are two primary problems, the first...
  27. Anyone?

    Anyone?
  28. deploying 3.7 with MySQL - Mondrian listner fail???????

    Hi Everyone,

    I am in the process of setting up a demo virtual machine to try and showcase Pentaho to my new boss. I have done this before with no troubles, but that was a few versions ago and I...
  29. Replies
    7
    Views
    6,142

    Hi griffoun, I am not sure exactly what you...

    Hi griffoun,

    I am not sure exactly what you are saying, but if I understand you correctly you may have approached your transformation with more complexity than it needs as well as missing some of...
  30. Renato, thankyou very very much for this. I...

    Renato, thankyou very very much for this. I really appreciate it. The UDJC step wasnt available the last time (a long time ago now) that I worked with PDI and was still in the development stage. I...
  31. Performance of Java Expression Step vs. User Defined Java Class

    Does anyone have any info / hard data / examples (real world) that can show a difference between these two steps?

    Cheers

    The Frog
  32. Replies
    3
    Views
    1,807

    Ahhh, never mind. I will just use...

    Ahhh, never mind. I will just use fieldname.replace("/\\s+/g"," ")

    Its probably the easiest anyway :-)

    Cheers

    The Frog
  33. Replies
    3
    Views
    1,807

    Thanks Slawo, thats a good idea. It will have to...

    Thanks Slawo, thats a good idea. It will have to wait till the weekend though as I cant do that inside the office. Just in short then, do you know if there is a function / method in there somewhere...
  34. Replies
    3
    Views
    1,807

    Javadoc for org.pentaho.di.core.Const

    Hi Everyone,

    I am looking at javadoc.pentaho.com for the docs on org.pentaho.di.core.Const but am unable to locate them. Can anyone post a link to the correct url ?

    Cheers

    The Frog
  35. Replies
    6
    Views
    3,680

    Thanks guys. I knew it had to be something really...

    Thanks guys. I knew it had to be something really obvious. Forgetting to escape the damn regex will do it every time.....

    I really appreciate the help guys. Thankyou.

    Cheers

    The Frog
  36. Replies
    6
    Views
    3,680

    Oops, I did remove the first question mark symbol...

    Oops, I did remove the first question mark symbol from the above.....sorry for that.
  37. Replies
    6
    Views
    3,680

    Hi watchman, Thanks for the reply. The regex...

    Hi watchman,

    Thanks for the reply. The regex (the more complex one) sets out to capture the first letter of any word that isnt capitalised [a-z], and the word doesnt contain the '&' symbol. You...
  38. Replies
    6
    Views
    3,680

    JavaScript step regex in formula

    Hi everyone,

    This seems to be such a simple thing but I cant get it to function inside the JS step. I am hoping someone can point out the error of my ways...........

    I have a function as...
  39. Thread: UDJC Jumpstart

    by TheFrog
    Replies
    0
    Views
    1,106

    UDJC Jumpstart

    Hi Everyone,

    Long time no speak. I must say it is good to be back and I am really enjoying the new features in PDI 4.x Really nice work. I am doing a little remedial learning to bring myself up...
  40. Replies
    2
    Views
    1,165

    A simple thankyou

    Hi Everyone,

    I would just like to take the opportunity to thank all the individuals who have helped me when I needed it, and let everyone know just how appreciated your help has been. A very...
  41. Replies
    3
    Views
    1,332

    That makes a lot of sense

    Hi Matt,

    Thanks for the feedback. I was thinking that the only place where I even see TCL is in this particular application. It is certainly not quick either, TCL seems to run quite slowly (even...
  42. Replies
    3
    Views
    1,332

    User Defined Java Class

    Hi All,

    I am just wanting to bounce a question around as I am looking at moving from PDI3 to PDI4. We have an 'old' system that does some ETL using TCL as a scripting language. The scripts are...
  43. Are you talking meta-data?

    Like the title says, are you referring to the meta-data of the fields? That would be a slightly different use of the Select Values step and this set of tests may not apply - it depends on what you...
  44. Ummm....no mystery here

    Hi there,

    Your kind of missing why this is the case. This is nothing really to do with the 'Select Values' step(s), but rather that the fastest code is code that you dont ever run. Since you are...
  45. Replies
    3
    Views
    2,782

    JS is your friend

    It is possible to use a JavaScript step to solve this issue as long as your meta-data is accurate. There is a thread in this forum between myself and Matt Casters about using JS to truncate all...
  46. I see...

    Packt seem to be handling the foreign languages and distribution with difficulty. Some further info for you on ordering the book here - Thalia finally 'managed' to track the book down, said it will...
  47. Ooooohhhh Nice!

    I'll be there.

    Just to let you know, there seems to be an issue getting the book through retailers in Germany. Thalia, arguably the biggest, doesnt even know the book exists and it isnt showing...
  48. Replies
    2
    Views
    1,356

    Here is an earlier post on the topic with solution

    http://forums.pentaho.org/showthread.php?p=232052#post232052

    This is what I do to solve this exact issue. The attached transformations and jobs are the 'template' of the methodology. It works...
  49. Replies
    8
    Views
    1,923

    Two table approach

    You could also try a two table approach, where 'new' incoming data on the client (ie/ client entered) is stored in an 'incoming table'. This is then at regular intervals brought to a 'holding table'...
  50. Thanks :-)

    Thanks :-)
Results 1 to 50 of 233
Page 1 of 5 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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