We have third party entity required 3 figures from one of our company operations in daily basis.
Third party will have VM over cloud with small SQL DB “destination system” , our company operations has SQL DB “Source system”.
Our requirement to develop a batch enable us to share the data from source system to the destination system, the batch including not limited to the following feature:
1No direct or indirect link from destination system to source system.
2Batch running will be in daily basis with specific Scheduled “date and Hours”. This is required to be configurable in easy way
3Batch must reflect changes to the destination source after it shared “retrospective”
Any other feature