Blog Post

What is the ATP Database?

Oracle Autonomous Transaction Processing is a fully automated database service optimized to run transactional, analytical, and batch workloads concurrently.

STEP 1: Navigate to the OIC login page using following URL  https://urldefense.com/v3/__https://design.integration.ca-montreal-1.ocp.oraclecloud.com/?integrationInstance=oic3-partners-bots4saas-yu__;!!N8Xdb1VRTUMlZeI!iKe6knNXh2u9_9i5pqq8lkQHtL53p8Q3Dvr7sazYsfTRMs8VCH3DKmMQezUh4D7LC28ll19tZ6eA3D3hEVjoCeNB$

STEP 2: Log in to Oracle Cloud Gen3 and sign in with Credentials

STEP 3: Click on the Hamburger icon as shown in the below image

STEP 4: Navigate and click on Design

STEP 5: Navigate to Connections and click on ‘Create’

STEP 6: Once the Create connection dialog box opens search for ‘Oracle ATP’ and select it

STEP 7: Fill in the details as shown below and select the action as ‘Tigger and invoke’

STEP 8: Provide the following credentials as shown below

STEP 9: Navigate to ‘Optional properties’ and provide the ‘Service Name’ and click on Save

STEP 10: Click on ‘Test’ to test the configuration and again click on ‘Save’

STEP 11: Again navigate to ‘Connections’ and click on ‘Create’

STEP 12: Select REST Connector by clicking on Create connection

 STEP 13: Provide the details as shown below

Step 14: Provide the details as shown below

STEP 15: Select the security policy as “Basic Authentication” and click on ‘Test’ followed by ‘Save’

STEP 16: Navigate to Integrations

STEP 17: Click on “Create” to create a new process

STEP 18: Select “Application” to create an integration

STEP 19: Provide the following details as shown below

STEP 20: A page like below will open for creating processes

STEP 21: Select the Rest Connector shown below

STEP 22: Provide the following details as shown below image and select the HTTP method as ‘Get’ and provide the resource URL

STEP 23: Select the 2 checkboxes as shown below to add ‘Query Parameter’ and to add ‘Response Profile’ respectively

STEP 24: Add the ‘Query Parameter’ and click on continue as shown below

STEP 25: Select the response payload format as ‘JSON Sample’

STEP 26: Click on ‘Inline’ to provide the response sample profile

STEP 27:  Provide the response profile in below format and click on continue

STEP 28: Select the media-type of Response Body as JSON

STEP 29: Click on the checkbox for “Add Another Operation” and click on Continue

STEP 30: Provide the details as shown below

STEP 31: Select the checkbox shown in the below image

STEP 32: Select the requested profile as ‘JSON Sample’ and click on Continue

STEP 33: Select the checkbox “Add Another Operation” and click on Continue

STEP 34: Provide the details below. Select the action as ‘POST’ and click on continue

STEP 35: Select the 2 checkboxes like shown below to receive ‘Query Parameter’ and ‘Request Payload’ and click continue

STEP 36: Add the query parameter ‘Id’ and select the Data Type as ‘String’ and click on Continue

STEP 37: Select the request payload as JSON Sample and click on ‘Inline’

STEP 38: Provide the requested profile shown below and click on Continue

STEP 39: Select the Request Body as JSON and click on Continue

STEP 40: Select the checkbox “Add Another Operation” and click on Continue

STEP 41: Provide the following details as shown in below image and select the action as ‘POST’

STEP 42: Select the checkbox to receive the query parameter and click on continue

STEP 43: Click on ‘ADD’ to add ‘Query Parameter’ like the below image select ‘Data Type’ as ‘String’ and click on continue

STEP 44: Click on Continue

STEP 45: Click on Finish

STEP 46: The following page will open like below

STEP 47: Click on the (+) sign like shown below and select ‘ATP Invoke’

STEP 48: Provide the details like the below image and select the operation as ‘Update’ and select ‘Perform an Operation On a Table’ and click on Continue

STEP 49: Select the ‘Schema’, ‘Table Name’, and ‘Table Type’ according to your Database and click on ‘Search’

STEP 50: Table Names will appear as shown below image and click on the ‘>’ arrow

STEP 51: The selected table will be selected and moved to the next column and click on ‘Import Tables’

STEP 52: Select the Primary Key as ‘ID’ and click on Continue

STEP 53: Click on Continue

