ETL Project Plan

Index Changes

ETL Service Engine	Resource	Target Date	% Completed
Install , deinstall service engine as a jbi component	Sujit Biswas	07/10/06	100.00%
Deploy , Undeploy SU/SA	Sujit Biswas	07/16/06	100.00%
Invocation of ETL Service (Service Endpoint) using either httpsoap binding component or bpel se	Sujit Biswas	07/25/06	100.00%
Starting ETL engine process from within JBI container	Sujit Biswas	07/30/06	100.00%
Support the com.sun.etl.engine.spi.DBConnectionProvider SPI	Sujit Biswas	08/04/06	100.00%
Junit Test cases	Sujit Biswas	09/15/06	5.00%
Test driver for ETLSE	Sujit Biswas	09/22/06	50.00%
Vacation (9/25/2006 â 10/5/2006)	Sujit Biswas	10/05/06	0.00%
Support jndi javax.naming.InitialContext for looking up javax.sql.Datasource	Sujit Biswas	10/15/06	Not Required
Concurrent processing of Service Invocation.	Sujit Biswas	10/15/06	100.00%
Design doc for ETLSE	Sujit Biswas	10/15/06	100.00%
Initial support is for Request-Reply kind of Message, In future support rest of the Message Exchange Pattern (MEP)	Sujit Biswas	10/30/06	100.00%
JMX support for standard and extended Mbeans for jbi component.	Sujit Biswas	10/30/06	100.00%
Provide Runtime Configuration Mbean Support	Sujit Biswas		100.00%
Enhance ETL engine capability to pickup runtime time attributes like Axiondb Working Dir and Axiondb Instance Name	Sujit Biswas		80.00%
Plugin ETL monitor Server, provide/create configuration info ( like appName, collab, axion tables) that goes into each of the ETL Monitor Info	Sujit Biswas		100.00%
Support wsdl ( operations ) with varying message intput parameters and output parameters	Sujit Biswas		100%
Provide thread pooling in the SE	Sujit Biswas		100%
Write functional spec and design doc	Sujit, Srini		80%

ETL Monitoring ( WepApp)	Resource	% Completed
Clean build.xml of any etl 511 dependency. It should build with respect to Alaska. The webapp should not depend on any lib apart from maverick.jar	Sujit Biswas	100.00%
Java code cleanup(no 511 dependency) , implement the util class wherever required, build and deploy etlMonitor.war (test)	Sujit Biswas	100.00%
Use MbeanServerConnection ( for rmi jmx Connector) to talk to the server side, This will decouple the client from the server. Note the current 511 client Impl use MbeanServer which will only work if the client and server runs in the same JVM	Sujit Biswas	100.00%
Disable CAS ( Central Authentication Service) for the demo , as it depend on the login module from 511	Sujit Biswas	100.00%
Provide the index page which shows the list of ETL monitoring mbeans , user shd be able to browse to individual mbeans details from this page	Sujit Biswas	100.00%
Enable CAS if required, with implementation of authentication module OR provide a simple login page and login module (using JAAS)	Sujit Biswas

ETL Monitoring (Server)	Resource	% Completed
Create a new project , build.xml, with the set of monitoring mbeans from 511. The project will create etlMonitor.jar	Sujit Biswas	100.00%
Clean the code from any kind of 511 dependency, The project should only depend on Axiondb and Axiondb-query. Implement the utility classes where ever required	Sujit Biswas	100.00%
Plugin the monitor ( server) into ETLSE. Some ETL Mbean config info will change with respect caps/jbi	Sujit Biswas
Use ManagementFactory.//getPlatformMBeanServer//() so we can leverage the standard RMI JMX connector used by Sun Java Application Server	Sujit Biswas	100.00%
If ETLSE is used outside the Sun Java Application Server, the JMX Agent( need to implement) should be able to start JmxConnectorServer on a user defined port, so our wepapp will be able to consume the service given the connection URL	Sujit Biswas	100.00%

