This particular client had an existing MS Access macro which was used for complex data calculations within their database environment.
We designed a Talend Open Studio solution which generated a list of parameters from another data source and called an Access macro utilizing these parameters.
The jobs contains the following features:
- Iteration of list of parameters with MS Access macro
- Integration with MS Access and Talend through custom .bat files and the Tsystem component
- Use of TRunJob component for sub-process iteration