last person joined: 3 days ago 

Ask a question. Give advice. Share resources.
Looking for software or hardware recommendations? Want to know how others are using text messaging in their work? Trying to find examples of IT policies? The NTEN Discuss forum is a great resource for all of the above and more! It's the general discussion list for the NTEN community, and folks all over the US (and the world) are sharing their questions, answers, and news about nonprofit technology.

New to the group? Introduce yourself!
Reminder: Job posts are not allowed. Please visit the Nonprofit Tech Job Board to post a job or search for career opportunities.
Current organizers: Keith Berner and Ariel Jensen-Vargas
Short link: http://community.nten.org/ntendiscuss
Anyone can join and contribute to this group! Just create an account to get started.

1.  ETL Tool Platform of Choice

Posted 18 days ago
"Hi folks! What's your on-prem ETL tool/platform of choice? We have a bunch of use cases that need to run via service on a terminal/db server, 1) get an file off SSH server, move it to file server, decrypt, decompress and parse/place data onto Oracle server 2) (optional) during parsing, run data integrity checks, handle exceptions softly w/o having the job "bomb" out 3) (optional) perform other data transformations within the DB 4) (optional) use web services to integrate with REST API services 5) ETL tool is designed with emphasis with configuration over developer based solutions

Ilene Anesini

2.  RE: ETL Tool Platform of Choice

Posted 18 days ago

Thanks for this post, Ilene. For those who don't know, could you define "ETL"?


Keith Berner

Director, Information Technology

Freedom House


Phone/mobile: +1 202.747.7003


Skype: berner.freedomhouse


1850 M Street, NW, Fl 11, Washington, DC 20036 USA


3.  RE: ETL Tool Platform of Choice

Posted 18 days ago
ETL = extract, transfer and load tool 

Ilene Anesini