ETL editor	Resource	Target Date	% Completed
Integrate ETL Creation Wizard with New ETL File Action and generate .etl file.	Karthik S	07/24/06	100.00%
Create ETL MultiView editor with source and design view to edit .etl files. Source view changes to reflect design view.	Karthik S	07/30/06	100.00%
Fix automap/primary key mapping problem	Karthik S	08/04/06	100.00%
Add new file type/ mime-type _engine.xml	Karthik S	08/04/06	100.00%
For the above file type add new action âgenerate wsdlâ ( which convert engine file to wsdl file) and update the etlmap.xml	Karthik S	08/04/06	100.00%
To use default Dataloader for given file type/ mime-type instead of wsdl Dataloader	Karthik S	08/04/06	100.00%
Install ETL Data Loader before default netbeans XML Data Loader.	Karthik S	08/10/06	100.00%
Generate .engine file while saving etl collab. - Phase 1	Karthik S	08/11/06	100.00%
Refresh the Project Element node immediately after the engine file is generated.	Karthik S	08/16/06	100.00%
Persist the changes in collaboration between UI Focus change and enable âSaveâ Button when collaboration is edited.	Karthik S	08/18/06	100.00%
Allow the user to delete Source/Target Tables from the collaboration.	Karthik S	08/21/06	100.00%
Fix Back/Next button in Wizard causing multiple entries under Selected/Available Database	Karthik S	08/21/06	100.00%
Add action to âRemove Target Databaseâ button in the Wizard.	Karthik S	08/21/06	100.00%
Generate .engine file during deployment â Phase 2	Karthik S, Sujit	09/22/06	100.00%
Code cleanup/Refactor , remove all deprecated classes like ETLViewManager...etc	Karthik S, Ahi	10/15/06	100.00%
Integrate Flat file with netbeans db explorer	Karthik S	10/30/06	100.00%
Change the new ETL File Wizard steps to enhance user experience.	Karthik S, Nilesh, Srini		100.00%
Make Source/Design View Editor Toolbar location consistent.	Karthik S	08/29/06	100.00%
Refactor Codegen to remove netbeans API dependency to enable build time engine file generation.	Karthik S, Sujit		100.00%
Persist New ETL Wizard window dimensions between different steps.	Karthik S		100.00%
Add new flatfile database menu with create flatfile db, table, view objects	Karthik S		100.00%
Add drag and drop tables support from netbeans db explorer	Karthik S		100.00%
Integrate the Print Action with netbeans default print button	Shankari		100.00%
Integrate Undo Redo actions with netbeans default buttons.(TODO : Do not replace Undo/Redo buttons. Use context sensitive undo/redo actions for ETL)	Shankari		100.00%
Provide user with option to configure collab deployment parameters	Karthik S		100.00%
Provide select table action to the corresponding button	Karthik S		100.00%
Fix Runtime db model default value of input params	Karthik S		100.00%
Adding Junit/unit test cases	Karthik S
Write functional spec and design doc	Karthik S, Srini
Custom Operator enhancement and the corresponding changes with etl engine	Srini		100%
Integrate ETL Run action with Netbeans Run button.(same for Undo/Redo)	Karthik		50%
Use Netbeans progress Button	Karthik		100.00%
Provide navigation buttons in Show Data panel	Karthik		100.00%
Allow Editing the data and committing back to the database in Show data panel	Karthik		100.00%
Remove the existing output window and integrate with Netbeans output window	Karthik		Cannot be done with existing netbeans API Support
Persist Flatfile wizard dimensions between different steps	Karthik		100.00%
Enhance Flatfile Viewer to display the data along with the meta data	Karthik		0%
Provide support for Java DB.(add new database evaluators for Java DB)	Karthik		100.00%
Register the ETL Data object in the Lookup and use this lookup to get the data object corresponding to the active top component	Karthik		100.00%

ETL Project	Resource	Target Date	% Completed
ETL Project build time ( using custom ant task) , generate etl engine file for each etl definition file.	Sujit Biswas	09/22/06	100.00%
ETL Project build time, generate wsdl file for each etl engine file.	Sujit Biswas	09/22/06	100.00%
Generation of wsdl template, jbi.xml template etc.	Sujit Biswas	09/22/06	100.00%
ETL Project build time, create an entry in etlmap.xml file which relates a etl engine file to etl partnerlink, porttype and operation.	Sujit Biswas	10/15/06	100.00%
ETL Project build time, create entry for each etl engine file in jbi.xml of etl service unit.	Sujit Biswas	10/15/06	100.00%
Bundle etl engine files, etl engine wsdl files, etlmap.xml and jbi.xml to etl service unit.	Sujit Biswas	10/15/06	100.00%
Integration of the ETL Project bundle with composite app deployment.	Sujit Biswas	10/30/06	100.00%
Provide the user an option to modify the connection definition during project build.	Sujit Biswas		100.00%
Provide user with option to configure collab deployment parameters in editor, the engine file generation has to take care of the env params in project	Sujit Biswas		100.00%
Wsdl file generation should depends on the input and output params	Sujit Biswas		100.00%
Write functional spec and design doc	Sujit Biswas, Srini
Adding Junit/unit test cases	Sujit Biswas

Axiondb	Resource	Target Date	% Completed
Migrating axion from commons-logging to jdk logging.	Srini		80%

Etlse plugin for Composite Application Manager	Resource	Target Date	% Completed
Create a webapp based on Woodstock/JSF , which has similar functionality as our ETL Monitor	Sujit Biswas		90%
Plugin the webapp to CAM	Sujit Biswas

Go back to ETLSE

This page (revision-23) was last changed on 01-Oct-07 12:37 PM, -0700 by MarkWhite.
This page was created on 17-Nov-06 01:58 AM, -0800 by AhiSathapathy.

More info...

Pagination: previous 1 2 all (Total items: 23)

Version	Date	Author	Size	Changes ...
23	01-Oct-07 12:37 PM, -0700	MarkWhite	10815	to previous
22	25-Sep-07 15:12 PM, -0700	VitadOmacp	10823	to previous \| to last
21	27-Feb-07 03:07 AM, -0800	karthikeyan	10799	to previous \| to last
20	31-Jan-07 11:01 AM, -0800	sujit	10619	to previous \| to last

Pagination: previous 1 2 all (Total items: 23)

G'day, Anonymous Guest

JSPWiki v2.4.100

« Home Index Changes Prefs

This page (revision-23) was last changed on 01-Oct-07 12:37 PM, -0700 by MarkWhite