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. how to get top n of each group?
  2. Triggering a job in carte via HTTP
  3. How do stop a job that runs every minute?
  4. .kettle folder is created under C: drive
  5. Job Processes Locally but Fails Remotely
  6. table output step: rows not written
  7. Job/Subjob logging weirdness
  8. On using the "write to log" step...
  9. Get Data from XML / Content not allowed in prolog. UTF-8
  10. Calculator-step won't work in PDI 4.2.1 for one ktr
  11. How to not generate table lock for job? (MySQL)
  12. "Copy Files" job step won't remove files
  13. Mail transformation step
  14. calculate the time past from one row to the second
  15. Incremental update in pdi 4.2
  16. need help regarding how can we store status value in job setting of log table
  17. How to find rows processed per minute? Pentaho version 4.2.1-stable
  18. Update Statement - How to
  19. row denormalizer with metadata injection giving unpivot field not found error
  20. binary file
  21. issue with "add xml"
  22. Copy files in parallel
  23. Unusual Copied Output Rows
  24. how to give ready only permissions to user in kettle 4.2.1 version ?
  25. convert byinary-string to string
  26. SQL Server procedure feedback?
  27. Can you Start Multiple Copies of a Filter Step that has a True and False Hop?
  28. UNC and Win Server - Help me understand
  29. How to remove specific columns from a CSV file input?
  30. Log record time-outs & execution lineage
  31. Remote input/output sniff testing on a Carte server
  32. Execution lineage logging
  33. Renaming individual columns
  34. Add fields changing sequence (group sequence)
  35. Send information using Syslog: Send a message to a Syslog server
  36. Auto merging concept in pdi 4.2.1
  37. ETL Db testing - Similar to Blackbox Testing
  38. Data stream as output
  39. I performed this "optimization" but have no idea why it worked.
  40. ERRORS column doesn't storing 0's and 1's
  41. Failed to execute runnable (java.lang.ArrayIndexOutOfBoundsException: -1)
  42. optional database Lookup
  43. Adding a wildcard to Unzip file Step
  44. Pentaho Data Integeration
  45. Pentaho Data Integeration
  46. pdi-ce-4.2.1- stable free down load software is not working properly
  47. Supplementary fields in a SCD
  48. how can we use Prioritize streams
  49. Scaling CSV Input - quirky results to report (surprisingly good numbers)
  50. error:followed unconditional link
  51. How to make file itself as an input to input stream ?
  52. Pentaho Data Integration
  53. Pentaho Data Integration
  54. How to manage a very complex XML structure
  55. Step Loader error in kettle-engine jar version 4.2.1
  56. Programming/scripting languages supported in pentaho
  57. Excel input to sql insert statements
  58. Removing whitespace from large fields
  59. How to parse unstructured data ??
  60. Execute multiple statements in Table Input.
  61. kettle.properties
  62. problem while executing transformations in Java
  63. SQL File Output
  64. Licensing Details
  65. Convert to string and cut substring
  66. Compress Data
  67. exception when running sql in pentaho but not in mysql editor
  68. using values in a sql query and seeing results
  69. Date/time convertion
  70. Repository Connections
  71. Newbie Performance Question
  72. Date Format in Select Values
  73. Add sequence- Sequence no with previous run
  74. Read only permissions in kettle 3.2.1
  75. Can we directly use kettle 3.2 version repository in kettle 4.2.1 version
  76. comparing values from 2 different data streams?
  77. Salesforce Input --> Salesforce Insert
  78. Using replace in string with regular expressions
  79. Slower extraction time: streamlining ETL issue
  80. iterative operation between rows
  81. header of csv file
  82. Dynamic Row normalizer step
  83. using merge join or something similar?
  84. Switch case functionality in kettle
  85. how can we connect two Data Bases using Transformation step
  86. Creating multiple directory levels before (or during) SSH2 Put step?
  87. Sap Input Test with BAPI_FLIGHT_GETLIST
  88. using csv input as variables in table input
  89. PostgreSQL Bulk Loader - When does it commit, and when does it exit?
  90. comparing 2 values from 2 different sql queries
  91. authentication issues with MongoDB Input
  92. large number of url requests
  93. How to connect with Unisys DMSII
  94. Integrate GATE text processing API and Pentaho DI
  95. 4.2.1 Spoon JNDI Connection failure
  96. stable version for KETTLE 4.2.1 software
  97. Export Job to XML
  98. prioritizing two streams ..but with one small tweak..
  99. How to determine all the jobs a transformation is used in?
  100. XML Join Is Not Seeing Comparision Field
  101. Storage of user defined functions
  102. Catching Error messages and warnings
  103. MySQL BulkLoader issue.
  104. Curious if any of the Web_Service steps allow "WS_SECURITY" to be used?
  105. Pentaho HTTP client and select values step!
  106. Io exception: Socket read timed out using kettle 3.2 with oracle data base
  107. using variables in a job
  108. How to Read Multiple Files Located in Multiple Folders
  109. Importing Excel spreadsheet into oracle DB
  110. How to connect to an Oracle Service NOT a SID using Pentaho Spoon
  111. Extraction of multiple datasets from a database
  112. Import Table Row Count
  113. simple formatting question
  114. Xls to xml
  115. UDJC has correct output values but next step doesn't
  116. plugin development - grabbing input from field
  117. New features in PDI 4.1.0
  118. Sequence number - continuation of the previous run
  119. Excel output and Writer Error
  120. Switch on jobs?
  121. Table Input Step Parallel reading.
  122. sending email to multiple recipient from query result
  123. Input/Update How does it work for date value ?
  124. Returning autogenerated keys is not supported.
  125. How to do row counts for multiple tables in a transformation?
  126. Samples for the single threader step
  127. Date Format - Unparseable date even it's the right format
  128. There was a data type error: the data type of java.lang.String object [ ] does not co
  129. DELETE Step - Compare
  130. Read and write to lookup dataset
  131. Kettle Data Source not working.
  132. Update component for Mysql db cast issue
  133. Extra quotes in output
  134. FTP a file with Target FIle Name of our choice
  135. Execute a shell script
  136. Lanching job on slave server - need help
  137. Get SQL Warnings
  138. Create an empty table
  139. An I/O error occured while sending to the backend.
  140. JNDI connections in Kettle inside Pentaho BI Server.
  141. Back References on RegExp by Zip Files
  142. Multiple Database lookup Single Table Output
  143. Static Data Report Mining
  144. <IDLE> in transaction with Postgres using kettle 4.1
  145. Initialization error while running transformation
  146. sql statement causing database connection problems.
  147. PDI ETL 101 questions
  148. regex evalutation to replace within a field
  149. Embed the value of a parameter into the sort steps "TMP-file prefix"
  150. Sales Force input no longer works
  151. Data truncation -error
  152. ERROR in stream lookup or des-serializefiile
  153. Read a whole line from text file
  154. write values back into csv input?
  155. Null in If formula
  156. What's the difference between Join Rows and Merge Join steps?
  157. Transformation fails, this is the first time I tried a database Join
  158. 4.2.1 randomly stops opening files...
  159. Creating Oracle DB connection with named parameters
  160. REST Client bug?
  161. Transformation Parameters, Job Variables, and Value Substitution
  162. validation - unique rows
  163. Reading ACT database
  164. multiple excel files into different tables in the same transformation
  165. Moving Average in Spoon
  166. Dimension lookup update failed - Pentaho Kettle Solutions
  167. How to accept any value as is from the Input Excel?
  168. Convert String to Date
  169. Copy value of a field to another line with a simple condition.
  170. How much temp space is being used during processing?
  171. AD to Salesforce upsert
  172. Startup Problem Mac OSX Lion
  173. Format of dates in logfiles (Kitchen 4.0.1)
  174. User defined Java expression - having trouble
  175. Migrate Plugins from PDI 3.2 to 4.2
  176. executing a remote job with Carte
  177. Generating file list using JavaScript step for SFTP Get
  178. Session/Variable/Process
  179. Issue Running Multiple Instances of a Transformation with Transactional Support
  180. how to load a generic TARGET with data extracted from the associated SOURCE?
  181. "txt file input" won't recognize "filename" field.
  182. Problems using variables on SQL job step
  183. Question on Performance Degradation from Joining Streams using Dummy Step
  184. Web Interface to Kettle (Spoon)
  185. Compare Local Folder to FTP Folder
  186. 4.2.1 Function OUT error with JDBC above 3.1.14 on Table Input
  187. STEP: email messages input - can't get filter to work
  188. Kettle 4.2.1 using MySql JDBC errors on DATETIME Fields with a SELECT QRY
  189. Failed to call a SQL procedure
  190. Installation Kettle
  191. Network Adapter could not establish the connection
  192. Scheduling in PDI EE
  193. looping job seems too fast
  194. Dimension look up update
  195. SAP Java Connector + ITN Connector ERP = HELP!
  196. Output file name based upon input file name
  197. Out of order step execution when using the Dimension lookup/update step?
  198. Plugin Development Simple Step
  199. Execute local/remote Windows Command Line (with Arguments) as part of Step?
  200. New Apache POI Beta - Large XLSX files
  201. Table Input from SQL-File
  202. Group XML elements to one higher level
  203. Copy rows x Set/Get Files
  204. meta data, sql join, table input
  205. Checkbox in Step 'Add checksum'
  206. VFS - Parameters in Transformation/Setting/Parameters
  207. Email messages input - Error: "A11 BAD Could not parse command"
  208. STEP : Add a Checksum
  209. Metadata Injection Accepting rows from source Step
  210. Text File Output: run as command - error handling (exit code)
  211. Transformation is not getting opened
  212. Does Spoon not let go of Db connections when a transformation fails?
  213. Controlling Database Connections
  214. Email messages input - Mark read?
  215. Excel Writer Memory Consumption
  216. Using CombinationLookup programmatically
  217. anyone in education using the Community Edition?
  218. JS File Functions getShortFilename/getParentFoldername don't work
  219. Oracle Hints in Table Input step
  220. Run Kettle job for each row & postprocess
  221. Hashcode calculation in Javascript Step or UDJC
  222. value Mapping step "Default upon non-matching", how do you set it to null?
  223. Environment Variables being dropped
  224. Sort rows, type conversion error. pentaho 4.2.1
  225. Filtering in Google Analytics Input step in PDI
  226. random exceptions when using JSON input
  227. Javascript Escaped Sequences
  228. Text file output: speed of stdout/stdin to bulk loader
  229. Data selection / validation question
  230. Pentaho repository : create new repository into MySQL without GUI
  231. Salesforce Input - Variable in Date Field?
  232. Excel Ouput to different Sheets in same transformation
  233. problem with Kitchen.sh
  234. JavaScript Boolean Problem
  235. Searching for Text
  236. JDBC and Vertica Analytic Databas
  237. Lookup Requirement
  238. Variable for the absolute pathname of the repository?
  239. Dynamic creation of a table in mysql DB using kettle ..?
  240. How to do this kind of data intergration?
  241. Job runs fine in Spoon but not in Kettle - Exceeds 64K in Json Input step
  242. Insert/Update issue -- transformation never completes
  243. Insert/Update and Update both drop columns
  244. Google Analytics Plugin getting Bad Gateway?
  245. need help doing a nested sql statement
  246. kettle java api inquiry
  247. Add XML Step UTF-8 Encoding (é) Plus CRLFs needed in output
  248. Best Practices to migrate PDI job from Dev to Prod
  249. Which type of kettle step to be used to split values of an column?
  250. java.lang.OutOfMemoryError and CSV files