Search found 841 matches

by avackova
Mon Oct 31, 2011 10:48 am
Forum: CloverETL Support
Topic: Dedup - From excel to SQL Server
Replies: 3
Views: 2271

Re: Dedup - From excel to SQL Server

Hello, it depends on your transformation. If you need to paste only these 2 columns to the database, use XLSDataReader, Dedup and DBOutputTable: XLSDataReader -- two fields mapped by fieldMapping in XLSDataReder --> Dedup --> DBOutputTable if you need more complicated transformation, you can put the...
by avackova
Wed Oct 26, 2011 3:54 pm
Forum: CloverETL Support
Topic: Generate a Report with total time taken,inputs output record
Replies: 1
Views: 1520

Re: Generate a Report with total time taken,inputs output record

Hello,
such reports are not available from CloverETL Designer. All these information can be obtained when using CloverETL Server.
by avackova
Wed Oct 26, 2011 10:20 am
Forum: CloverETL Support
Topic: Error message
Replies: 3
Views: 1932

Re: Error message

Hello, the message: ERROR [SocketReader] - Received error message from server: Record put for property "Name" must have an assignment in property "mdex-property_Type" is sent by the SocketReader element, which isn't (I believe) a standard CloverETL component provided by Javlin, b...
by avackova
Tue Oct 25, 2011 1:50 pm
Forum: CloverETL Support
Topic: DB_OUTPUT_TABLE output port 1- rows but no data
Replies: 7
Views: 3554

Re: DB_OUTPUT_TABLE output port 1- rows but no data

Hello, unfortunately it is not possible (I've found an issue in our bug tracking system for it - https://bug.javlin.eu/browse/CL-1200). If you have unique numeric field in the table you can sign it as AUTO_INCREMENT, than it will work even if you put there unique values explicitly. Another workaroun...
by avackova
Tue Oct 25, 2011 1:17 pm
Forum: CloverETL Support
Topic: Error message
Replies: 3
Views: 1932

Re: Error message

Hello,
this message is send by custom component (SocketReader). You need to ask provider of this component.
by avackova
Tue Oct 25, 2011 8:56 am
Forum: CloverETL Support
Topic: DB_OUTPUT_TABLE output port 1- rows but no data
Replies: 7
Views: 3554

Re: DB_OUTPUT_TABLE output port 1- rows but no data

Hello,
I've tried it with MySql and the keys are returned properly. Please check if you have column defined as AUTO_INCREMENT in your table.
by avackova
Thu Oct 20, 2011 12:25 pm
Forum: CloverETL Support
Topic: REFORMAT Component Throwing Null Values in OutPut
Replies: 2
Views: 2027

Re: REFORMAT Component Throwing Null Values in OutPut

Hello Naveen, you don't set any values to the output records if the condition matches. If you want just to copy the values from input to output, use defaultTransform(DataRecord[] inputRecords, DataRecord[] outputRecords) method: if (OBJECTNAME.contains(".aspx") || OBJECTNAME.contains("...
by avackova
Wed Oct 19, 2011 11:52 am
Forum: CloverETL Support
Topic: Web services in 2.9
Replies: 2
Views: 2386

Re: Web services in 2.9

Hello, since version 3.0 CloverETL contains graph RealWorldExamples/graph/graphWebServices.grf , that demonstrates usage of WebserviceClient component. You can download it from source forge page . Are you able to configure the component manually? Then, when running such graph, CloverETL would be mor...
by avackova
Wed Oct 19, 2011 9:29 am
Forum: CloverETL Support
Topic: Clover ETL 2.9 on multiple screen
Replies: 5
Views: 2347

Re: Clover ETL 2.9 on multiple screen

Please contact our sales department (sales@cloveretl.com) for detailed information.
by avackova
Tue Oct 18, 2011 2:06 pm
Forum: CloverETL Support
Topic: Clover ETL 2.9 on multiple screen
Replies: 5
Views: 2347

Re: Clover ETL 2.9 on multiple screen

Hello,
you can upgrade to the last released version before your upgrade validity time (to check the version available to you for downloading log-in in http://www.cloveretl.com and go to Licenses & Download section). You can also try the newest version for one month for free.
by avackova
Tue Oct 18, 2011 12:06 pm
Forum: CloverETL Support
Topic: Increasing the total Number of Records/Second
Replies: 1
Views: 1201

Re: Increasing the total Number of Records/Second

Hello Naveen, you can usually speed up reading data from database by optimizing the database. On the CloverETL side you can try to change value of the fetchSize attribute in DBInputTable. Increasing the value of the DEFAULT_INTERNAL_IO_BUFFER_SIZE property (see Program and VM Arguments ) can speed u...
by avackova
Tue Oct 18, 2011 9:54 am
Forum: CloverETL Support
Topic: How does clover ETL Write lines during DataTransform
Replies: 1
Views: 1476

Re: How does clover ETL Write lines during DataTransform

Hello Naveen, ⋅  Why do you think that CloverETL "is processing one line at a time"? DataParser (used by UniversalDataWriter ) formates one record to byte buffer and after it is full it flushes it to a file. ⋅  The best information about the interfaces and classes that ...
by avackova
Mon Oct 17, 2011 9:08 am
Forum: CloverETL for Java Programmers
Topic: Java and Clover ETL integration
Replies: 2
Views: 3203

Re: Java and Clover ETL integration

Hello, unfortunately you can't change the fileURL attribute in DataReader object; you need to create a new one, when you build a graph in java. When reading a graph from xml definition ( ransformationGraphXMLReaderWriter.loadGraph(in, runtimeContext.getAdditionalProperties()) ), you need to change t...
by avackova
Mon Oct 17, 2011 7:30 am
Forum: CloverETL Support
Topic: How to do condition when inserting records in Database
Replies: 3
Views: 1948

Re: How to do condition when inserting records in Database

Hello Naveen, as described in Documentation : The joined data is then sent to the first output port. The second output port can optionally be used to capture unmatched master records. That means that the 2nd DBOutputTable ("New data") inserts new records to the database table. DBJoIn just ...
by avackova
Fri Oct 14, 2011 3:25 pm
Forum: CloverETL Support
Topic: Microsoft SQL server connection I/O Error: SSO Failed
Replies: 1
Views: 1454

Re: Microsoft SQL server connection I/O Error: SSO Failed

Hello,
unfortunately this is the known issue (https://bug.javlin.eu/browse/CL-1195 - use guest/guest credentials to browse it). You need to copy ntlmauth.dll to system directory and restart CloverETL Designer.