Share

KETL

Code

Programming Languages: Java

License: GNU Library or Lesser General Public License (LGPL), GNU General Public License (GPL)

Repositories

browse code, statistics, last commit on 2009-09-03 svn co https://ketl.svn.sourceforge.net/svnroot/ketl ketl

Show:

What's happening?

  • KETL

    sjaini committed revision 439 to the KETL SVN repository, changing 1 files.

    2009-09-03 23:21:25 UTC by sjaini

  • Followup: RE: What ImpSkills do I need to focus on for KETL

    Skills wise, a reasonable understanding of XML. I would recommend using eclipse as you can edit the xml in the java perspective and run the console at the same time in one single environment. Though if you are not familiar with eclipse, eclipse itself might be daunting. Basic parallel flow of KETL is as follows. Job Reader Step Can start as a single thread, i.e reading a single file...

    2009-05-23 21:24:24 UTC by nwakefield

  • Followup: What ImpSkills do I need to focus on for KETL

    Yes, you are right! This is one is really pretty simple and good start. I am able to work with most of the examples, But trying to develop new SQL,XML,OS executors. I am just trying to simulate a lot complex transformations. Is there any particular syntax guide for developing these XML jobs or I should be fine If I am good with regular XML stuff. What core skills do I need to have to develop...

    2009-05-23 20:06:05 UTC by shabs82

  • Followup: RE: Unable to get Server status using ctl_ketl

    in the examples folder that are a load of examples. I would start with the simple_star example and then have a look at the individual examples. A good test job is the sequenceGenerator.xml try doing run examples/xml/sequenceGenerator.xml It will test the throughput of your system and that the java compiler is working.

    2009-05-23 08:33:48 UTC by nwakefield

  • Followup: RE: Error while opening Administrative Client

    I would probably use ketl_ctl.bat, not the GUI client. The GUI client is best used for monitoring. If you start with the console I'll be able to get you going. What sort of ETL are you trying to do?.

    2009-05-23 08:30:54 UTC by nwakefield

  • Followup: RE: Unable to get Server status using ctl_ketl

    TNAME TABTYPE ------------------------------ ------- ALERT_ADDRESS TABLE ID_GENERATOR TABLE JOB_ERROR_HIST TABLE JOB_EXECUTOR TABLE JOB_LOG_HIST TABLE JOB_QA_HIST TABLE JOB_STATUS TABLE JOB_TYPE TABLE...

    2009-05-23 08:05:22 UTC by shabs82

  • Followup: RE: Unable to get Server status using ctl_ketl

    Actually, There were couple of minor bugs in the Metedata Scripts of oracle. I fixed them and ran the scripts ....now it is creating the table JOB. I would really appreciate if you could point me some developer guide and XML step guides or whatever to get start on...... Shabs.

    2009-05-23 08:04:11 UTC by shabs82

  • Error while opening Administrative Client

    Hi Nicholas, Would you please help me in advising on the below error while running the Administrative client? I did the following 1) Downloaded and installed the Admin Client 2) Downloaded and installed Tomcat 3) deployedthe KETLWS.War to web apps folder within tomcat and started the tomcat. 4) started the admin client Here in admin client... I hope I should provide the details of...

    2009-05-23 07:58:07 UTC by shabs82

  • Followup: RE: Unable to get Server status using ctl_ketl

    Unusual, sounds like the metadata tables do not exist. Can you send me the result of select table_name from user_tables for the user name and password you have specified in the ketl servers file.

    2009-05-22 19:19:54 UTC by nwakefield

  • Unable to get Server status using ctl_ketl

    ->connect [INFO]Fri May 22 12:04:44 PDT 2009 - [Thread[KETL Console,5,main]] Metadata conn ection established to a Oracle Version: 10.1 Database, using Driver Version: 10. 2 as 'KETLMD'. Connected to Shabarik ->status [ERROR]Fri May 22 12:04:56 PDT 2009 - [Console] Error:java.sql.SQLException: ORA -00942: table or view does not exist.

    2009-05-22 19:07:34 UTC by shabs82

Our Numbers