-
sjaini committed revision 439 to the KETL SVN repository, changing 1 files.
2009-09-03 23:21:25 UTC by sjaini
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
->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