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 filter emails by Subject
  2. Checkpoints
  3. Access to Cassandra
  4. Initialize variables at start of job/transformation
  5. Table compare of data between Two database servers for migrated or upgrade
  6. How to avoid existing records in output table?
  7. Assigning dynamic value to maximum errors in oracle bulk loader
  8. commit or rollback based on sql loader return code in a single transformation !!
  9. XML file to csv
  10. XML read and join 2 tables
  11. Shell Doubt
  12. Create cross tab (flatten rows)
  13. data cleaner error
  14. Serialize to file and De-serialize from file steps
  15. Dynamic Date as Parameter
  16. Migrating Jobs and Transformation from one server to another
  17. What's the biggest bottleneck (time) in writing data to a SQL database?
  18. Pentaho Integration with GA
  19. How do we migrate data from MongoDB to Oracle using Pentaho ?
  20. Random error with MySQL Plugin
  21. Database Lookup usage/Conditional flow
  22. Add Calculated Fields to stream
  23. Data type of Variables in PDI
  24. CR and LF substituted in 5.3.0
  25. Buiilding pentaho-kettle - build failure
  26. Rest Client No Check Certificate
  27. get email with TLS
  28. Shell script always directs to "failure" hop
  29. Google Analytics Authentication Issue
  30. Is there any way to make Input Table Dynamically?
  31. PDI 6.0 - dataservice ok in spoon, not visible as table with Carte
  32. Data Error Handling - best practices
  33. can i run ce edition on a linux server?
  34. How to truncate tables decided dynamically
  35. Set variable and metadata injection issue.
  36. Select Excel files filtering creation date
  37. Empty space in output text file
  38. Export BLOB from SQLite database
  39. Remote execution of tranformtion using Carte
  40. get date 3 days ago
  41. Wrong value returned with data with XML
  42. Subtransformations and parameters
  43. In PDI 4.4.0 how to loop 10 or 20 rows ata time over the result of a Table input step
  44. Call a Netezza Procedure using Pentaho Call DB Procedure??
  45. Error while opening Job or Transformation
  46. Unable to connect to Mongodb from PENTAHO DI tool
  47. datetime
  48. DI Server in Community Edition
  49. Excel template -Value showing decimal
  50. How to load multiple csv files into different table in a transformation
  51. Accept java parameters in Pentaho transformation
  52. Kitchen.sh issue: Unknown error in KarafBlueprintWatcher
  53. Pointless Data Services feature in Community Edition
  54. DB Clean Up when a job gets interrupted/killed
  55. Newbie question about environment initialization
  56. API to get the process of current job
  57. HTML to plain text conversion
  58. checkpoints in jobs heirarchy
  59. Geookettle - 'group by' step and geometries
  60. PDI kettle user interface issue in Linux (Example: Database Value Lookup step)
  61. Insert XML to MySQL (same attributes)
  62. Insert or update text files in HDFS
  63. Clean Up Memory after a csv input loading into database
  64. Job Scheduler Tool
  65. Carte charset trouble
  66. Pentaho reporting output encoding issue
  67. Is it posible to use Palo as a Molap motor through PDI?
  68. Field Validation
  69. PDI log4j.xml for debugging custom steps plugins
  70. Call endpoint step question
  71. How to Zip files using Zip Utility
  72. Adding columns from another table.
  73. Merging data after Denormalizer
  74. Pentaho reporting output error with processor: PDF
  75. Regarding migration
  76. Add next step after output step
  77. HTTP file download results in empty file
  78. Splitting unstructured data in a column to multiple field.
  79. one template that can be used for multiple mappings
  80. Undeclared variable: $ issue in pdi-ce.5.3
  81. Binary File
  82. Date incorrect when stored in ORacle
  83. Performance issue while processing 100 ML records from DB to File
  84. query result search with input data
  85. Stop a transformation
  86. XML Output conditional tag
  87. How to use variable in Database Lookup
  88. acebook using PDI
  89. Stable version for PDI
  90. java options difference in PDI-CE-5.3
  91. Updating data in a Mondrian scheme created with the data source wizard
  92. Split field to rows delimiter "; "
  93. PDI 6.0 Unable to connect via Netezza Driver
  94. Calling SQL stored procedure
  95. how to set kettle variables values using sql script
  96. Not able to access sharepoint list data in pentaho ?
  97. Clear argument setting before execution
  98. Why is Pentaho Data Lineage wiki page not available?
  99. is it possible to iterate the JOB using PDI
  100. Error in Execute SQL script statement
  101. Sending binary content in Mail step
  102. PDI - RESTClient - error message
  103. org.apache.karaf.main.Main launch INFO....version 6.0
  104. How to use WEKA filter in Kettle transformation?
  105. CPU usage while running ETL's
  106. Warning: Data-Set does not contain a column with name...
  107. Not able to retrieve tables from Vertica through pdi 5.0.1
  108. Do GARBAGE COLLECTION manually in PDI - Kettle
  109. timezone setting in PDI-CE-5.3
  110. Other ways to reach PDI Marketplace?
  111. Strange Error in PDI Job
  112. how to break out of the row processing main loop
  113. Copy Tables Wizard - bug
  114. convert two tables into a cube - how?
  115. Pentaho 5.4.0 with MapR 4.1.0 - creating shims
  116. How to use Kitchen
  117. Import & export JSON message from blob in Hbase colum
  118. Split transformation to Success or Failure depends on query result
  119. Ignore rows with foreign key issues
  120. LDAP Input return result when not found user
  121. REST Client not working with biserver 6.0
  122. HTTP Post Soap Envelope Error
  123. Error sqoop import from Postgres to hive hadoop
  124. parameters in sub mapping step
  125. If Shell Error then Abort Job
  126. Delete process for DB connections
  127. Pentaho - Spoon 4.1.0 Import/Export repository - Jobs and translations
  128. How to create a Transformation Parameter like a curdate() sql command?
  129. Kettle Job Log - Needs sorting
  130. Problem with merging 2 sources into one output table
  131. NPE on PDI 6 with Excel Input
  132. Json Input and Variables
  133. PDI 6.0.0.0-353 - error when starting job from shell
  134. Sometimes Error "Unexpected error during transformation metadata load" in CARTE
  135. Pentaho 6 repo password
  136. Carte queueing
  137. Not able to process 4300000 records
  138. spoon - receiving error connecting to mssql database
  139. Delete or replace line breaks on excel
  140. kettle - changing column names between input and output tables
  141. data integration - converting mssql datetimestamp to posgresql timestamp
  142. Run Python code from Kettle PDI
  143. Denormalizer Attribute
  144. Double Byte issue with CE 6.0 Repository
  145. EDI x12 Output step
  146. Delay from load repository and allocate job
  147. Ignore or delete a row when a field is certain value
  148. Newbie thoughts about trasformation
  149. Distinct Clause issue for MySQL in PDI-CE-5.3
  150. how to modify all transformations/jobs of a repository (for ex. edit all log config)
  151. Most or best step to insert or update the records
  152. converting to date problem
  153. spoon.sh crashes with webjarsurlconnection error
  154. Parquet Snappy Plugin
  155. Issues with POI while reading Excel files
  156. HTTP step with PAC
  157. Call db procedure / input parameter
  158. REGEX Check.
  159. pass db fatal connection error to syslog message
  160. JOBS: change a parameter in the call by terminal
  161. Using Metadata in a transformation
  162. processing the same records over and over
  163. how to run same transformation parallel using different jobs in PDI
  164. wait for parallel job to complete
  165. Unable to process bunch of excel workbench format files.
  166. How to load multiple xmls in oracle database using pentaho.
  167. How to compare two files using File Compare job?
  168. table Locking using Sync after merge
  169. Getting error (stderr) su: Sorry on SunOS when calling script file from PDI 4.4.
  170. Search and Order a LOG
  171. Splunk Input/Output steps
  172. Meta Injection error
  173. How to do a loop in a transformation (ktr)
  174. Getting the file name in run time dynamically from the input excel
  175. Spoon cannot explore MSSQL 2008 - Error getting views from schema [null]
  176. Text file output step corrupts the file in PDI 5.1 version !!
  177. how to load google spread sheets through Pentaho Data Integration
  178. Product Feedback -- JS and SQL scripts have the same icons now --- change?
  179. metaDataInjection in a subtrans
  180. How to disable daylight saving time
  181. Implementing CDC while reading from excel file
  182. BigData Plugin From Java
  183. Changing mask used for MS SQL input
  184. Normalizing data in a table
  185. How to handle COMP-3 Data type in Pentaho
  186. kettle does not see one value in filter
  187. spoon licence (apache licence) shoule we as company pay?
  188. Maximum of two timestamp field
  189. Data linegje in Pentaho DI
  190. Running 5.4.0.1, upgraded to Oracle 12c and now cannot connect to databases via PDI
  191. Data Validator - Filtering allowable values based on field in inputstream
  192. Checksum of large file
  193. Unable to connect to a secured Mongo Database
  194. Spoon terminates while editing javascript in LINUX machine
  195. CWM estandar in Pentaho DI
  196. Index usage while performance issue
  197. How to create multiple rows from one input row
  198. Read first line from multiple files
  199. MongoDB to Oracle
  200. ConnectWise
  201. plug in for check point feature in PDI 5.x
  202. Question about debugging jobs and transformation
  203. Question about "data validator" step
  204. Question about autodoc
  205. Text file export- Remove white spaces after each field
  206. PDI 6.0.0 Stable?
  207. Add geometry type to Kettle
  208. Error when installing pdi on Win 7
  209. Can't view Schedule perspective in Kettle (Enterprise Version)
  210. How to find kettle.properties file in UNIX machine?
  211. Command line to run jobs in unix.
  212. reading files from cobol to csv
  213. Linux: Unsupported major.minor version 51.0
  214. Pentaho Logging and Opening Files
  215. Need some help on creating & emailing excel output
  216. Is PDI 5.1 Community Version, stable ? or yet to be stable ?
  217. PDI and Log4j - category/loggers
  218. Need help connecting to Cassandra over a SSL connection - Self-signed.
  219. release database lock mechanism using pdi-ce-6.0 or below version
  220. rest client api - handshake_failure
  221. InputCSV to Textfile output
  222. Hadoop File Input with Snappy compression
  223. Upload report to BA server
  224. JobEntryWaitForSQL setNrErrors(1)
  225. Oracle BLOB, CLOB AND XMLTYPE UNSUPPORTED ON 6.0.0 VERSION
  226. How to organize the data in a excel file?!
  227. Chinese Data is not loading properly
  228. Insert/Update: Insert if not exist or update if at least one column changes
  229. Salesforce Insert/Upsert
  230. First Steps pentaho - transformation
  231. DBF process 12.000.000 rows on a sequence?
  232. Kettle - Query on date field in MongoDB input query tab
  233. Set variable from Parameter
  234. HTTP Client - Change browser signature/user agent?
  235. Upgrade from PDI 5.0.1 To PDI 6?
  236. how to give phone number format in mapping?
  237. Connect to MSSQL from Linux
  238. REST Client can't get HTTPS (AppAnnie API KEY)
  239. Get XML Data - Unknown number of Nodes
  240. Task Scheduler Causing FTP to Fail
  241. Pentaho SDK, how to define a text file input
  242. Not Able to Insert into Table having Identity Column IN SQL SERVER
  243. How to Make Connection Configurable in KTR file
  244. NULL Handling in Transformation
  245. Validation check for date
  246. Unable to read number '+002.323' with Fixed Input step
  247. PDI x Oracle Advanced Security (OAS)
  248. Pentaho Connectivity Issue with the SQL Server using Windows Authentication
  249. Kettle-Spoon 5.3 with Java 8
  250. Table Input from - Execute SQL from File