Medialets is able to meet product release deadlines by implementing Integrate.io's ETL platform
”
“Integrate.io's user interface was by far better than anything else I'd seen as an ETL solution. Just an intuitive drag and drop. Nothing to install. Once the data pipeline is created, it's simple. Integrate.io has simplified the task of moving data or transforming data from one set to another set.”
Raymond Matos
Director of Ad Technology, Medialets
Challenge
Connect the Medialets API to Amazon Redshift and gathering aggregated results quickly.
Get data from MySQL into Redshift to process and move that data again - or copy data from Redshift into RDS.
Halt the need for multiple processes to move data between PostgreSQL to and through multiple databases.
Lack of time to build a tool from scratch.
Other tools required on-premise agents and were too cumbersome, requiring too much maintenance.
Solution
Implementing Integrate.io's data integration service gave Medialets the ability to quickly move and transform data to and from Amazon Redshift as well as other data stores, such as Amazon RDS.
Results
Integrate.io enabled Medialets to quickly and easily move data across multiple data centers on the cloud.
Instead of needing resources to deal with infrastructure, Medialets was able to focus on product development.
Having immediate access to all the data required allowed the company to easily meet the deadline to deploy their product.
Due to the success of the initial project, Medialets implemented Integrate.io on a secondary project rolling up their data from an hourly to a daily summary.
Simplify and speed up the ETL process of moving data to and from Amazon Redshift into different databases and, from multiple data structures and data centers.
Medialets and Integrate.io
Most of the ETL tools and services on the market required an agent both in Amazon and inside the network in their data center but the Medialets team didn't want an agent inside the system. The time needed to build the box, put the agent in, make sure it worked and continuously update it would essentially be the same amount of time as it would have taken their developers to build it in-house. Since Integrate.io's application could 'talk' to the database by opening a port and providing minimal information, it was the quickest, simplest option to prepare the product and meet the deadline. It was so simple in fact that Medialets expanded the scope of Integrate.io's usage to other projects.
Trusted by 1,100+ data and ops teams saving millions of IT tickets with Integrate.io
