How to schedule a BICC extract job from OIC and ftp the corresponding output file
Summary:
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.
Content (required):
What is the API to run a predefined BICC job ( Job created in BICC console).
- What is the response format
Tagged:
1