Discuss

last person joined: 10 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.

Suggestions for ETL Engines

  • 1.  Suggestions for ETL Engines

    Posted Sep 11, 2017 16:09
    Hi All,

    I'm looking for recommendations for ETL engines that are cloud-based, relatively easy to use, and cost-effective. We've been using the on-premise version of Jitterbit for a number of years to move data from Salesforce to our public website and now need to upgrade to the cloud-based service (Harmony) at a cost that is almost twice what we are paying now. This does not include the cost of getting a developer to help us set up and integrate the data, and then maintain the application.

    If you have any suggestions for other services, I'd love to hear about them. I'm also interested in utilizing this engine to grab data from multiple sources as a way to create more robust data/analytics reports about our business processes and customers.

    Thanks,
    Tim

    ------------------------------
    Timothy Stockert
    Vice President of IT and Business Intelligence
    Council on Accreditation
    New York, NY
    tstockert@coanet.org
    ------------------------------
    2020 Nonprofit Technology Conference Logo  w/ Baltimore Skyline


  • 2.  RE: Suggestions for ETL Engines

    Posted Sep 12, 2017 08:51
    Talend- https://www.talend.com/ - is the leading open source tool, and you can take a look at how it's used with Salesforce here https://www.talendbyexample.com/talend-salesforce-reference.html

    Talend can serve as part of your infrastructure for data warehouse/lake and multi-platform reporting.



    ------------------------------
    Isaac Shalev
    http://www.sage70.com
    Stamford CT
    @Sage70
    isaac@sage70.com
    ------------------------------

    2020 Nonprofit Technology Conference Logo  w/ Baltimore Skyline


  • 3.  RE: Suggestions for ETL Engines

    Posted Sep 12, 2017 09:04

    OK – newbie question here @TimothyStockert: what's an ETL Engine?

     

    Tara Collins

    Director of Communications & Resource Development

    RUPCO, Inc. | 289 Fair Street | Kingston, NY 12401

    845 331-2140 ext. 276 office | 845 331-6217 fax | (607) 643-5148 cell

    supportive-housing-circle-50x50        facebook_sm50x50youtube_sm50x50twitter_sm50x50instagram_sm50x50

    This communication, including any attachments, may contain confidential information and is intended only for the individual whom it is addressed.  Any review, dissemination, or copying of this communication by anyone other than the intended is strictly prohibited.  If you are not the intended recipient, please contact the sender by reply email, delete and destroy original message.

     




    2020 Nonprofit Technology Conference Logo  w/ Baltimore Skyline