A large pharmaceutical company invited Full360 to migrate their Oracle data warehouse from their data center to the Amazon Cloud. We selected Vertica as the database of choice and performed a successful migration end to end.
The client desired to upgrade the capacity and performance of their Oracle DW. The licensing costs were prohibitive, and their staff and third-party staff augmentation team had no cloud experience. The applications supported by the Oracle DW was built over the course of 5 years by 20 DBAs and developers. With over 200 data feeds needing transforms including sftp from vendors, Salesforce extracts, Google analytics and market analysis data, this was considered a very complex set of applications to migrate. The arcane complexities of configuring Oracle at the limits of its capacity were costly to debug and causing divergence from best practices and simplicity.
Full 360 created custom producers for every unique data-feed and built a strucutured data lake. An integrated UI was built to control and schedule bulk uploads for all file clases, including built in flexibility to accomodate new feeds. All metadata for workflow control was built into the UI back-ended by DynamoDB. A three node Vertica cluster was installed into the cloud environment custom built by Full 360.
Working with staff and consultants based on the East Cost, the Full 360 team migrated the entire data warehouse that included financial, marketing, sales and inventory data in under six months.
Fanatical Dedication to fulfilling the Cloud's Promise, Mastering its complexity, and Delivering the Impossible.