The Customer is a Global Supplier of Agricultural-based Liquid solutions and Bulk Liquid Storage Solutions. The Agricultural Liquid solutions business was sold out and hence the email Domain name in all the programs, data base objects and server components shall be updated to the new domain name.

Engagement Highlights

  • Email Ids extraction from all the Database and Application Objects.
  • Scripts for updating Email Domains for all the Database Objects.
  • Automating email Ids for all the Procedures and Packages.
  • Email Ids extraction and Updating from Unix Box and Shell scripts.
  • Updating more than 10,000 Email Ids with new Domain name for different Database objects.

How did we Deliver?

  • Developed Extraction Scripts for Database objects, Application Components and Server Components.
  • Consolidated the results and prepared a Unique Email List.
  • Developed update scripts and Updated the Domains for emails which we collected from Extraction scripts.
  • Created Value sets for Emails used in Procedures and Packages and modified the code to extract emails from that Value Set.
  • Developed Scripts to Update all the Emails in Application Objects.
  • Tested the solution and migrated to Production.

What Did Customer Like?

  • Delivering in aggressive time lines
  • Technical Expertise in delivering complex requirements