OIC - Scheduled Orchestration

Here I will show the following:

• Create a FTP trigger and invoke type connection
• Create Scheduled Orchestration base integration which will poll file from a FTP location and insert the employee records into the Database using a existing DB connection.
• How to do Submit now and Add schedule operation 

Designer⇾Connections⇾Create

Choose FTP adapter

Provide the Name and  Description

Configure Connectivity

Provide Host, port and SFTP connection as Yes.

Configure Security

Provide the User and Password

Test and Save

FTP connection is done.

Designer⇾Integrations⇾Create

Choose Scheduled Orchestration style

Provide Name and package

Canvas opened

Drag and drop the created FTP connection

Now complete the setup for FTP polling part

Drag and Drop the existing DB connection

Complete the setup to insert the employees into the employees db table

Now do the mapping.

Adding file name to be polled in the 1st mapping. we can also map the from directory to be polled.

Add the tracking instance

Activate

\

Following file will be polled.

now doing the submit now

file polled successfully and inserted into the DB

From Tracking we can also monitor the flow

Now showing the Add schedule part