Extraction of collections data from unstructured DB to a structured DB
For a large ME Asian Telecom company
CLIENT & PROBLEM STATEMENT
- A large Telecom company required extraction of collections data from an unstructured database to a structured database.
- Need to transform data from MongoDB to Oracle DB for efficient reporting and further use.
APPROACH
- We extracted collections data from an unstructured database to a structured database.
- The process was quite complex as the data was extracted from multiple tables using logical queries by mapping common identifiers.
- We transformed data from MongoDB to Oracle DB for efficient reporting and further use.
SOLUTION & OUTPUT
- Successfully extracted and transformed collections data from MongoDB to Oracle DB.
- Data stored in Oracle DB, ready for reporting and further use.
