Add a Replicat for a Databricks target

Before you add the Replicat, ensure that you have the following:

• A Databricks connection created and assigned to your target Big Data deployment.
• Ensure that you review prerequisites specific to this target type.

1. In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Replicat (plus icon).
2. In the Add Replicat panel, on the Replicat Information page, complete the fields as needed, and then click Next:
   • For Replicat Type, select Classic Replicat.
   • Enter a Process Name, no more than 5 characters long.
   • Enter a Description, to help distinguish this process from others.
3. On the Replicat Options page, complete the fields as needed, and then click Next:
   • For Name, enter the name of the Trail from Task 2.
   • For Target, select Databricks.
   • For Available Aliases, select your Databricks connection.
   • For Available Staging Location, select Azure Datalake Storage.
   • For via staging alias, select your Azure Datalake Storage connection.
4. On the Managed Options page, leave the fields as is, and then click Next.
5. On the Parameter File page, replace MAP *.*, TARGET *.*; with the following, and then click Next:

   MAP SRC_OCIGGLL.SRC_CUSTOMER, TARGET <target_catalog_name>.<target_schema_name>.SRC_CUSTOMER

6. On the Properties File page, configure the File Handler and OCI Event Handler properties as needed. Some properties to consider modifying include:
   1. Provide the target Azure Datalake Storage container name in gg.eventhandler.abs.bucketMappingTemplate.
   2. Add gg.handler.databricks.fileRollInterval=5s.
7. Click Create and Run. If you click Create, then you can manually start the Replicat later from the Administration Service Home page.