Tuesday Nov 27, 2007
Tuesday Nov 27, 2007
We have been creating instructional webinar-style videos on Java CAPS and project Open ESB for the past few weeks. These webinar videos were initially intended for weekly distribution to the Software Infrastructure Catalysts (f.k.a. Apostles) to share with their organizations, however due to popular demand we started making them available to anyone interested via ShareSpace. To help those who have not been on the distribution, we are making these videos available here on the blog. Feel free to download and share the media files.
Contributions to the videos are encouraged - let us know if you would like to contribute. And please leave a comment to let us know how we did.
This video explains the basics of Java CAPS ETL Integrator
This video explains how to use the Worklist Manager
This video shows how to invoke an external Web Service from a Java Collaboration Definition (JCD)
This video shows how to invoke an external Web Service from an eInsight Business Process
This video shows how to create a File Read - File Write sample using project Open ESB components
This video shows how to create a sample application to access Database using project Open ESB components
This video shows how to create a JSF Web application for data entry and insert records into a Database using project Open ESB components
Read more about Sun Java CAPS here.
Read more about Project Open ESB here.
Project Open ESB components can be downloaded from here.
ETL Integrator
Great video!
(1)
How to use a custom function instead of the built-in concat?
For example, I would like
the EMPNAME column to have:
last_name column
concat with comma char,
then concat with first_name column.
My last_name and first_name
columns are varchar2, variable
width, no whitespace chars.
(2)
How to use the "Insert/Update" statement type? When I tried that, I got an error about needing a merge condition.
Posted by 128.249.96.252 on November 28, 2007 at 10:32 AM PST #
1. Custom function is two step processes: Create the custom function and then import it in the eTL tool to be available as other function to be used in eTL collab.
First create a custom function which could be a store procedure in your case and define the function say concatABC.sql. The concatABC.sql will take a string from one input parameter and appended to sting to other input parameter and will return a concatenated string. Run this concatABC.sql in your database.
Second step is to import this custom function concatABC.sql in the eTL tool so that it is available in the palette along with other function to be used in eTL collaboration. Now create a custom function concatABC by selecting the userFx function from operator palette. It is very important that the name of the custom function should be match with the name of the underlying store procedure. In runtime, eTL collaboration is going to look for the function concatABC in the eTL engine layer and as it is not a predefined function in engine, it will delicate that request to database it self and look for concatABC function where it will find the concatABC store procedure and execute it .Now you can use this ‘concatABC’ custom function instead of the standard concat function.
2. 'insert/update' is used to update an existing row or append a new row, depending on the evaluation of a condition (upsert). So, you need to define that condition on the target table, which I believe you are missing and hence you are getting error.
Posted by Suresh Sharma on November 28, 2007 at 01:33 PM PST #
I just found this blog via a Google search. VERY nice demo on the ETL integrator. I'm going to try establishing a very simple one for my project.
Question: How can you provide error handling from this ETL collaboration? In the case of your example, how could you report that there are people present in the file that are not in the Employee Table?
Also, what if the source system is not available or if data in the file is not present or not a certain length. I would never want errors like this to go unnoticed.
Posted by B Glasgow on February 27, 2008 at 03:31 PM PST #
Thank you Great video
Posted by Komik Videolar on March 25, 2009 at 05:06 PM PDT #
I like watching them all the good videos, thanks
Posted by youtube on April 04, 2009 at 07:40 AM PDT #
great many thanks
Posted by video izle on April 04, 2009 at 07:41 AM PDT #
thanks
Posted by lig tv on April 04, 2009 at 07:42 AM PDT #
i like it thanks
Posted by videolar on April 04, 2009 at 07:43 AM PDT #
thank you
Posted by kral oyun oyna on April 04, 2009 at 07:44 AM PDT #
thank you my names semih i like
Posted by semih şentürk on April 04, 2009 at 07:44 AM PDT #
thanks . good video
Posted by altay on April 04, 2009 at 07:45 AM PDT #
thank you
Posted by derya baykal on April 04, 2009 at 07:46 AM PDT #
thanks
Posted by film izle on May 02, 2009 at 03:32 PM PDT #
thank you
Posted by vBulletin on May 02, 2009 at 03:39 PM PDT #
Thanks alot
<a href="http://dietcookingrecipes.com">Diet recipes</a>
Posted by diet recipes on May 02, 2009 at 03:39 PM PDT #
Thanks alot i watched the videos
http://www.youtube-muzik.com
Posted by josh on May 02, 2009 at 03:43 PM PDT #
thanks
Posted by sağlık on June 23, 2009 at 12:28 PM PDT #
thanks admins.
Posted by sağlıklı beslenme on June 23, 2009 at 12:28 PM PDT #
thnks
Posted by çizgi filmler on June 23, 2009 at 12:29 PM PDT #
altin thanks
Posted by altın fiyatı on June 23, 2009 at 12:30 PM PDT #
tbhns
Posted by evlilik sözleşmesi on June 30, 2009 at 02:26 PM PDT #
good dude goood.
Posted by saç bakım ürünleri on June 30, 2009 at 02:27 PM PDT #
goods tenks
Posted by fenerbahce on July 07, 2009 at 07:09 PM PDT #
good expression amazing tips thanks for all information!
Posted by video on July 25, 2009 at 02:13 PM PDT #
thanks admin nice videos
Posted by klip izle on October 28, 2009 at 08:19 AM PDT #
nice article thanks
Posted by izlesene on October 30, 2009 at 02:52 PM PDT #