column-data-type-to-kettle-type Normal 0 / ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELDEXECUTING_SERVERNEXECUTING_SERVEREXECUTING_USERNEXECUTING_USERCLIENTNCLIENT ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATEMETRICS_DATEYMETRICS_DATEMETRICS_CODEYMETRICS_CODEMETRICS_DESCRIPTIONYMETRICS_DESCRIPTIONMETRICS_SUBJECTYMETRICS_SUBJECTMETRICS_TYPEYMETRICS_TYPEMETRICS_VALUEYMETRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2015/02/28 21:50:23.041 - 2015/02/28 21:50:23.041 Links: --------- How to get from DATA_TYPE integer value to java.sql.Type: http://docs.oracle.com/javase/7/docs/api/constant-values.html#java.sql.Types.ARRAY How to get from java.sql.Type to java type: http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html (look for TABLE B-3 Mapping from JDBC Types to Java Object Types, p 192) How to get from java object type to kettle data type: http://wiki.pentaho.com/display/EAI/PDI+Rows+Of+Data 13 143 591 214 Ubuntu 11 N N 0 0 0 255 205 112 100 100 100 Y AgileBI localhost MONETDB Native pentaho-instaview 50006 monetdb Encrypted 2be98afc86aa7f2e4cb14a17edb86abd8 true EXTRA_OPTION_INFOBRIGHT.characterEncodingUTF-8 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue PORT_NUMBER50006 PRESERVE_RESERVED_WORD_CASEY SUPPORTS_BOOLEAN_DATA_TYPEY SUPPORTS_TIMESTAMP_DATA_TYPEY sakila localhost MYSQL Native sakila 3306 sakila Encrypted 2be98afc86aa7f2e4cb79bd71d59ba3db EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 PRESERVE_RESERVED_WORD_CASEN QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEY SUPPORTS_TIMESTAMP_DATA_TYPEY USE_POOLINGN Generate RowsJDBC Columns MetadataY JDBC Columns MetadataJDBC datatype -> Kettle data typeY Generate Rows RowGenerator Y 1 none 1 N 5000 now FiveSecondsAgo

41 57 Y JDBC Columns Metadata jdbcMetaData Y 1 none Connection sakila N getColumns N N TABLE_CAT TABLE_CAT TABLE_SCHEM TABLE_SCHEM TABLE_NAME TABLE_NAME COLUMN_NAME COLUMN_NAME DATA_TYPE DATA_TYPE TYPE_NAME TYPE_NAME COLUMN_SIZE COLUMN_SIZE BUFFER_LENGTH BUFFER_LENGTH DECIMAL_DIGITS DECIMAL_DIGITS NUM_PREC_RADIX NUM_PREC_RADIX NULLABLE NULLABLE REMARKS REMARKS COLUMN_DEF COLUMN_DEF SQL_DATA_TYPE SQL_DATA_TYPE SQL_DATETIME_SUB SQL_DATETIME_SUB CHAR_OCTET_LENGTH CHAR_OCTET_LENGTH ORDINAL_POSITION ORDINAL_POSITION IS_NULLABLE IS_NULLABLE SCOPE_CATALOG SCOPE_CATALOG SCOPE_SCHEMA SCOPE_SCHEMA SCOPE_TABLE SCOPE_TABLE SOURCE_DATA_TYPE SOURCE_DATA_TYPE IS_AUTOINCREMENT IS_AUTOINCREMENT IS_GENERATEDCOLUMN IS_GENERATEDCOLUMN

226 57 Y JDBC datatype -> Kettle data type ValueMapper Y 1 none DATA_TYPE Kettle Data Type 2003 -5 Integer -2 String -7 Boolean 2004 String 16 Boolean 1 String 2005 String 70 Internet Address 91 Date 3 BigNumber 2001 8 Number 6 Number 4 Integer 2000 -16 String -4 String -1 String -15 String 2011 String 0 2 BigNumber -9 String 1111 7 Number 2006 -8 5 Integer 2009 String 2002 92 Date 93 Timestamp -6 Integer -3 String 12 String

443 58 Y N