Upcoming Webinar : Leveraging Web Data For Advanced Analytics

On 6th Dec, 11.00 AM to 12.00 PM ( EST) 4.00 PM to 5.00 PM ( GMT )

TechMobius

Fully managed data aggregation service

Mobito Case Study

Problem Statement

A leading petrochemical market info provider needed to develop and maintain an automated system to harvest freely available gas flow, demand, and storage data published in TSO, SSO, and LSO websites across Europe, normalize into desired values and deliver the output to feed gas fundamentals data
product.

A manual approach to resolving the business need would have cost more than 20 times the current solution.

Our solution

  • An end-to-end ETL solution was built using Microsoft SQL Server Integration Services with PERL crawlers for extraction purposes. Customized bots monitor & gather data whenever published.
  • XML data files were uploaded to the client SFTP every hour, with alerting mechanisms for any delay or failures in the pipelines.
  • A web-based client dashboard was designed to monitor the status of every bit as well as to track issues reported and data delivered.

Contact us for a solutions demo: