Learn to replicate data from Autonomous AI Transaction Processing (ATP) to an Amazon S3 (Amazon Simple Storage Service) using OCI GoldenGate.

To successfully complete this quicktart, you must have the following:

• A source Autonomous AI Transaction Processing (ATP) instance
• Amazon S3 Service
• Amazon S3 Access Key & Secret

1. Download and unzip the sample database schema.
2. In the Oracle Cloud console, select your Autonomous AI Transaction Processing (ATP) instance from the Autonomous AI Databases page to view its details and access Database Actions.
3. Unlock the GGADMIN user:
   1. Click Database actions, then click Database Users.
   2. Locate GGADMIN and then click its ellipsis menu (three dots) and select Edit.
   3. In the Edit User panel, enter the GGADMIN password, confirm the password, and then deselect Account is Locked.
   4. Click Apply Changes.
4. Load the source sample schema and data:
   1. From the Database actions menu, under Development, select SQL.
   2. Copy and paste the script from OCIGGLL_OCIGGS_SETUP_USERS_ATP.sql into the SQL worksheet.
   3. Click Run Script. The Script Output tab displays confirmation messages.
   4. Clear the SQL worksheet and then copy and paste the SQL script from OCIGGLL_OCIGGS_SRC_USER_SEED_DATA.sql.

      Tip:

      You may need to run each statement separately for the SQL tool to execute the scripts successfully.
   5. To verify that the tables were created successfully, close the SQL window and reopen it again. In the Navigator tab, look for the SRC_OCIGGLL schema and then select tables from their respective dropdowns.
5. Enable supplemental logging:
   1. Clear the SQL Worksheet.
   2. Enter the following statement, and then click Run Statement:

      ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA;

1. Create an Oracle deployment for the source Autonomous AI Transaction Processing instance.
2. Create a Big Data deployment for the target Amazon S3.
3. Create a connection for the source Autonomous AI Transaction Processing instance.
4. Create a connection to the target Amazon S3.
5. Create a connection to GoldenGate pointing to private end point of Big Data deployment, and then assign this connection to the source Oracle deployment.
6. Assign the Autonomous AI Transaction Processing connection to the source Oracle deployment.
7. Assign the Amazon S3 connection to the target Big Data deployment.

1. On the Deployments page, select the source Autonomous AI Transaction Processing deployment.
2. On the deployment details page, click Launch Console.
3. Log in with the source deployment's administrator username and password.
4. Add transaction information.
5. Add an Extract.

1. If using GoldenGate credential store, create a user for the Distribution Path in the target Big Data deployment, otherwise skip to Step 3.
2. In the source ATP GoldenGate deployment console, add a Path Connection for the user created in Step 1.
   1. In the source ATP GoldenGate deployment console, click Path Connections in the left navigation.
   2. Click Add Path Connection (plus icon), and then complete the following:
      1. For Credential Alias, enter GGSNetwork.
      2. For User ID, enter the name of the user created in Step 1.
      3. Enter the user's password twice for verification.
   3. Click Submit.

      The path connection appears in the Path Connections list.

3. In the source ATP deployment console, add a Distribution Path with the following values:
   1. On the Source Options page:
      • For Source Extract, select the Extract created in Task 2.
      • For Trail Name, enter a two-character name, such as E1.
   2. On the Target Options page:
      • For Target Host, enter the host domain of the target deployment.
      • For Port Number, enter 443.
      • For Trail Name, enter a two-character name, such as E1.
      • For Alias, enter the Credential Alias created in Step 2.
4. In the target Big Data deployment console, review the Receiver Path created as a result of the Distribution Path.
   1. In the target Big Data deployment console, click Receiver Service.
   2. Review the path details. This path was created as a result of the Distribution Path created in the previous step.

1. In the target Big Data deployment console, on the Administration Service Overview page, click Add Replicat (plus icon).
2. Add a Replicat with the following values:
   1. On the Replicat Information page, under Replicat type, select Classic Replicat, enter a Process Name, and then click Next.
   2. On the Replication Options page:
      • For Name, enter the name of the Trail from Task 2.
      • For Domain, select a domain.
      • For Alias, select the Amazon S3 connection created in Task 1.
      • For Checkpoint Table, select the checkpoint table you created for the target deployment.
   3. On the Managed Options page, leave the fields as they are, and click Next.
   4. On the Replicat Parameters page, replace MAP *.*, TARGET *.*; with:

      MAP SRC_OCIGGLL.*, TARGET *.*;

   5. On the Properties File page, configure the S3 Event Handler properties as needed. Some properties to consider modifying include:
      • gg.eventhandler.s3.region: provide the AWS region for the target S3 bucket
      • gg.eventhandler.s3.bucketMappingTemplate: provide target S3 bucket name. If bucket does not exist, it can be auto created by OCI GoldenGate. You can provide static bucket names or you can use Template Keywords to assign bucket names dynamically.
      • (Optional) gg.eventhandler.s3.format: Select how to format the output. JSON is the default setting. Available options include:
        • delimitedtext
        • json
        • json_row
        • xml
        • avro_row_ocf
        • avro_op_ocf
3. Click Create and Run.
   You return to the Overview page, where you can review the Replicat details.

1. In the Oracle Cloud console, open the navigation menu, select Oracle Database, and then select Autonomous AI Transaction Processing.
2. In the list of ATP instances, select your source instance to view its details.
3. On the database details page, click Database actions, then click SQL.
4. Enter the following into the worksheet and click Run Script:

   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1001,0,'Brendt','Paul','10 Jasper Blvd.',107,'(212) 555 2146',19,10);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1002,0,'McCarthy','Robin','27 Pasadena Drive',11,'(214) 555 3075',29,11);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1003,0,'Travis','Peter','7835 Hartford Drive',12,'(510) 555 4448',34,12);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1004,0,'Larson','Joe','87 Carmel Blvd.',13,'(213) 555 5095',45,13);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1005,0,'Goldschmidt','Tony','91 Torre drive',14,'(619) 555 6529',55,20);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1006,0,'Baker','William','2890 Grant Avenue',15,'(312) 555 7040',64,21);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1007,0,'Swenson','Jack','64 Imagination Drive',19,'(202) 555 8125',74,22);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1008,0,'Brendt','Paul','10 Jasper Blvd.',107,'(212) 555 2146',19,10);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1009,0,'McCarthy','Robin','27 Pasadena Drive',11,'(214) 555 3075',29,11);
   Insert into SRC_OCIGGLL.SRC_CUSTOMER (CUSTID,DEAR,LAST_NAME,FIRST_NAME,ADDRESS,CITY_ID,PHONE,AGE,SALES_PERS_ID) values (1010,0,'Travis','Peter','7835 Hartford Drive',12,'(510) 555 4448',34,12);

5. In the source ATP deployment console, select the Extract name, and then click Statistics. Verify that SRC_OCIGGLL.SRC_CUSTOMER has 10 inserts.
6. In the target Big Data deployment console, select the Replicat name, and then click Statistics. Verify that SRC_OCIGGLL.SRC_CUSTOMER has 10 inserts.

1. Monitor performance.
2. Manage Trail files.