Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!