Discuss

last person joined: 6 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.
Short link: http://community.nten.org/ntendiscuss

1.  ETL Tool Platform of Choice

Posted Feb 07, 2017 10:46
"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 Feb 07, 2017 12:35

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

berner@freedomhouse.org

Skype: berner.freedomhouse

 

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

 






3.  RE: ETL Tool Platform of Choice

Posted Feb 07, 2017 18:00
ETL = extract, transfer and load tool 

------------------------------
Ilene Anesini
------------------------------



4.  RE: ETL Tool Platform of Choice

Posted Apr 02, 2017 09:05
I would look at Talend Open Studio (https://www.talend.com/download/talend-open-studio/) - they have some great open source/free tools for ETL... As with anything, there will be some technical aspects to the automation.

Hope this helps!

------------------------------
Sanjiv Teelock
President/CEO
Xceede Solutions
Washington, DC
------------------------------