Build your AWS Redshift data warehouse without coding

get it



You need to become a Contributor to join the discussion - Find out how.
Christian Romming
Christian RommingMaker@cromming
Coverage in VentureBeat today:
Jack Smith
Jack SmithHunterPro@_jacksmith · Serial Entrepreneur & Startup Adviser
From companies that I've spoken to, ETL is becoming a big problem, as companies start using nosql databases and things like amazon redshift. I think that Etleap has a lot of potential.
Ben Tossell
Ben Tossell@bentossell · Services for startups
@cromming why did you build this :)
Christian Romming
Christian RommingMaker@cromming
@bentossell Good question! At my previous company we spent a massive amount of development effort building and maintaining our data warehouse, but still our data analysts were frustrated: Pipelines would often fall behind, and they would have to wait for free dev cycles to get access to new data sources. I looked around and saw many companies were having the same problem. I thought there must be a better way. Etleap lets data analysts and scientists create data pipelines through our web UI. The data pipelines pull data from any source, and data transformations can be specified through an intuitive data wrangler UI. The transformed data is loaded into their Redshift data warehouse, where analysts can use the tools they know and love to do their analysis. Etleap takes care of operating the data pipeline over time, and provides simple workflows for handling issues that arise, like schema changes and parsing errors.
Tom O'Neill
Tom O'Neill@mopatches · Periscope
What kind of data transformations can Etleap do?
Christian Romming
Christian RommingMaker@cromming
@mopatches Analytics teams need to integrate data from different sources - some are structured (e.g. SQL DBs, Salesforce) and some are semi-structured (log files, CSVs). Etleap's approach is to let you interact with the raw data to set up your transformations, in a way that's similar to Stanford's data wrangler ( In addition to the usual suspects like splitting and extracting, we support common operators like parsing JSON objects/arrays and XML. Check out the screenshot at the top for an example!