InfoCepts’ cloud transformation program used a three–phased approach – blueprint, migration, and modernization.
The blueprint phase focused on defining the overall cloud strategy; it included running three unique proof of concepts to identify best–fit choices for the cloud platform and technology. For the data platform, we compared Redshift, Snowflake, and IBM DB2 on Cloud. InfoCepts also proof–tested DevOps platforms such as Jenkins, Kubernetes, and Dockers, in addition to testing automation tools such as Tosca and UiPath. This phase also focused on identifying new capabilities to deliver business value and automation to improve system efficiencies.
The migration phase leveraged InfoCepts’ Quick to Cloud (Q2C) accelerator suite for automation. Q2C automated the 1) porting of tables, views and SQL databases; 2) rewiring of ETLs through technical metadata; and 3) migration of cubes, reports, and subscriptions. We implemented Tosca to automate post-migration validation of history data, incremental data, and reports. And we designed a test suite to support future incremental and steady-state regression testing.
The modernization phase focused on enabling new capabilities, such as business data cataloguing and self-service data science, for user adoption and self-service consumption. Additionally, our team implemented Octa–based, single sign-on along with Jenkins–based, one-click deployment capabilities to enhance the user experience, strengthen information security, and reduce manual efforts.
The migration involved moving over 1000+ data mart tables (many of them holding terabytes of data) and 10 years of history data to the cloud. We rewired over 25 source interfaces and over 500 workflows. We also moved over 2500 SQLs scripts, including a data audit framework.
On the analytics front, we migrated 600+ cubes, 23,000 reports, and 800+ subscriptions to the cloud. In addition, 1500+ users were migrated to the new platform.