Cloud-to-Cloud 3rd Party Integration

/, Integration Development/Cloud-to-Cloud 3rd Party Integration
Cloud-to-Cloud 3rd Party Integration 2017-11-21T16:43:58+00:00

Project Description

Supporting Client’s 3rd-Party Application Team to Produce High-Performance Connection for Reporting

About Project

Period: May-Sep 2016

Client: AIMFleet & AdminiTrack

Subject: Connect Live Data into Tableau Reporting for Acquisition Reports

Integration between on-prem MSSQL database into a Cloud Instance of MySQL/Aurora AWS database infrastructure in secure and accessible data warehouse,

Our Task Was

At RYIT Solutions, we worked alongside the AdminiTrack.com task management system to incorporate their back-end data into a more available and customizable Cloud Database in the AWS architecture.

Data was then aggregated and visualized with a Direct Connection from AWS Aurora to Tableau Online Dashboards.

What We’ve Done

The connection was a dual effort to push data from the AdminiTrack data center into the RYIT Aurora cloud database where information would be reported on.

  • Data ETL (Extract, Transformation, Load)
  • Security setup and cloud accessibility
  • Custom Aggregations
  • Data Warehousing
  • Tableau Reporting
  • Scalable Reporting Infrastructure
  • Subscription Based Reporting Distribution

Result

Reports are still utilized regularly since development.

  • Over 6 Client of AIMFleet monitor Program Status
  • 24/7 Access to reports
  • View Tracker
  • Supportdesk Integration

Conclusion

Request data integration from on-premises data into cloud visuals today at supportdesk@ryitsolutions.com