This blog is in continuation to my previous blog where I have explained about the Private Endpoint and how we can create a connection to a ATP in Private Subnet. If you have not read that I would highly recommend to read that before we create integrations using the connection.
Connection to private ATP is created successfully and now ready to be used in a integration. But before we create Integration, remember to create a table in ATP Database. For this demo I have used the following script and created a Sales Order Table.
(
ORDER_ID NUMBER,
REGION VARCHAR2(33 BYTE),
COUNTRY VARCHAR2(21 BYTE),
ITEM_TYPE VARCHAR2(15 BYTE),
SALES_CHANNEL VARCHAR2(7 BYTE),
ORDER_PRIORITY VARCHAR2(1 BYTE),
ORDER_DATE DATE,
SHIP_DATE DATE,
UNITS_SOLD NUMBER,
UNIT_PRICE NUMBER(6,2),
UNIT_COST NUMBER(6,2),
TOTAL_REVENUE NUMBER(10,2),
TOTAL_COST NUMBER(10,2),
TOTAL_PROFIT NUMBER(10,2)
);
ALTER TABLE SALES_ORDERS MODIFY (ORDER_ID NOT NULL ENABLE);
ALTER TABLE SALES_ORDERS ADD PRIMARY KEY (ORDER_ID)
USING INDEX ENABLE;
And Insert few sample records in the table -
Create Integration to fetch Order detail and test integration
Login to Oracle Integration Console then Home > Design > Integrations and Create an App Driven Orchestration integration
Click on + sign and choose the REST Trigger Connection
Choose the Response json sample -
