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. CSV Text File to Long
  2. USER DEFINED JAVA CLASS:error
  3. Json Input Parsing error in PDI
  4. pentaho insert/Update v/s table output
  5. How to show the percent symbol in output.
  6. Variable not updated in loop
  7. Extract from pdf to MySQL?
  8. [SCRIPT] java.lang.ArrayIndexOutOfBoundsException: 1
  9. Execute SQL Script
  10. Parsing date EST vs EDT
  11. Lookup based on logical conditions
  12. Handling errors in a bad CSV formated file
  13. 2012/03/18 15:15:37 - PokerStarsInitialLoadv2 - This is not a replay transformation
  14. pentaho spoon get file from a field name (SFTP with variables)
  15. MS Excel Setup
  16. Table Output Setup
  17. Pulling information from multiple databases
  18. Procedure Data Integration
  19. Database Lookup fails on timestamp field
  20. Tranformation hangs with the "merge joins step"
  21. excel output password protect not working
  22. How to execute a job on a cluster using kitchen?
  23. Error coming for Table input and dynamic sql row in v4.2.1
  24. Import file excel and join two columns
  25. Insert/Update
  26. How can a table input step start, but do nothing?
  27. Errors Detected
  28. Proxy Connection
  29. Problem with Date Format in Oracle
  30. Import utility before PDI 4.2
  31. Accessing fields un-used in a mapping step in the prior steps
  32. HELP!!! How to create DBF output file ?
  33. Please suggest the best way to extract information from remote server
  34. convert dd.mm.yyyy to yyyy-MM-dd 00:00:00
  35. internal ms exchange to external email address
  36. Split rows
  37. Problem joining two databases exports
  38. Data Cleaning and Validation
  39. Split a Record into 2 records
  40. Run a Kettle Job through Java Code
  41. Only process the files we haven't processed yet from ftp server?
  42. converting dot IP notation to decimal.
  43. mysql error looking up row in database
  44. Transformation Logging to DB
  45. infobright loader step gives the following eexception on linux
  46. How to read a kind of special Text file!?
  47. Update/Insert/delete PistGIS tables
  48. Nested PostGIS tables
  49. Shifting excel content
  50. Setting and Accessing Variables
  51. adding escape charecters in the text file output
  52. Scan folder for files
  53. Getting concurrent modification exception in Pentaho kettle job
  54. UDJC setVariable method scope
  55. Email Transformation Step
  56. How does this User Defined Java Expression work ?
  57. PDI 4.2.0 - Using Pan with Repository Files
  58. Problem with data cleansing - group by / merge join
  59. Experimental Steps safe tp have in Production
  60. Unable to release database transaction savepoint in 4.2.1
  61. Refresh in Table output dosent seem to be working
  62. Excel output - Template
  63. a web page hang up after call KettleEnvironment.init
  64. Authentication in Carte
  65. Add filenames to result - first file only??
  66. Not working fine if we importe 3.2 repository into 4.2.1 stable version
  67. Question about DW modeling - dimension date
  68. Null values not being handled in PDI 3.2 SQL Join step
  69. Using an Oracle Sequence on Insertion of Data
  70. Moving text files to another folder once processed
  71. Plugin to retrieve data from table A which is not in table B
  72. Can I run multiple version of Kettle - Spoon at the same time?
  73. Loop over fields in a MySQL table to generate csv files
  74. Count of incoming hops in Javascript entry
  75. Pass job entry name to an email step
  76. Database lookup fails in case of Oracle with timestamp columns
  77. Extract non-delimited continous fields with different lengths
  78. Generating Conflict in User Console
  79. Two repositories in one database ?
  80. Calculator and Hex Values
  81. Pan & Kitchen not working on UNIX?
  82. Porting a database repo to file based
  83. error launching Translator
  84. Double delimiters and enclosures
  85. Pentaho BI Platform reported an error while running an action sequence
  86. Where can I find pdi-ee-client-4.2.1-GA
  87. Constraint (parent-child) based loading in PDI
  88. how to improve ETL performance
  89. how to improve ETL performance
  90. variables stored in table
  91. Parse a Complex Log File
  92. Handling rowSet(s) in UDJC
  93. how to find last day of the previous month of a given date?
  94. Basic hierarchical data: ability of Pentaho to handle
  95. performance question
  96. Text file input misreading decimals x group? [SOLVED]
  97. Skipping lines on Text file input?
  98. Disabling keys/indexes before bulk load
  99. Java Plugin: Transformation that doesn't end
  100. Execute all transformations in a directory in parallel
  101. Kettle Shell step not waiting
  102. Number field has decimals, but no symbol... Workaround?
  103. Kettle into other programming programs
  104. Problems with connection
  105. how to create the target table dynamically
  106. Parsing XML with "Get XML Data" - Get attributes in nodes with same name
  107. LDAP output step
  108. PDI v4.3
  109. "CREATE VIEW" won't work on SQL Job Step
  110. Studying the applicability of MDM concepts to startup/small biz
  111. Removing leading zeroes
  112. Adding Pentaho Kettle Libs to a map/reduce job in Cloudera cdh3u3
  113. Calling Pentaho job from within Java
  114. Launching a Transformation every X seconds
  115. Transformation as Axis Web Service to run in AppServer
  116. Need help for transformation please :-(
  117. Problem in using kettle transformation as PRD data source
  118. Executing Job in an action sequence
  119. Trouble with total number of connection in a kettle process
  120. Timestamp loosing precision
  121. Kettle API running a job.
  122. Parellel Process
  123. Global Variables
  124. Set Transformation Parameters from commandline in Windows (Pan)
  125. Loads incremental data from a table of one database to table of another
  126. How to deploly kettle job on client linux machine
  127. Massive Load Data (6 files of 800,000 records)
  128. Excel Input Step Documentation
  129. New blog about Pentaho and Postgre
  130. Exception handling in transformation
  131. log4j errors with soapcall step
  132. SFTP Get: Retrieve Most Recent File
  133. How to use pdi-ce-4.2.1-stable.zip?
  134. Variables not being set on parent job...
  135. Can the following trasnform be done...
  136. How to handle the error "Windows cannot find 'javaw'... when installing PDI?
  137. EBCDIC troubles
  138. Performance Tuning My whole PDI Process
  139. DB connection - SQL Server error
  140. Facing problem with update step for sybase 15.0.3, kettle 4.2.1-stable version
  141. Transformation logic
  142. Mongodb - Retrieving a Subset of Fields
  143. Extraction Partitioned
  144. How to Pass Arguments to org.pentaho.di.trans.Trans.execute()
  145. java.lang.OutOfMemoryError: GC overhead limit exceeded
  146. "DROP TABLE IF EXISTS" suddenly stop working?
  147. CSV file input
  148. Blocking a set of steps
  149. Extracting month from a date column
  150. Logs being cleared in carte
  151. HTTP Post Exception even with 200 OK response.
  152. Error with Carte
  153. File with different kinds of registers not loading properly...
  154. Kettle version 4.2.1 Excel input doesn't list xlsx as valid format
  155. "merge join" vs "sql - inner join" - different behaviour
  156. Unexpected problem reading shared objects from XML file : null
  157. How to transpose columns to rows (transpose table) with number of columns unknown?
  158. SQL step doesn't work for deletions ?
  159. How to Join/lookup in SAP Input step.
  160. CSV file import Performance issue
  161. Change the default notes color
  162. Merging fields?
  163. multiple source files with wildcard
  164. passing dynamic file names to XML Input Stream
  165. Can't find MySql procedure in production
  166. Move a file into a folder
  167. Web Services
  168. Trigger Based CDC
  169. Problem with mail
  170. Problem with Netezza connection
  171. secure repository
  172. 4D (or generic database) ODBC connection issues
  173. Save into repository strange behavior
  174. adding fields to output
  175. help with "unexpected error during transformation metadata load"
  176. Square brackets in filed names in "Modified Java Script Values"
  177. Text Input With Repeated Pattern of Data
  178. Emailing Job/Transform Failure Reason
  179. Merging 3 or more datasources
  180. Identical CRC32 code for different data
  181. PDI and MonetDB
  182. Table Output
  183. Is there a Step that extracts substrings from a text field?
  184. Sent mail with false account
  185. Data Manipulation with Java Script Step
  186. Help implementing MergeJoin
  187. Loading data into report
  188. How to schedule Job in Kettle
  189. Spoon does not launch at Win 7/64-bit
  190. Kettle v4.2.1 userguide
  191. Classification. Data set.
  192. Text file outuput for Table Input with Select * from Table
  193. What tool should i use for my project ? Need directions !!!
  194. Oracle Bulk Loader: I think I'm missing something?
  195. Triggering Bi-Reports with kettle
  196. String index out of range: 1
  197. Problem with plugins directory access running a job from Java code
  198. Data Integration
  199. Editing a file in a same transformation
  200. Filtering files in a folder
  201. Discarding non matching rows from 2 inputs
  202. What should require change to transfer job from Test to Production database
  203. Current date as Job variable?
  204. AddSequence start at value 6610570460000000 gives error ORA-00904: invalid column
  205. Unable to start spoon.sh on linux
  206. CSV File with field with "" (enclosure)
  207. [SOLVED] Spoon fails to startup on linux
  208. org.eclipse.swt.SWTError: XPCOM error -2147467262
  209. Can a KTR exposed as Service?
  210. Writing Array Elements from JS to Output
  211. KETTLE using mysql myisam storage engine
  212. Remove column using user defined java class
  213. help with processing multi files
  214. How to migrate tables with foreign keys in Pentaho Kettle
  215. Type II dimension unexpected behavior / possible bug
  216. Generic ODBC connection to 4D: "Driver not capable" error
  217. Error "you need to specify Database connection " "Error initialize step"
  218. Trying to use "if" statement in User Defined Java Expression step
  219. Data Profiling (DataCleaner) & Data Quality with Kettle
  220. Get "Out of Memory" Every 3rd or 4th Time I Run a Preview (F10) on My Transformation
  221. Dynamically generate fields for text file output
  222. Salesforce Input - SOQL Join (Specify query)
  223. Simple Validation after FTP job step
  224. issue with data validation with date conversion mask
  225. Repository: DB x FS
  226. The difference between ‘ Copy file’ and steps in file transfer
  227. Recode fields within a transformation
  228. dimension lookup error with mysql 5.6 (
  229. Flow, CDC
  230. Pdi 4.2.1
  231. JDBC Driver 'opt-in' downloader
  232. error while loading : No repository provided, can't load transformation.
  233. Reading Currency Values Formatted as Strings and Need to Convert to Decimals
  234. Pentaho Report File Output Issue "Unexpected Error"
  235. Change the output field name
  236. Null If Option in Row Denormalizer
  237. Checking more complex conditions
  238. get FTP file job step timeout seems more like milliseconds than seconds
  239. User Defined Java Class
  240. Issue while doing web service lookup to HTTPS/ SSL site
  241. Oraclette
  242. Spoon Crashes :(
  243. Spoon Not Launching on CentOS 5.8 GNOME
  244. Deleting not exists rows among different db
  245. Putting files to Webdav
  246. multi-file processing
  247. Improve performance with large number of columns
  248. Spoon taking an obscenely long time when I click file -> open...
  249. copy/export Schedule-Plan
  250. 'Web services lookup' step fails in case of HTTPS