Search found 192 matches

by slechtaj
Fri Nov 09, 2012 1:11 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Need URI from XMLWriter to HTTP connector
Replies: 5
Views: 5700

Re: Need URI from XMLWriter to HTTP connector

Hi Peter, Now I think I understand what you need. There is one component that may help you. It is component Combine (which is available in CloverETL Designer version 3.3.0). Basically it takes one record from all input records and merge them together (it maps input data to output port). Please see a...
by slechtaj
Thu Nov 08, 2012 3:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Need URI from XMLWriter to HTTP connector
Replies: 5
Views: 5700

Re: Need URI from XMLWriter to HTTP connector

Hi Peter, Let me go back to your question. You need to parse the URI out from the XML that you create in XMLWriter. Is that correct? If so, you may use the following way. If generated XML contains the URI/URL, it has to „exist“ before it is sent to XMLWriter. In this case, you can save it to diction...
by slechtaj
Mon Nov 05, 2012 10:31 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Reading Horizontally mapped excel data in Clover
Replies: 2
Views: 3058

Re: Reading Horizontally mapped excel data in Clover

Hi WilliamTell, the thing is that you are using XLSDataReader. If you would like to read data from XLS file horizontally, you should use new SpreadsheetDataReader instead, but it is not available in Community Edition. SpreadsheetDataReader offers the mapping tool you mentioned in your post. You can ...
by slechtaj
Fri Oct 26, 2012 10:24 am
Forum: CloverDX (formerly CloverETL) Support
Topic: ExtHashJoin doesn't work with large recordsets
Replies: 2
Views: 2950

Re: ExtHashJoin doesn't work with large recordsets

Hi Craibuc, When you use ExtHashJoin, you should keep in mind that this joiner cache slave data in the memory. Due to this fact, using of this joiner should be avoided in case of large inputs on the slave port. It is also the reason why you experience this issue on large dataset only. I can see, you...
by slechtaj
Fri Oct 05, 2012 4:22 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Trasformation from cols to rows
Replies: 2
Views: 3216

Re: Trasformation from cols to rows

Hi Carlo.balbo, The whole transformation may be handled by only one component. The component that could parse input data row into several rows is Normalizer. However, you need to set up this component properly. In the first phase you trim the quotation marks from Filed3. Then you can split this reco...
by slechtaj
Fri Oct 05, 2012 3:02 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Issue with Transform Component
Replies: 1
Views: 2065

Re: Issue with Transform Component

Hi Synergy,

In order to provide you with the most suitable solution, it would be very helpful to know what CloverETL version is embedded in the software you are using. Do you this it is possible to find it out provide us with this information?
by slechtaj
Wed Sep 26, 2012 12:25 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How do I extract values from list container of variable len?
Replies: 1
Views: 2897

Re: How do I extract values from list container of variable len?

Hi Sam, Basically, in order to get your data in better structured way, it would be good to load these list fields as ordinary strings. If you do it so, you can use Normalizer to split the data into more records (ID1, add1; ID1, add2,...ID1, addN). If you wish to gather these data back together into ...
by slechtaj
Mon Sep 24, 2012 1:17 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: call integrator graphs from windows batch file
Replies: 1
Views: 2564

Re: call integrator graphs from windows batch file

Hi cloveretl_novice,

it seems Clover is not able to find the workspace.prm. You should run your graph as a part of the project. Please add -contexturl <PATH> to your statement. For more information about project structure, please see Chapter 9. Structure of CloverETL Projects.
by slechtaj
Fri Sep 14, 2012 3:17 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: OracleDataWriter component support for TRAILING NULLCOLS
Replies: 2
Views: 3950

Re: OracleDataWriter component support for TRAILING NULLCOLS

Hi Pensky, you are right, this issue is caused by NULL values in the last column. For this issues has been created a ticket in our system (you can keep yourself updated here: https://bug.javlin.eu/browse/CL-2512 ). Basicaly there are two workarounds that might be considered instead: 1. Set a default...
by slechtaj
Thu Aug 23, 2012 9:33 am
Forum: CloverDX (formerly CloverETL) Support
Topic: universal data writer character set
Replies: 2
Views: 3106

Re: universal data writer character set

Hi Kasturi,

The most common charset for these unicode issues is UTF-8.
by slechtaj
Thu Aug 23, 2012 9:12 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Running remote data migration
Replies: 1
Views: 2040

Re: Running remote data migration

Thank you for the email. If you would like to migrate your data from legacy DB to a new one, you do not need to install anything on neither server. You could use a JDBC connection to your remote DB. If that data are too huge to move over the network you might take into consideration our server versi...
by slechtaj
Thu Aug 23, 2012 9:09 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Running remote data migration
Replies: 1
Views: 2040

Running remote data migration

I am an IT developer, tasked with a rather complicated data migration. I have never worked on a large data migration before so forgive me if my questions are novice. I am evaluating tools. I really like what I see in your product. I have downloaded the community version and have some question after ...