PDA

View Full Version : Pentaho Data Integration [Kettle]



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 [43] 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98

  1. using setVariable in javascript
  2. Javadoc for org.pentaho.di.core.Const
  3. Loading facts
  4. Two newbie questions
  5. Fast steps for optimizing transformation speed
  6. Get Step Name
  7. Negate stream lookup
  8. get Log record
  9. Different Job depending on Week Number
  10. calling main function from java class
  11. kitchen tries to run jobs from a repository even when using -file option
  12. Problem with Lookup logic & Database join
  13. Str to Date Including Timezone
  14. Help me to execute shell script
  15. help me on learning kettle
  16. Use functions to get ChildJob
  17. Issues with variable substrings
  18. Performance of Java Expression Step vs. User Defined Java Class
  19. Regex Works with online regex tester but not in Pentaho JavaScript Step
  20. Filter condition Doen't work!!!
  21. Use date functions
  22. 3 quick evaluation questions??
  23. transformation database configured at runtime
  24. kettle.properties and Metadata Editor
  25. Run transformation as if it were another day
  26. After addt. Steps - like lookup - data from database are modified
  27. Usage of shared objects in non-standard location
  28. Kettle Plugins
  29. Error Table output index out of bonds
  30. Overview of how I use Fitnesse for testing jobs
  31. How to swap JTDS driver for MSFT driver for SQL Server?
  32. Batch Insert/Update from Spoon v4 to MySQL
  33. New Table has columns with old table rows value. Possible?
  34. Probelm with logging
  35. Help on Database Lookup/Update (SCD Type 2)
  36. Cannot run any Transformation/Job
  37. Slow tranformation
  38. File Compare Operation
  39. Trimming input
  40. repository issues running in clustered mode v4.0
  41. Newbie help ... Can't connect with Generic Database Option
  42. Extracting repeated fields and in insert into as a separate row in a table
  43. Kettle Plugins - Calling Other Core Steps
  44. Error connecting to database: I/O Error: Connection reset
  45. Facing problem for Mapping(execute sub transformation) step.
  46. Regex Allowing Invalid Fields Pass Through !!!
  47. How to load multiple tables ?
  48. Excel output and multiple tabs
  49. Error connecting to Salesforce!
  50. Table Input - Parameters
  51. Can remote execution use remote kettle.properties?
  52. HTTPS Webservices
  53. Varible arguments - Loop in Select Query
  54. Conditions in Executing a job
  55. Lookup in date dimension
  56. Dependant Transformations
  57. Spoon crashes during edit
  58. The logging file is not completed in pdi-ce-4.1.0-stable
  59. "accept filename from field" in excel output
  60. [4.1.0]Error opening transformation within a job
  61. What is the purpose of the Date tab in the transformation properties?
  62. Can't connect to MSSQL Server 2008 R2 using Windows Authentication
  63. PDI shuts down after launching
  64. Several heap space errors causing frequent Spoon crashes
  65. Date error oracle -> pdi
  66. Design Plugin Question
  67. Unable to connect to ODBC Data Source (GeneroDB)
  68. Doubt about "Table Output" step
  69. Scheduling Kettle Jobs
  70. Web service lookup over SSL
  71. Dynamic Table Output
  72. Problem with Insert/Update from Excel into Mysql table
  73. Environment variable with date ?
  74. Any way to speed up Serialze to file?
  75. Value replaced for variable (?) set between single quotes causing SQL syntax error
  76. How to peer review job/transformation changes?
  77. Get data with XML-Request
  78. Using GPU stream processing for processor intensive calculations/operations?
  79. In Spoon, setting field 1 to match value in field 2, field 1 is null
  80. PDI Enterprise vs Community edition comparison
  81. avoid comma in a comma separated value file
  82. search method in kettle 3.2.2
  83. ETL for multiple csv files
  84. Excel Input step aborts with NullPointerException
  85. Improvements for EXCEL input file
  86. attach zip files to Mail
  87. Bit field not staying as a bit?
  88. HTTP Post Step Not Working in Carte
  89. Stream look up - How to
  90. How to make pentaho memory free while runtime
  91. Running Job with crontab
  92. Unable to parse date with this pattern MMM d, yyyy hh:mm:ss a z is it wrong?
  93. Error when referencing transformation in job
  94. Importing jobs and transformations
  95. For no reason, job stops responding. Process still running with no activity!!!
  96. Reporting Plugin
  97. Crontab doesn't work
  98. Google Analytics - Dynamic Dates
  99. Doubt about "Unique rows" step
  100. CSV File with date column and date in different formats
  101. Excel Input File xlsx Apache POI ??
  102. Update to Null
  103. crontab won't run kitchen in linux
  104. Loading related tables which have constraints?
  105. "Memory Group by - Always give back a result row" not working
  106. Managing Database connections
  107. Data Vault demo set for Jira: #PDI-3209
  108. Encripting
  109. Step after negative Switch/Case shouldn't be executed but is
  110. How to change kettle logging format? Are Log4j style appender formats available?
  111. Can Kettle decrypt data encrypted with AES-128 CBC algorithm?
  112. Transformation reference in Job changes to /null after import
  113. code for org.pentaho.commons.launcher?
  114. MS Access File
  115. excel writer plugin
  116. rows into columns after a null row
  117. Exclude new columns from csv step
  118. Error open transformation from job
  119. four bugs with Regex step
  120. Note - Ariel is Default Font, Should it be Arial Instead?
  121. Salesforce API v21 support
  122. Oracle Bulk loader issue
  123. Get File Names!
  124. Job creation in windows Environment
  125. Resetting Mondrian cache after ETL.
  126. Creating transformation in 3.7
  127. Can Kettle extract data from plain text file (File type: non CSV, non fixed )?
  128. PDI 3.2 hangs without logging
  129. Running PDI 3.2 and 4.1 parallel ?
  130. Insert/Update Date Issue with DB2
  131. JSON input step: We MUST have the same number of values for all paths(Error)
  132. Can not load Null to Datetime field
  133. Whats the best way to remove ALMOST duplicate rows (one field is different)
  134. Table Input using the IN () operator
  135. How to generate dynamic output file names based on result set from previous job.
  136. JSON Input to Kettle
  137. Using parameter files between Windows and Linux
  138. Lost MySQL Connection
  139. Processing source tables with million+ rows (memory issues)
  140. String to Date Format Issue
  141. ArrayIndexOutOfBoundsException for select value step.
  142. Prefixing log entry of step feedback row with transformation/job name
  143. Strange plugin behaviour when generating multiple output rows from a single input row
  144. Selecting and Joining Variables - Full ETL Process Explained
  145. Insert empty date in PostgreSQL
  146. An error occured saving the transformation!
  147. Arguments vs. Parameters -
  148. Issues with Infobright Bulk Loader step
  149. How can I do a simple select max(column) from table query to start a sequence?
  150. Row Normalizer with Variables
  151. Configure Repositories without GUI
  152. Set Reference and Compare rowsets for MergeRows
  153. UDJC Step terminates when outputting multiple output rows per single input row
  154. Newbie trying to startup with PDI 4.1.0 stable for Mac OS X
  155. What is the real advantage of Slave server?
  156. Update table from Transformation
  157. Dynamic Denomormalizer
  158. HELP: How Do I Store RegExp(Wildcards) in variables?
  159. Export and Import with 4.1 fails
  160. Issue in Running Pentaho DI 4.0 on Windows 7
  161. Mapping (sub-transformation) consuming inputs
  162. Using Dimension lookup/update step for Data Vault Satellite insert
  163. Execute SQL script with parameter in a transformation
  164. Error parsing date 0000/00/00-00:00:00
  165. Agile BI + Kettle (Michael Tarallo)
  166. OutOfMemoryError: GC overhead limit exceeded
  167. Variables expanding and escaping rules ?
  168. Job with parameters does not run on Linux - could be a bug!?
  169. 'Select Values' step is not mapping
  170. Sorted Merge - is it faster? What's the theory behind it?
  171. Why the trasformation doesn't write on the table?
  172. Let's share best practice advice on working with huge data sets
  173. SAP connector for Pentaho PDI (kettle)
  174. Running a Job which uses Kettle variables in Java
  175. Table Output to new dimension table (new row for every column value)
  176. Text file input: 0 byte separator problem (seems to be not working)
  177. PDI stops without logging
  178. Updating columns depending on a row
  179. PDI Excel Output
  180. Delete / remove first row (header) of a CSV file
  181. LDAP input file problem
  182. Issue Reading XLSX file
  183. week vs isoweek
  184. Error previewing an excel file when a field is empty
  185. Table Input step not recognising Alias field names in SQL query
  186. Is there a way to partition text files?
  187. Modify(add/delete nodes and attributes) XML
  188. Slow loading transformation - PDI 4.1.1
  189. My looping Job doesn't seem to do anything
  190. Variable vs Parameter
  191. How to allocate header value to detail records
  192. Data Type Error
  193. Error happened when to run Xbase sample with my test dbf file
  194. "renamed-to" field name lookup from database
  195. replace(var,var,var) in Modified JavaScript step Issue?
  196. Shell Script + Database connectivity help
  197. Database Connection Unavailable
  198. Extraction from Excel
  199. Pass file to xaction
  200. Optional Input Mapping Specification
  201. working with XML file in PDI
  202. Reporting Plugin
  203. Plugin with multiple output row meta
  204. Dynamic comma separated string concatenation
  205. Check date of file
  206. PAN Unable to prepare (..) Log connection error?
  207. Dimension lookup/update step creating multiple indexes on the same column
  208. Use email attachment as input
  209. PDI 4.1.2 connectivity on Windows 7 OS (64 bit) and (Oracle or mySQL or SQLServer)
  210. Maximum file size for log file
  211. Need help understanding how to control flow, processing order in a transform
  212. assign hex code of character to Variable or Parameter
  213. DefaultValue of parameter seems to be not passed along in kittchen
  214. How to set custom defaults for kettle.properties?
  215. New Ruby Scripting Step for Kettle available
  216. two patches
  217. Exception in thread "main" java.lang.NoSuchMethodError: method java.lang.Class.asSubc
  218. shared.xml
  219. Getting Kettle to Run on Windows 7
  220. Call DB Procedure - calling MySQL function
  221. Removing special charecters
  222. Text File Input - Running queries on Text File Input
  223. Update PDI 3.2 to 4.x
  224. stream is modified - correct data are read from input, but later on they seem to be
  225. Error on execute a transformation with pan.sh in Red Hat Enterprise Linux 5
  226. Tutorial: Designing a highly available scalable solution for processing files
  227. Detailed logging with SQL statements
  228. How can many transformations run with a public datasource in a job ?
  229. DDEX standards for message exchange in the media industry
  230. Snapshot Canvas
  231. Silly question for forum search - I don't know where I can raise this question
  232. Remove dependency on Saxon when Saxon not used
  233. working with ACF2 data
  234. Cannot run exported job with kitchen.sh
  235. Automated Testing
  236. parallel reading of csv file
  237. order by in DB lookup step
  238. OR in DB Lookup Step
  239. more than one plugin gives "Class not found"
  240. Kettle logs to database, START_DATE issue.
  241. Oracle Bulk Loader problem - LRM-00112
  242. DTS-like flow, possible?
  243. Add sequence - Table input
  244. Reading XML data through URL via proxy
  245. Problem reading GZipped file with CSV File Input Step
  246. Creating XML with Kettle?
  247. Dynamic Select Queries using the Table Input step
  248. Spoon transformation with more controls - very slow.
  249. Switch/Case JOB!
  250. Delete distinctrow