Stack Overflow
Stack Overflow

Questions tagged [cloveretl]

Java based data integration framework; can be used to transform/map/manipulate data in various formats (CSV,FIXLEN,XML,XBASE,COBOL,LOTUS, etc.); can be used standalone or embedded(as a library). Connects to RDBMS/JMS/SOAP/LDAP/S3/HTTP/FTP/ZIP/TAR.

27 questions
3
votes
2 answers

CloudConnect and GoogleBigQuery

I'm currently trying to do the OAuth process in GoodData's CloudConnect (also known as Clover ETL). Does anyone have a guide or anything because the documentation is not clear on hot to set up OAuth 2.0 and i keep getting the error bearer=Bearer…
user2540238
  • 31
  • 1
2
votes
2 answers

How to change value for parameters using reformat component in Clover ETL

I am trying to find out a method on how to change the value of a parameter that I have defined and also how to create a new parameter dynamically using REFORMAT component in Clover ETL. I have written small logic in my transform method which…
Chaitanya
  • 15,403
  • 35
  • 96
  • 137
1
vote
1 answer

Clover ETL performance issue with processing large csv files with joins

I am using CloverETL tools to read through a large csv files with over 100,000 rows, translate some lookup values from a DB before inserting them to a DB table. Basically I used: A flat file reader to read in the file Followed by a number of…
Eric Chen
  • 13
  • 2
1
vote
2 answers

Extract report results with CloudConnect

I would like to extract raw report results within the CloudConnect process. So far I have managed to get response from the raw report API end point - https://secure.gooddata.com/gdc/app/projects/{project_id}/execute/raw/ This response contains URI…
Bulat
  • 6,869
  • 1
  • 29
  • 52
1
vote
1 answer

pass JVM args to clover in a ant script

I call runGraph class from CloverETL in a ANT script like this …
Elliot Landry
  • 42
  • 5
1
vote
1 answer

Which ETL tool do you recommend?

I am using Oracle as a database. We have decided to use another database and need to use ETL tool to transform the data from Oracle to that database. I have never worked in any ETL tool and also didn't know about it. After doing some web searching,…
Anand
  • 20,708
  • 48
  • 131
  • 198
0
votes
1 answer

Nested Query in SOQL

Can someone please help me generate SOQL for the below query. Getting this error - Nesting of semi join sub-selects is not supported SELECT External_ID_vod__c, FirstName, LastName, Middle_vod__c FROM Account where Id IN (select Account_vod__c from…
user18330473
  • 1
  • 1
  • 1
0
votes
1 answer

How to use pivot component in clover dx

Unable to use pivot component , please let me know with example how to use pivot and concatenation components in clover etl
Iamback
  • 86
  • 10
0
votes
1 answer

Connection abort during data transformation with CloverDX

I'm working on data transformations using CloverDX. When I run my graph, on my 5th SpreadsheetDataWriter component, it stops with the below error. Does anyone know how to debug the below error? This kinda works on my laptop(it only stops halfway…
danjok
  • 5
  • 1
0
votes
1 answer

How to build dynamic url for http connector in Clover ETL

How to build http dynamic url in http connector to map values from sql source in CloverDX? For now I have dbread component with selected one column (list of TAXIDs) in table which should be my dynamic attribute/parameter for url... I need to build…
GFajt
  • 1
0
votes
1 answer

CloverETL : How to connect to a server using ssh key

I have a clover job that used to connect and transfer files from sftp using File URL = sftp://${SFTP_USERNAME}:${SFTP_PASSWORD}@${SFTP_SERVER}/${SFTP_SOURCE_PATH}${SOURCE_FILE_MASK}, but now I need to change the approach and connect to the location…
Omkar Shanware
  • 1
  • 1
0
votes
0 answers

HTTPConnector - Not able to send bearer token in cloveretl httpconnector

Code Transformation function integer transform() { $out.0.requestContent = $in.o.json_file; $out.0.charset = "UTF-8"; $out.0.URL = "https://api.abcd.com/applicationname/apiname"; $out.0.requestMethod = "POST"; …
Omkar Shanware
  • 1
  • 1
0
votes
1 answer

Extracting json data in Clover ETL

How do I extract JSON values along with keys using Xpath in Clover ETL{"code": "in","percent": 83}? Eg :-. For the JSON object in the example I don't want just values i.e [in,83] I also want keys with them i.e ["code": in,"percent": 83]
Digvijay Nalawade
  • 1
0
votes
1 answer

Taking least significant bit of a byte in cloverETL

I'd like to generate a pseudo-random binary number in CloverETL from an integer, as a function that should be computable from outside of CloverETL. My approach to do that was to : - salt my integer and hash it with md5 - taking the last bit of this…
WNG
  • 3,705
  • 2
  • 22
  • 31
0
votes
1 answer

CloverETL DBOutputTable - Update Statement Won't Complete

I'm running a process that updates flags in a SQL Server database table. Essentially, the graph reads a .csv file, then uses the variables in the update statement. The universal reader is completing but the DBOutputTable component is hanging and…
bluthco
  • 19
  • 2
1
2