STEP 54: Click on Finish

STEP 55: The following page will open like below and select the ‘Map’

STEP 56: Open the ‘Map’ Shape and map the following like shown below and click on ‘Validate’

STEP 57: The following page will open like below

STEP 58: Click on the Trackable Field and click on (I) and add the trackable field like shown below and click on ‘Save’

STEP 59: Click on the (+) sign like shown below and select ‘ATP Invoke’

STEP 60: Provide the details like the below image and select the operation as ‘Insert’ and select ‘Perform an Operation On a Table’ and click on Continue

STEP 61: Select the ‘Schema’, ‘Table Name’, and ‘Table Type’ according to your Database and click on ‘Search’

STEP 62: Table Names will appear as shown in below image and click on the ‘>’ arrow

STEP 63: The selected table will be selected and moved to the next column and click on ‘Import Tables’

STEP 64: Select the Primary Key as ‘ID’ and click on Continue

STEP 65: Click on Continue

STEP 66: Click on Finish

STEP 67: The following page will open like below and select the ‘Map’ and click on ‘Edit’

STEP 68: Map the following like shown below and click on ‘Validate’

STEP 69: Click on the Business Identifiers and click on (I)

STEP 70: Add the trackable field like shown below and click on ‘Save’

STEP 71: Click on the (+) sign like shown below and select ‘ATP Invoke’

STEP 72: Provide the details like the below image and select the operation as ‘Update’ and select ‘Perform an Operation on a Table’ and click on Continue

STEP 73: Select the ‘Schema’, ‘Table Name’, and ‘Table Type’ according to your Database and click on ‘Search’

STEP 74: Table Names will appear as shown in below image and click on the ‘>’ arrow

STEP 75: The selected table will be selected and moved to the next column and click on ‘Import Tables’

STEP 76: Select the Primary Key as ‘ID’ and click on Continue

STEP 77: Click on Continue

STEP 78: Click on Finish

STEP 79: The following page will open like below and select the ‘Map’

STEP 80: Open the ‘Map’ Shape and map the following like shown below and click on ‘Validate’

STEP 81: The following page will open like below

STEP 82: Click on the Trackable Field and click on (I) and add the trackable field like shown below and click on ‘Save’

STEP 83: Click on the (+) sign like shown below and select ‘ATP Invoke’

STEP 84: Provide the details like the below image and select the operation as ‘Select’ and select ‘Perform an Operation On a Table’ and click on Continue

STEP 85: Select the ‘Schema’, ‘Table Name’, and ‘Table Type’ according to your Database and click on ‘Search’

STEP 86: Table Names will appear as shown in below image and click on the ‘>’ arrow

STEP 87: The selected table will be selected and moved to the next column and click on ‘Import Tables’

STEP 88: Select the Primary Key as ‘ID’ and click on Continue

STEP 89: Click on Continue

STEP 90: Click on Finish

STEP 91: The following page will open like below and select the ‘Map’

STEP 92: Open the ‘Map’ Shape and map the following like shown below and click on ‘Validate’

STEP 93: The following page will open like below

STEP 94: Click on the Trackable Field and click on (I) and add the trackable field like shown below and click on ‘Save’

STEP 95: Click on Save and close the integration process

STEP 96: Click on the Activate button shown below to activate the integration process

STEP 97: Select the tracing level as ‘Audit’ and click on ‘Activate’

STEP 98: After Activation click on ‘Run’ to run and test the Process

STEP 99: Select the operation as ‘InsertDetails’ from the dropdown and pass the body like shown below and click on ‘Run’

STEP 100: Navigate to Database UI and you can see data inserted successfully in the database

STEP 101:I have added some more data into the database by following the Step 99

STEP 102: Now, select the Operation as ‘UpdateDetails’ from the Operation Dropdown and pass the ‘Query Parameter’ to update the details in  the database and also pass the body like the below image

STEP 103: Navigate to DatabaseUI and you can see the field got successfully executed

STEP 104: Now, select the Operation as ‘DeleteDetails’ from the Operation Dropdown and pass the ‘Query Parameter’ and click on ‘Run’

STEP 105: Navigate to DatabaseUI and you can see the field gotsr successfully executed

STEP 106: Now, select the Operation as ‘FetchDetails’ from the Operation Dropdown and pass the ‘Query Parameter’ and click on ‘Run’

STEP 107: You Can see the details according to the respective ID and the following details below