How to schedule a BICC extract job from OIC and ftp the corresponding output file
We are planning to use OIC to extract data from Cloud ERP and load our data warehouse in Azure cloud SQL Server database. We would like to
- Use BICC extracts to generate flat files,
- Use OIC to Download/Stage the file and FTP it to Azure Cloud,
- Use Microsoft Azure Data Factory to process the csv extract and load the data warehouse
We are new to OIC. Would appreciate if you can share a recipe for this integration.
What is the API to run a predefined BICC job ( Job created in BICC console).
- What is the response format