Stack Overflow
Stack Overflow

Questions tagged [scriptella]

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows the use of SQL or another scripting language suitable for the data source to perform required transformations.

64 questions
5
votes
1 answer

Is there any way I can pass variables to scriptella e.g. environment or -D parameter?

I need to invoke same xmls with slight variation in certain parameters. I thought of writing etl.properties, but then I realize I have to write the properties file name in the xml and that is not what I want. Ideally I was looking for to pass…
Manish Sapariya
  • 3,575
  • 3
  • 25
  • 34
4
votes
3 answers

Convert XML to CSV with Scriptella, how to get attribute values?

I found an example of converting XML to CSV,In the example used, this structure Empire Burlesque Bob Dylan USA …
falcon_sapsan
  • 41
  • 5
4
votes
1 answer

Scriptella and CSV column headers that contain spaces

I am attempting to move data from CSV files into a database table, and I'd like to use the column header names in the script. For example:
Josh
  • 71
  • 4
4
votes
2 answers

Scriptella - How to get and re-use autogenerated ids?

I'm using Scriptella for ETL operations, working with many tables referenced with autogenerated ids. I want to re-use these ids without using subqueries, this is my script fragment of the etl file: